If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

using parameters in query

Started by morphy, 10 Nov 2008 04:07:29 AM

Previous topic - Next topic

morphy

Hi All,

a simple question 4 u.

Is it possible to insert a parameter in the query?

Example:

select evt_code, evt_org from EVENTS
where evt_org =?org?

Where  ?org? is a parameter previously created in order to let the customer
choose the organization.

Thanks in advance.
Matt

Suraj

yes;but only one data item for one condition at a time...

if (evt_org = ?org?) then (evt_code)
else null