Clarity Service Management

Expand all | Collapse all

Need to display 30000 values in the drop down.

  • 1.  Need to display 30000 values in the drop down.

    Posted 05-09-2017 07:47 AM

    Dear All,

     

    we have recently upgraded to CA service catalog 14.1.

     

    we need to display 30000 values in drop down, please let us know your views.

     

    my view: creating a table with 30000 rows, and extracting the information from the backend through query.

    if we do like this, if there is any performance issue?

     

    Thanks in advance.

     

    Awaiting your reply.



  • 2.  Re: Need to display 30000 values in the drop down.

    Posted 05-09-2017 08:08 AM

    Hi Santhosh - I am not a well-versed catalog person, but from my experience in Service Desk Manager, I would say that yes, with a dropdown that large, there is a fairly big risk of performance issues being caused by that large of a back-fill query for a dropdown.

    Hope this helps,

    Jon I.



  • 3.  Re: Need to display 30000 values in the drop down.

    Posted 05-09-2017 09:41 AM

    Can you explain us the business case to have a dropdown with 30000 values?

     

    Looks like a user will not be available to read each value to make his choice. It will rather write the beginning of what he wants and then choose an option.

     

    It may be better suited to have a textbox that will act as a search box. You can then fetch the corresponding record in a multi select. You can add some Javascript to avoid multiple selection.

     

    Here is what we have done for our automated Exchange mailing list service.

     

    The textbox "Find a mailing list" triggers a plugin that search in ldap for security groups associated with an Exchange mailing list.