1 ACCEPTED SOLUTION
it's not simpler.
you will require scripting approach for this
1) create client callable classless script include and use this script
function fetchTickets(){
try{
// get the group members
var memberArr = [];
var member = new GlideRecord('sys_user_grmember');
member.addQuery('group.name', "IN", "Service Desk,Network Team,EUC Team"); // give the correct group names here
member.query();
while(member.next()){
memberArr.push(member.getValue('user'));
}
return memberArr.toString();
}
catch(ex){
gs.info(ex);
}
}2) then call it like this in filter condition of report
Opened By.SysId [IS ONE OF] javascript: fetchTickets()
OR
Another approach is to to create database view of task and sys_user_grmember and then create report on that database view table
If my response helped please mark it correct and close the thread so that it benefits future readers.
