check the value of prompts in FM

[JO]

Hi,

I have a query which executes based on prompt value in FrameworkManager say

Select * from table1 where table1.column1=#prompt('Number','Integer')#

How to apply filter based on prompt value, say if prompt value is 0 then 10 else 20 to table1.column1 in frameworkmanager.

I am not able to check the value of propmts,

can anyone tell me how to do it?

Cheers
JO

[sridhar_world]

try something like below...

create a filter with the expression below and add the filter into the Query subject...

table1.column1  =  if(#prompt('Number', 'integer')# = 0) then (10) else (20)

let us know if your problem is solved...

Regards,
Sri

[JO]

Hi

These is not working.  giving some syntax error.

Cheers
Jo

[sridhar_world]

It does work for me when i tried the expression inside a filter...

r u adding the expression directly to the SQL? that doesn't work... u need to create a filter and add the filter to the query subject...

Regards,
Sri