Dynamic filter is not working when using system property in script include

varanyas024
Tera Contributor

3 weeks ago

Dynamic filter is not working when using system property in script include

Code:

var MembersOfStoreGHD = Class.create();
MembersOfStoreGHD.prototype = {

    getGroupMembers: function() {

        var strId = '';
        var groups = gs.getProperty('store.ghd.groups');

        var gr = new GlideRecord('sys_user_grmember');
        gr.addQuery('group', 'IN', groups);
        gr.query();

        while (gr.next()) {

            var userId = gr.getValue('user');

            if (strId.indexOf(userId) == -1) {
                strId += userId + ',';
            }
        }

        gs.info('Dynamic Filter Return Ids => ' + strId);

        return strId;
    },

    type: 'MembersOfStoreGHD'
};

And I have created the dynamic filter correctly.
Please suggest something because I have been restricted to use the sys id directly in code.
 
0 Helpfuls
  • 938 Views
3 REPLIES 3

Kieran Anson
Kilo Patron

3 weeks ago

Dynamic filters run in the script sandbox which disables access to certain capabilities, these are documented below 

 

https://www.servicenow.com/docs/r/api-reference/scripts/script-sandbox.html 

0 Helpfuls

varanyas024
Tera Contributor
In response to Kieran Anson

3 weeks ago

What should I do then?

 

0 Helpfuls

Ankur Bawiskar
Tera Patron

3 weeks ago

@varanyas024 

It doesn't work with dynamic filter

workaround is to query and get the value of property

Dynamic Filter Option with gs.getProperty() 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

0 Helpfuls