select and search prompt options

[karthik12345]

Hi all

I am using select and search prompt, if user press '?' (Question mark), he have to see all the data in search box.
How can I get this requirement..

Thanks in advance,
Karthee

[navissar]

Persuade your user to use '%' instead of '?'. Putting in a percent sign would show all data out of the box.

[karthik12345]

ok,
 
    how can i do this, can you please explain.

Thanks,
Karthee

[Lynn]

Type a % in the keywords box and click the search button.

[karthik12345]

Thanks Lynn,
   
       How can i use '?' instead of '%'.
       

Regards,
karthee

[Michael75]

Two ideas come to mind. Either create a Request for Enhancement (RFE) on this site: https://www.ibm.com/developerworks/rfe/

Or, if you don't get any joy there, try the following:

1. Prise the '?' key out of the user's keyboard
2. Prise the '%' key out of the user's keyboard
3. Place the '?' key (that's now loose) where the '%' key used to be
4. Place the '%' key (that's now loose) where the '?' key used to be
5. Repeat 1 thru 4 for each affected user

HTH

[navissar]

Even if there's a way (I can think of 2 theoretically) - it would mean writing, maintaining and upgrading code specifically written for the sole purpose of the user typing in a question mark instead of a percent sign. I'm usually all for hacking the hell out of Cognos, but even I can see that it is utter madness.

[navissar]

Oh! Wait! I have a very simple solution: In the query that makes the SnS prompt concatenate a question mark to each value. Then a search for ? will return all values... *drops mic*  8)

[BigChris]

Whilst being completely unnecessary, this is a pure lateral thinking at its finest

Oh! Wait! I have a very simple solution: In the query that makes the SnS prompt concatenate a question mark to each value. Then a search for ? will return all values...

If I wore a hat I'd take it off to you sir!

[Lynn]

Oh! Wait! I have a very simple solution: In the query that makes the SnS prompt concatenate a question mark to each value. Then a search for ? will return all values... *drops mic*  8)

Outstanding, although I must say I enjoyed Michael75's answer as well  ;D

[navissar]

Ah, you're too kind.
Michael's solution is great, but it doesn't cater for mobile devices!  :)
I'll put this here as an ode to weird requirements. https://youtu.be/BKorP55Aqvg

[MFGF]

Ah, you're too kind.
Michael's solution is great, but it doesn't cater for mobile devices!  :)
I'll put this here as an ode to weird requirements. https://youtu.be/BKorP55Aqvg

I love this forum! Outstanding!!! :)

MF.

[Michael75]

Michael's solution is great, but it doesn't cater for mobile devices!  :)

Shucks, I should have put my thinking cap on first  :-[