Before query business rule based on current record values

[Pavan Yakkala1]

Hi Team,

The requirement is to limit the  read of records based on a role and current task type.

For example, Risks should be displayed only if type is Project and he is project manager. For this, we need to check whether task type is Project or not from Risk table and before query business rule.

But it seems we are not able to get the task reference values in before query business rules. 

Can you help with how to do this?

Please find the script in before query business rule

var currentTask = current.task.getRefRecord();
var currentTaskNum = currentTask.number;
//gs.info('##Hello:::::'+currentTaskNum); //giving empty value
if (!gs.hasRole('admin')) {
if (currentTaskNum.startsWith('PRJ') == true)
current.addEncodedQuery('task.ref_pm_project.project_manager=' + gs.getUser().getID());
}

Thanks in advance

Kind regards,

Pavan

[Anshu_Anand_]

Try this , it should work

var currentTask = current.sys_class_name;
if (!gs.hasRole('admin')) {
if (currentTask.startsWith('PRJ') == true)
current.addEncodedQuery('task.ref_pm_project.project_manager=' + gs.getUser().getID());
}

[Pavan Yakkala1]

Hi Anshu,

Thanks for reply.  am looking to get the task type and task number etc.. from the Risk table

[Anshu_Anand_]

Can you try this?

var currentTask = current.task.getRefRecord();
var currentTaskNum = currentTask.sys_class_name;
if (!gs.hasRole('admin')) {
if (currentTaskNum == 'project')
current.addEncodedQuery('task.ref_pm_project.project_manager=' + gs.getUser().getID());
}

[Pavan Yakkala1]

Hi Anshu,

when I log for currentTaskNum, it is giving empty value and not providing task type as project.

var currentTask = current.task.getRefRecord();
var currentTaskNum = currentTask.sys_class_name;
gs.info("## task type:::"+currentTaskNum);
if (!gs.hasRole('admin')) {
if (currentTaskNum == 'project')
current.addEncodedQuery('task.ref_pm_project.project_manager=' + gs.getUser().getID());
}

[Anshu_Anand_]

You have to glide record then on that integration table with current.task.

Then fetch the value of that field in currentTaskNum