Hi Experts,
I have report on project_table, the report data visibility should be based on group user is memberof but the restriction should be only on reports.
ex: if iam member of project_asia_group i should see the reports data only based project.mep.region = asia;
below is the business rule,
(function executeBeforeQuery(current, previous /*null when async*/) {
// Assuming the field representing the region is 'account.mep.region'
var userRegions = [];
// Check user's group membership and add corresponding regions to the array
if (gs.getUser().isMemberOf('project_asia_group')) {// Asia Group
userRegions.push('asia_sys_id'); // Asia
}
if (gs.getUser().isMemberOf('project_emea_group')) {// EMEA Group
userRegions.push('emea_sys_id'); // Europe
}
if (gs.getUser().isMemberOf('project_americas_group')) {//Americas Group
userRegions.push('Americas_sys_id'); // Americas
}
// Add a filter condition based on the user's regions to the query
if (userRegions.length > 0) {
current.addQuery('active', true);
current.addQuery('project.mep.region', 'IN', userRegions);
}
})(current, previous);
Please suggest
