Record Selection 2

[sim133]

Hi Everyone;
I have a field that has 'on' and null values in the table. I was wondering how I could create the if statement in record selection to select the 'on' values only or the null values or both using a parameter. This is what I tried, it works for on and null values , but not when I select 'all'

(if {?actStatus} = 'COMP' then
{ACTION_ITEMS.ACTI_COMPLETED} = 'on'
else if {?actStatus} = 'PEND' then
isnull({ACTION_ITEMS.ACTI_COMPLETED})
else if {?actStatus} = 'ALL' then
isnull({ACTION_ITEMS.ACTI_COMPLETED}) or{ACTION_ITEMS.ACTI_COMPLETED} = 'on' )

 

[Turkbear]

Hi,
Rewrite the code as this:

(
if {?actStatus} = 'ALL' then
True
else 
 if {?actStatus} = 'COMP' then
   {ACTION_ITEMS.ACTI_COMPLETED} = 'on'
 else 
  if {?actStatus} = 'PEND' then
   isnull({ACTION_ITEMS.ACTI_COMPLETED})
)

The 'True' boolean means return ALL the records..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Check the Database->Show SQL Query, it may not get passed as written, depending upon the software version (please post basic info), I would use:

(
if {?actStatus} <> 'ALL' then
if {?actStatus} = 'COMP' then
{ACTION_ITEMS.ACTI_COMPLETED} = 'on'
else
if {?actStatus} = 'PEND' then
isnull({ACTION_ITEMS.ACTI_COMPLETED})
else if {?actStatus} = 'ALL' then
True
)

You might review my FAQ for similar advanced topics:

faq767-3825

-k