Print Page - select and search prompt options

Title: select and search prompt options
Post by: karthik12345 on 19 Apr 2016 05:50:47 AM

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

Title: Re: select and search prompt options
Post by: navissar on 19 Apr 2016 07:22:09 AM

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

Title: Re: select and search prompt options
Post by: karthik12345 on 19 Apr 2016 09:37:35 AM

ok,

how can i do this, can you please explain.

Thanks,
Karthee

Title: Re: select and search prompt options
Post by: Lynn on 19 Apr 2016 09:48:40 AM

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

Title: Re: select and search prompt options
Post by: karthik12345 on 20 Apr 2016 07:36:04 AM

Thanks Lynn,

How can i use '?' instead of '%'.

Regards,
karthee

Title: Re: select and search prompt options
Post by: Michael75 on 20 Apr 2016 02:10:18 PM

Two ideas come to mind. Either create a Request for Enhancement (RFE) on this site: https://www.ibm.com/developerworks/rfe/ (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

Title: Re: select and search prompt options
Post by: navissar on 21 Apr 2016 07:40:39 AM

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.

Title: Re: select and search prompt options
Post by: navissar on 21 Apr 2016 07:43:44 AM

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)

Title: Re: select and search prompt options
Post by: BigChris on 21 Apr 2016 08:03:59 AM

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

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

Title: Re: select and search prompt options
Post by: Lynn on 22 Apr 2016 02:39:26 AM

Quote from: Nimrod Avissar on 21 Apr 2016 07:43:44 AM
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

Title: Re: select and search prompt options
Post by: navissar on 22 Apr 2016 06:21:22 AM

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

Title: Re: select and search prompt options
Post by: MFGF on 22 Apr 2016 08:20:02 AM

Quote from: Nimrod Avissar on 22 Apr 2016 06:21:22 AM
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.

Title: Re: select and search prompt options
Post by: Michael75 on 22 Apr 2016 12:15:52 PM

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

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: karthik12345 on 19 Apr 2016 05:50:47 AM