Query Business rule on RITM to access specific item records

Ram141 · ‎05-05-2025

Hello Team,

I got a requirement where I need to filter or show 'HR' catalog Item (RITM) records to specific user i.e.,

If is part of group xyx or

If user is part of group abc or

If user is Requested For.

I tried writing query business rule on RITM table with the below script but somehow it's not working could any one please help me with your inputs to achieve this scenario.

(function executeRule(current, previous /*null when async*/ ) {

var curUserID = gs.getUserID();

var user = gs.getUser();

var gr = current.addQuery('cat_item.name', 'HR System Requests');

var xyz = '1ab75ae587e19a90b865206acebb3591';

var abc = '4f37a9983b465ad0cb51624a85e45afe';

if(!(user.isMemberOf(abc) || user.isMemberOf(xyz))){

var requestedFor = current.addQuery('requested_for',curUserID);

requestedFor.or();

}

})(current, previous);

Abhijit4 · ‎05-05-2025

Hi @Ram141

I have create query BR which handles all of your 3 scenarios:

- If user is not part of XYZ and ABC group-> HR system requests will be hidden.

- If user is not part of XYZ and ABC group but he is requested by or opened by person-> only those records will be visible to user.

- If user is neither part of XYZ, ABC group nor he is requested for -> All HR system requests will be hidden.

I have created new Query BR on PDI and tested and it works prefectly.

PFB script for your reference:

(function executeRule(current, previous /*null when async*/ ) {

    var curUserID = gs.getUserID();
    var user = gs.getUser();
    var xyz = '1ab75ae587e19a90b865206acebb3591';
    var abc = '4f37a9983b465ad0cb51624a85e45afe';


    if (!user.isMemberOf(abc) && !user.isMemberOf(xyz)) {
		
		var currentQuery=current.addQuery('cat_item.name','!=','HR System Requests');
		var currentQuery2 = currentQuery.addOrCondition('requested_for', curUserID);
		currentQuery2.addOrCondition("opened_by",curUserID); //Hide HR System Requests RITM's for all users except for requester for and opened by user

	}

})(current, previous);

By marking my response as correct or helpful, you contribute to helping future readers with similar issues.
Regards,
Abhijit
ServiceNow MVP

ServiceNow Buddy Website LinkedIn

View solution in original post

Ankur Bawiskar · ‎05-05-2025

@Ram141

please check script shared by @Abhijit4

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader