Writing prompts in sql query

[saumil287]

Hi All,

I am having a requirement where the filter condition should be prompted

The Condition after where clause should be prompted dynamically to enter the filter conditions

I am taking a datasource query subject and pasting a query inside a sql dialog.
the condition after where clause must be prompted.
eg:
where #prompt('AddCondition','Character','A.LM_LnCode=''00003407'' and A.Lm_AYear=''29''')#

I tried but no luck .

I there any other way I can achieved this.

Thanks & Regards
saumil

[blom0344]

a prompt is essentially a dynamic filter. Cognos offers a bunch of filters, so there is no need to work in the logic the way you do. Try using the tool as it is designed..