Radicore Forum: How To » curr_or

Home » RADICORE » How To » curr_or_hist='C' and output2

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

curr_or_hist='C' and output2 [message #2308]

Wed, 09 September 2009 11:58

gpatti
Messages: 283
Registered: August 2008

Senior Member

Tony,
I think that the use of curr_or_hist='C' is no longer working with output2 tasks. I have a report that used to filter for current transactions only, that now seems to be returning all transactions.

Report message to a moderator

Re: curr_or_hist='C' and output2 [message #2309 is a reply to message #2308]

Wed, 09 September 2009 12:32

AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK

Senior Member

How is "curr_or_hist='C'" defined in the OUTPUT2 task? It has to be placed into the WHERE string before it can be processed, so where is is defined? If it is being defined can you step through with your debugger to see where it is being ignored?

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: curr_or_hist='C' and output2 [message #2310 is a reply to message #2308]

Wed, 09 September 2009 13:09

gpatti
Messages: 283
Registered: August 2008

Senior Member

It is set in the fixed selection field of the task definition. I've also tried placing it in the sql_where definition of the php controller.

I'll try stepping through with the debugger to see what's happening.

Report message to a moderator

Re: curr_or_hist='C' and output2 [message #2311 is a reply to message #2310]

Wed, 09 September 2009 13:52

AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK

Senior Member

The pseudo-column 'curr_or_hist' is only valid as part of any additional search criteria, so must be placed in 'selection_temporary' instead of 'selection_fixed'.

This is documented in FAQ53 item #4.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: curr_or_hist='C' and output2 [message #2312 is a reply to message #2308]

Wed, 09 September 2009 14:07

gpatti
Messages: 283
Registered: August 2008

Senior Member

Thanks - that's fixed it. I was convinced it was working previously, so I'm either mistaken, or it was working by chance until a recent version.

Report message to a moderator

Previous Topic:	List Report Question
Next Topic:	List View page break after additional rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 28 14:26:48 EST 2024

Total time taken to generate the page: 0.03944 seconds