How to restrict assigning 2 sctasks

[nameisnani]

Hi Team 

How to restrict assigning 2 sctasks to a same member when the tasks are generated from same ritm . 

I have wirtten this BR on ritm table , 

Here we are triggering sequential task . I am going to assign same person to 2nd task it should through an error .Which is not working ,

Note - it should throw an error and abort action

@Jaspal Singh @Sonam_Tiwari 

Please help me here , please provide solution 

Thanks in advance 

[Harsh_Deep]

Hello @nameisnani 

As I can see you have written BR on RITM table but you should have to write this BR on the SC Task Table then only this will work.

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.

[nameisnani]

Hi @Harsh_Deep 

Yes I have tried with sctask also same behaviour.

[Anand Kumar P · Accepted solution]

Hi @nameisnani ,

You should create before insert and update business rule on sc_task table i have tried in my pdi its working.

(function executeRule(current, previous /*null when async*/) {

	var ritm = new GlideRecord('sc_req_item');
    if (ritm.get(current.request_item)) {
        var existingTasks = new GlideRecord('sc_task');
        existingTasks.addQuery('assigned_to', current.assigned_to);
        existingTasks.addQuery('request_item', current.request_item);
        existingTasks.addQuery('sys_id', '!=', current.sys_id);
        existingTasks.query();
        if (existingTasks.hasNext()) {
            gs.addErrorMessage('Another task is already assigned to the same member for this RITM. Please review the assignments.');
            current.setAbortAction(true);
        }
    }
current.setAbortAction(false);


})(current, previous);

Mark it as solution proposed and helpful if it serves your purpose.

Thanks,

Anand