reference field not working in addquery in ScriptInclude

[si21]

Hi experts,

u_region is a reference field in user table with value Europe.

This reference field value is not working in this addQuery in scriptinclude.

Below is code snippet. Please let me know the what went wrong.

TIA

isEuropeVisible: function() {

        var gr = new GlideRecord('sys_user');

        //gr.addEncodedQuery('active=true^u_regionLIKEEurope');

        gr.addQuery('active', true);

        gr.addQuery('u_region.u_name', 'Europe');

        gr.addQuery('sys_id', gs.getUserID());

        gr.query();

        if (gr.next()) {

            return true;

        } else return false;

[Musab Rasheed · Accepted solution]

Hello,

Try passing Sys id instead of name.

isEuropeVisible: function() {
        var gr = new GlideRecord('sys_user');
        //gr.addEncodedQuery('active=true^u_regionLIKEEurope');
        gr.addQuery('active', true);
        gr.addQuery('u_region', 'sys id of europe');
        gr.addQuery('sys_id', gs.getUserID());
        gr.query();
        if (gr.next()) {
            return true;
        } else return false;