Original Message:
Sent: Mon April 17, 2023 10:18 AM
From: Stephan Quintelier
Subject: Search And Select Prompt, default option
Hi Andrew,
Thank you for your reply! I am familiar with Cogbox, but the Search and Select prompt in Cogbox is to slow for the amount of data it has to process (around 40000 rows). When I type a character in the prompt, it takes about a second before I can type the next one. I guess it first searches all the data to come up with the relevant ones before proceeding with the next character.
For this reason, I went back to the original Search and Select prompt (type all the relevant characters and then click the button). The only issue with this prompt is that our users forget to change the default option "Start with ..." to "contains any of ...". Therefore I am looking for a custom control that can do this for me. In Cognos 10, this script was embedded in an HTML element, but that is no longer possible. What I'm looking for is a simular script, but that can be uploaded to the server and adressed by a custom control.
The issue has been adressed on the internet a couple of times, but I can't find a working solution.
kind regards,
Stephan
------------------------------
Stephan Quintelier
Original Message:
Sent: Thu April 13, 2023 08:14 AM
From: Andrew Stalker
Subject: Search And Select Prompt, default option
Hi Stephan,
Since you're already looking at earlier posts by Cognospaul - it sounds like you may want to check out his excellent Cogbox collection of tools - I know there's prompt customization features in there - here's a direct link to the IBM Accelerator Catalog entry for it where you can find further info:
https://accelerator.ca.analytics.ibm.com/bi/?pathRef=.public_folders%2FIBM%2BAccelerator%2BCatalog%2FContent%2FTOL00011
------------------------------
Andrew Stalker
Original Message:
Sent: Wed April 12, 2023 05:27 AM
From: Stephan Quintelier
Subject: Search And Select Prompt, default option
Hi all,
I'm desperately looking for a custom control that can resize and change the default option (start with one of these keywords) of a Search and Select prompt.
I came across the post "Setting the default search type in Cognos 11 interactive mode" (dtd Nov 25, 2018) from Cognospaul, but I keep getting a Javascript error (Cannot read properties of null ...). Considering the date of the post, is there an updated version of the control available?
Or are there other ways to implement a search box, where you can type in a (part of a) search string and then select an entry? The list to search is quite large (about 40000 rows)
Thank you very much for your response, I've been looking for a solution for months now :-(
with kind regards,
Stephan
------------------------------
Stephan Quintelier
------------------------------