question Set Reference Qualifier in Service Catalog item via onchange script? in Developer forum

Set Reference Qualifier in Service Catalog item via onchange script?

jamesmcwhinney — Thu, 11 May 2017 22:54:21 GMT

Within a service catalog item, within a variable's onchange script, is there a way to set the reference qualifier of another variable within the same catalog item?

Thanks!

- James

Re: Set Reference Qualifier in Service Catalog item via onchange script?

Espinomen — Thu, 11 May 2017 23:17:41 GMT

You can use an Advance Reference Qualifier to get the value of the variable and a Script include to get the query you need

the code you insert is = javascript: new scriptinclude().Function();

Re: Set Reference Qualifier in Service Catalog item via onchange script?

Subhajit1 — Thu, 11 May 2017 23:29:05 GMT

Hi James,

You can give a try using Dynamic Reference Qualifiers:-

Reference Qualifiers - ServiceNow Wiki

Re: Set Reference Qualifier in Service Catalog item via onchange script?

SanjivMeher — Fri, 12 May 2017 00:19:19 GMT

Can you give an example of what you are trying to do?

Re: Set Reference Qualifier in Service Catalog item via onchange script?

jamesmcwhinney — Fri, 12 May 2017 14:32:09 GMT

Hi Guys,

Thanks for your responses. Much appreciated, however I think I still need some assistance.

Here is my use case:

1. End user opens up catalog item "Mobile Travel Plan" with multiple checkboxes and a drop down.

2. User clicks a few of the checkboxes "Will you be traveling to Africa?: YES", which causes the reference field "Select a Plan" to be cleared out.

3. User clicks the "Select a Plan" reference field and sees only the travel plans which relate to africa (There is a column in the reference table containing the countries that plan applies to "AF,CS,CA,US,etc etc"

If I understand correctly, is the idea that I should create a script include that accepts the checkbox values as variables, and then set the advanced reference qualifier to call that function and pass the checkbox values as parameters?

(My assumption is that I wont be able to access the form values directly from code within the script include)

Thanks again,

- James

Re: Set Reference Qualifier in Service Catalog item via onchange script?

SanjivMeher — Fri, 12 May 2017 14:44:58 GMT

I think your question should be 'Where are you travelling?' AF,US etc. Consider this variable country_code

And the the Select Plan should be a reference field with qualifier :javascript:"country="+current.variables.country_code

Re: Set Reference Qualifier in Service Catalog item via onchange script?

jamesmcwhinney — Fri, 12 May 2017 15:30:47 GMT

How do I then handle multiple destinations?

Re: Set Reference Qualifier in Service Catalog item via onchange script?

jamesmcwhinney — Fri, 12 May 2017 15:33:56 GMT

Almost there,. still struggling a little with this.

The following works:

Reference qualifier:

javascript:new TravelPlanReferenceQualifier().setTheQualifier()

Script include:

var TravelPlanReferenceQualifier = Class.create();

TravelPlanReferenceQualifier.prototype = {

initialize: function() {

setTheQualifier: function() {

return 'u_regions_coveredLIKEAF';

type: 'TravelPlanReferenceQualifier'

};

The following does not work (When i try to add a parameter):

Reference qualifier:

javascript:new TravelPlanReferenceQualifier().setTheQualifier(g_form.getValue('selected_destinations').toString())

Script include:

var TravelPlanReferenceQualifier = Class.create();

TravelPlanReferenceQualifier.prototype = {

initialize: function() {

setTheQualifier: function(test) {

return 'u_regions_coveredLIKEAF';

type: 'TravelPlanReferenceQualifier'

};

Re: Set Reference Qualifier in Service Catalog item via onchange script?

SanjivMeher — Fri, 12 May 2017 15:34:45 GMT

Create a List Collector for Where are you Travelling.

And the the Select Plan should be a reference field with qualifier :javascript:"country ISIN"+current.variables.country_code

Re: Set Reference Qualifier in Service Catalog item via onchange script?

jamesmcwhinney — Fri, 12 May 2017 15:36:44 GMT

Which is exactly what I would have liked to do if the Mobile UI supported list collectors.

Unfortunately it doesnt =(

So that means I either have to write a separate catalog item for mobile vs desktop, or just try build one using checkboxes that will work on both mobile and desktop..

Re: Set Reference Qualifier in Service Catalog item via onchange script?

jamesmcwhinney — Fri, 12 May 2017 15:37:20 GMT

Sorry,. i mean if the mobile ui supported list collectors!

Re: Set Reference Qualifier in Service Catalog item via onchange script?

SanjivMeher — Fri, 12 May 2017 15:37:21 GMT

Try

javascript:new TravelPlanReferenceQualifier().setTheQualifier(current.variables.selected_destinations.toString())

Re: Set Reference Qualifier in Service Catalog item via onchange script?

jamesmcwhinney — Fri, 12 May 2017 15:39:38 GMT

Booyaa! That was just what I needed.

Thank you!!!

Re: Set Reference Qualifier in Service Catalog item via onchange script?

jamesmcwhinney — Fri, 12 May 2017 18:04:36 GMT

Wow. So when I accidentally wrote above that the mobile UI doesnt support advanced reference qualifiers, it turned out thats actually true.

Advanced reference qualifiers dont work in mobile either.

More and more I am beginning to feel that the mobile UI is so broken its not worth developing for.

To make anything work, the workarounds involved result in a solution that is so far from user friendly I am embarrassed to provide it..

1. Syncronous Ajax isnt supported

2. List Collectors arent supported

3. Advanced reference qualifiers arent supported

4. Subcategories arent supported

Re: Set Reference Qualifier in Service Catalog item via onchange script?

Community Alums — Mon, 24 Jun 2024 02:58:15 GMT

this article worked for me:
How to modify Reference Qualifiers with Catalog Client Scripts – ServiceNow – ServiceNow Think (wordpress.com)

and this is the onChange client script:

var resetFilter = 'active=true^nameISNOTEMPTY^emailISNOTEMPTY^EQ';

var dynamicFilter = g_form.getValue('your other text var holding encoded query').toString().trim();

var gg = g_list.get('your ref var name'); // GlideList2 object

gg.setQuery(newValue == '' ? resetFilter : dynamicFilter);