I want to create a select box in a Catalog item, and make it so that you can select multiple choices. Can this be done?

psenkow1 · ‎11-20-2017

In my select box I am adding several choices. I want the user to be able to select multiple choices, and not be limited to just one.

I was hoping to use the select box to do this, because:

There will be several select boxes that hold different choices.

Which select box will actually be visible (active), will depend on the answer to another question (another select box) in the catalog item.

For example, if they say the want access to the Development environment in application ABC, then the select box will be active that lists the databases in that development/ ABC. Then I want them to be able to select multiple databases from the list.

If instead, they want access to the Production environment in application ABC, then the select box for production/ ABC to be active. And, the select box for development/ ABC will be INactive.

I tried using checkboxes and a container to hold each environment/ application combination. And then made the container & contain split active or inactive depending on the request. But I wasn't able to make the unwanted checkboxes to disappear from my form.

Any suggestions?

Thanks! Trish

Abhimanyu Bansa · ‎11-20-2017

Hi Patricia,

whenever we create a choice for select box it gets stored in the "question_choice" table. That table can be referenced in the List collector.
Now in the list collector field we want some specific value should be shown. that can be done by putting a "reference qual" as question="Sys_id of your required question".

please find the attached screen shot:

You can get the query for reference qual from the question choice list view by right clicking on the filter and click on the copy query. and then paste it in the reference qual.

You don't need to create a new table and your requirement can be fulfilled.

and after that for dependency that the user select the value and according to that next list collector should be shown can be done by on change client script.

PS: Hit like, Helpful or Correct if you feel it answered your query.

Thanks & Regards,

Abhimanyu Bansal

View solution in original post

JC S_ · ‎09-08-2019

How did you make this to actually work for end users? Because the question_choice table is only available for users with role admin and catalog_admin. So for end users or even itil users, they see nothing.

BigMikeyVegas · ‎10-21-2019

This was awesome and helpful, but the issue I ran into was that the list items were not available to end users. I had to add public to the ACL for read for Question choice in order for this to work.

Treva1 · ‎10-02-2020

Where did you do this at?

Treva1 · ‎10-02-2020

This was my same issue. selected list items were not available to end users.