How to sort a table by choices in a catalog item and display it in the next question's choices

[nakamura323]

Hello.

Prepare two questions for the catalog item.
First, select company.
The second step is to select department.

I would like to change the items displayed in the department question depending on the company selected.
Example) If the company name is ABC, only those whose department name includes ABC will be displayed...

All departments are stored in one table, and the referenced table cannot be changed.

How can this be achieved?

thank you.

[Sohail Khilji]

Hi @nakamura323,

1. Go to the catalog varaible > department.

2. select adv reference qualififer

3. Apply > javascript: "company="+current.your_company_var+"^active=true^EQ"

4. save.

i hope this helps....

[Dr Atul G- LNG]

Hi @nakamura323 

You can make the 2nd variable as dependent on 1st one.  Like we have on form.

https://www.servicenow.com/community/developer-forum/using-dependent-fields-in-service-portal/m-p/20...

https://www.servicenow.com/community/developer-forum/how-to-make-variables-in-catalog-item-dependent...

[Service_RNow]

HI @nakamura323 

please refer the thread it will helpful to you.

https://concurrency.com/blog/servicenow-dependent-variables-on-record-producer-in-service-catalog/

https://pathwayscg.com/using-category-and-sub-category-on-record-producers/

Please mark reply as Helpful/Correct, if applicable. Thanks!