Hi @raj765_32
1.You can write script include to check group membership of current user & return the query depending upon that.
2.use reference qualifier on list collector variable to call that script include.
Script include :
Name : accessUtils
Function : getAccessNeeded
var accessUtils = Class.create();
accessUtils.prototype = {
initialize: function() {},
/*1. Get access needed depending upon user group */
getAccessNeeded: function(userId) {
/*2. Declare variable to return value */
var query;
/*3. Check group membership of user */
var grMem = new GlideRecord('sys_user_grmember');
grMem.addEncodedQuery('group.nameINServiceNow Development,Process Specialist^user=' + userId);
grMem.query();
if (grMem.query()) {
/*4.1 User is member of groups */
query = "put your query here if user is member of group";
} else {
/*4.2 User is not memeber of groups */
query = "put your query here if user is not member of group";
/*for example -
query = "fieldName!=okta retail^ORfieldName!=okta prod";
*/
}
/*4. Return the query */
return query;
},
type: 'accessUtils'
};
Reference Qualifier :
javascript: new accessUtils().getAccessNeeded(gs.getUserID());
