Conditional security filters

[platipuss]

What I am trying to do logically is

Code Select Expand

if(#prompt('pmt','INTEGER','-1')# > 0)
then(
     data item in (select * from table where id = #prompt('pmt','INTEGER','-1')#)
)
else(
     do nothing
)

I know the filter will except something like

Code Select Expand

dataitem = if(1=1)then( 1 ) else ( 0 )

but I don't see a way to solve this problem with that syntax.

Thank you

[platipuss]

if (a) then
(b)
else
(c)

Use:

(a and b) OR ((not a) and c)

Just thought I would share