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

Operators "="

Started by Nickbruno, 16 Jul 2015 01:11:53 PM

Previous topic - Next topic

Nickbruno

Hi, does the "=" operator work for multiple criteria? so...

[ORG]='10','12','15'

Will = work for multiple criteria or on one ex. just org 10?

If not is there a command that works to look for multiple criteria?

Thanks!

bus_pass_man

try [ORG] in ('10','12','15')

The single quotes indicate that the values are strings.   If they are numeric you would not need to use them.  You ought to match the data type of the query item which you are using as the operand. 

Nickbruno

Awesome! Worked Great!