Finally got the solution
Since the workflow is on the Requested item, current.task.state refers to current requested item status which is not closed complete. hence all the requested items are going to cancelled state. use below script after the catalog task activity.
answer = check();
function check()
{
var gr_tsk = new GlideRecord("sc_task");
gr_tsk.addQuery('request_item', current.sys_id);
gr_tsk.query();
gr_tsk.next();
if(gr_tsk.state == 4) //check for task status closed incomplete
{
return 'yes';
}
return 'no';
}
after if, for yes you will have Set values activity with status and stage as Closed complete and completed respectively. for no, it will be Closed incomplete and Request Cancelled.
remember, this will work if there is only one task for the requested item.
