Reference Qualifier to filter locations based on User Location

[mattfollowell]

I have a variable on a catalogue item that references the locations table. I want that variable to only list locations whose parent = the signed in user's location. EXCEPT if the signed in User's location = MG. If the signed in user's location is MG then I want the variable to list all locations on the table.

function advloc() {
var locPar;
var userLoc='';
var gr=new GlideRecord('sys_user');
gr.addQuery('sys_id',gs.getUserID());
gr.query();
    while(gr.next()){
        userLoc=gr.location;
    }
    if(userLoc.includes("MG")){
        locPar = "";
    }
    else {
        locPar = "parent = userLoc";
    }
return locPar
}

I think it is not working because it returns the name of the location and not the Sys_Id, but I'm not 100%.

[Mark Roethof]

Can you share screenshots of what you've setup now?

From the advanced reference qualifier + script include?

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[mattfollowell]

Script Include:

Variable (with reference qualifier):

[Mark Roethof]

I'll have a look.

Can you in the meantime add between lines 20 and 21:

gs.info('DEBUG: ' + gr.location.getDisplayValue() + ' / ' + locaPar);

When you then reload your form, what is written to the logs?

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[mattfollowell]

Invalid query detected, please check logs for details [Unknown field null in table cmn_location]
Invalid query detected, please check logs for details [Unknown field function advloc() {
var locPar;
var userLoc in table cmn_location]

[Mark Roethof]

Hmm strange. That's not in your screenshots. advloc is also your old function name? Can you find out if it's still used anywhere?

The scripting itself, tested here, works.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list