Show Incident records based on logged in user's group

[tscoggin]

On a Before Business Rule 

I'm trying to filter records that:

1. Were created by logged in user
2. The Project field value on a record = one of the logged in users groups
3. If the logged in user belongs to group 1 also include records where project field where = to  'X"

The top 3 lines work but the "if statement" does not add to the query

var u = gs.getUserID(); //Get the sys_id value of the current user
var groups = gs.getUser().getMyGroups();
var gr = u.addQuery(current.addQuery('caller_id', u).addOrCondition('u_project_1', getMyGroups()));

if (gs.User().isMemberOf('Group 1')) {
u.addOrContition('u_project_1', 'Group 2');

[Brad Bowman · Accepted solution]

This script running in a before Query Business Rule on the incident table will limit the results to only show those where:

1. The Caller = the current user, OR
2. The Project (custom reference field on sys_user_group) = one of the logged in user's groups, OR
3. If the current user is a member of <group1>, then Project = <group2>

(function executeRule(current, previous /*null when async*/ ) {
	var gr = current.addQuery('caller_id', gs.getUserID()).addOrCondition('u_project_1', 'IN', getMyGroups());
    if(gs.getUser().isMemberOf('group1')){
		gr.addOrCondition('u_project_1', 'group2');
	}
})(current, previous);

[tscoggin]

Thank you Brad. This worked perfectly. 

[Brad Bowman]

You are welcome.

[Alp Utku]

Why do you use BR for this? The results can be obtained by using list view easily

You could go to "My Groups Work" section and try to filter records based on your requirements which you mentioned initially

PS : If there is specific need to use BR, please ignore my post