Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having problem to convert this expression to Set analysis......Thanks
=count(if(CDE <> null() and (TYPE_CDE = '00001' OR MAC_CDE = null()) and STATUS <> 'CANCEL' and REQUEST= 1,ORDER))
Try this
Count({<CDE={*},TYPE_CDE={'00001'}, STATUS={*}, REQUEST={1}> + <CDE={*},MAC_CDE-={*}, STATUS={*}, REQUEST={1}>} ORDER)
HI,
For the condition (TYPE_CDE = '00001' OR MAC_CDE = null()), I recommend to create a flag in the script, something like:
select *,
if(TYPE_CDE = '00001' OR isnull(MAC_CDE),1,0) as Flag_CDE
from ...
Then the expression should be:
count({$<CDE={*},STATUS-={'CANCEL'},REQUEST={1},Flag_CDE={1}>} ORDER)
Hope this helps
Regards!
Try this
Count({<CDE={*},TYPE_CDE={'00001'}, STATUS={*}, REQUEST={1}> + <CDE={*},MAC_CDE-={*}, STATUS={*}, REQUEST={1}>} ORDER)
Thankyou Celembarasan, I am bit confused......Actually I am having lot of conditions but I mentioned the key conditions where I was having problem.....for representing OR condition Is this the only way, need to specify all the conditions again....Thanks
The way to handle OR condition suggested by Gabriela allows to avoid repeating all over again. Apparently you need to modify the script in this case.
Regards,
Michael