one query item has two filter

[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!!

[raj_tumati]

hi,
   i think its not possible.

[raaj]

hi,
   i think its not possible.

thanks
   Raj

[trevorp]

Hi

Why not use the standard "Select and Search" prompt

[raj4cognos]

hi,
    using static filter and dynamic filter we can apply it.

[Venu_Gollapudi]

Hi,

Trevor is correct, thats the best thing which we can do for this kind of Scenario.

Regards,
G.V.

[wrightr]

Try this filter:

(character_length([StudentName] > 9
and [StudentName] = ?para?)

or

(character_length([StudentName] <= 9
and [StudentName] contains ?para?)