Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
  • 1.  Search And Select Prompt, default option

    Posted Wed April 12, 2023 05:28 AM

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


  • 2.  RE: Search And Select Prompt, default option

    Posted Thu April 13, 2023 08:14 AM

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



  • 3.  RE: Search And Select Prompt, default option

    Posted Mon April 17, 2023 10:18 AM

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



  • 4.  RE: Search And Select Prompt, default option

    Posted Wed April 19, 2023 09:37 AM

    Hi Stephan,
      Sorry I've not found such a script for C11 (it'd be a custom control extension) but if I find one or develop a new one I'll let you know.

    Cheers,
    Andrew



    ------------------------------
    Andrew Stalker
    IBM
    ------------------------------



  • 5.  RE: Search And Select Prompt, default option

    Posted Fri April 21, 2023 04:07 AM
      |   view attached

    It's only recently that CA had a search/select prompt available for data modules. Meaning that I wrote my own search/select prompt. I have uploaded an example report using this prompt. 
    You will see it actually consists of many prompts working togther. One of these allows you to select the operator - Contains, Starts With, Ends with etc. You can change the default selection on this prompt to whatever you would prefer.



    ------------------------------
    Marc Reed
    ------------------------------

    Attachment(s)

    txt
    search Select.txt   15 KB 1 version