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

how make one query item has two filter?

Started by silywiwi, 17 Oct 2007 10:20:23 PM

Previous topic - Next topic

silywiwi

   hi all! me too:)
   i want to give a query item  two filter
   the query item accept the parameter by prompt page
   the name of query item is 'studentName',
   when the length of parameter greater than 9, i will use "studentName = ?para?"
   else i will use "studentName contains ?para?"
  how can i  make the requirement come true?
  thanks in advance!!

almeids

Use filter:
(length(param)>9 and (studentname=param)) or (length(param<=9) and (studentname contains param))