How to create a reference qualifier where data is from table to be used for a variable of a catalog

Anastasia Ty-Ch
Tera Contributor

Hello everyone!

I need help in creating the correct reference qualifier for a variable of a catalog form.

We are using the table service_offering as a reference of the variable. We are using this table because we want everything to be data driven.

As you can see in the screenshot below, Forcepoint One Endpoint is available in locations Australia and United Kingdom while Postman is available in North America and Ireland.

 

C.jpg

 

This is what it should look like in the catalog form. If user select Forcepoint One Endpoint the only available locations should be Australia and United Kingdom 

A.jpg
If user select Postman, the only available locations should be North America and Ireland. 

B.jpg

This is the LOCATION variable and I can't figure out the correct reference qualifier to achieve the above output. Please help. Thank you.

 

D.jpg

 

1 ACCEPTED SOLUTION

@Anastasia Ty-Ch 

You should have 2 variables on your catalog item

1) reference to service_offering table so that user selects Service Offering

2) reference to cmn_location with advanced ref qualifier as this so that it shows only that locations associated to offering selected

javascript: 'sys_idIN' + current.variables.business_service_offering.location.sys_id.toString();

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

6 REPLIES 6

@Anastasia Ty-Ch 

are you sure the variable name is correct in the reference qualifier?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Thank you so much Sir @Ankur Bawiskar