Print Page - Writing prompts in sql query

Title: Writing prompts in sql query
Post by: saumil287 on 21 Nov 2013 07:23:17 AM

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

Title: Re: Writing prompts in sql query
Post by: blom0344 on 22 Nov 2013 12:19:08 PM

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..

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: saumil287 on 21 Nov 2013 07:23:17 AM