Query Business rule on RITM to access specific item records

[Ram141]

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);

[Ankur Bawiskar]

@Ram141 

try this

Also ensure table.None READ ACL on sc_req_item allows the access

(function executeRule(current, previous) {
    var userId = gs.getUserID();
    var groupXYZ = '1ab75ae587e19a90b865206acebb3591';
    var groupABC = '4f37a9983b465ad0cb51624a85e45afe';

    // Filter HR catalog items
    current.addQuery('cat_item.name', 'HR System Requests');

    // Restrict visibility if user isn't in groups
    if (!user.isMemberOf(groupXYZ) && !user.isMemberOf(groupABC)) {
        current.addQuery('request.requested_for', userId); // Only show user's own requests
    }
})(current, previous);

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

[Ram141]

@Ankur Bawiskar  The scenario is even if user is not part of group abc and xyz but part of 'Requested By' field then also user should be able to access the Ritm records.

[Abhijit4]

Hi @Ram141 

That's what my script does, please have a look.

[Ram141]

Thanks @Abhijit4   In filter condition do we need to provide Item is 'Hr system Requests' as this query BR may apply to all items.

[Abhijit4]

@Ram141 

This is what you need to do to achieve your scenario:

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'); //Hide HR System Requsts for all users who are not part of ABC or XYZ group.
		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

	}

I have added explanation beside filter query. Hope that clarifies your concern.

Let me know if you still have any questions.