Under the hood question for Granular Delegate Tasks (expert needed)

[Jay Michael]

I found surface level information about Granular Delegates/Delegation Rules - but need input from anyone that has experience with the code behind the scenes. My question: "Is there a simple way to see all of the HR Tasks that have been Delegated to me?". I'm only aware of this  OOTB To Do widget that distinguishes which tasks are delegated to me (highlighted, and I have zero clue how its doing that). I don't see any fields on HR Task that are used to distinguish which cases are assigned to me vs delegated to me. I imagine the answer lies embedded in this widget but come on- that thing is scary, time is of the essence, and I don't think my question is TOO complex to merit a simple query/table/relationship that I am missing. Any help would be appreciated and I'll be indebted for life. 

[Jay Michael]

sys_granular_delegate_m2m_list

[Jay Michael · Accepted solution]

So within the OOTB Script includes that the widget calls - this table is queried: sys_granular_delegate_m2m_list.

It links Delegates to the tasks that they have been delegated. However, the sys ids of the HR Task are held in a Document field, so you'll need to do a simple array to get the sys IDs. Below is an example script:

var gr = new GlideRecord("sys_granular_delegate_m2m");

gr.addEncodedQuery("delegate=13b88c671b5fd050fe4421f72a4bcb62"); // 

gr.query();

var taskSysIds = [];

while(gr.next()){

    gs.info("jay " + gr.document.toString());

    taskSysIds.push(gr.document.toString());

}

gs.info("jay final " + taskSysIds.toString());

var hrTask = new GlideRecord("sn_hr_core_task");

hrTask.addEncodedQuery("sys_idIN"+ taskSysIds.toString());

hrTask.query();

gs.info("jay task " + hrTask.getRowCount());

[Jay Michael]

Upon answering my own question, I became an expert is Granular Delegates so feel free to ask questions about it

[louisvinhng]

Hi Jay,

I’m currently in the process of implementing Granular Delegation for ITSM. I am aware that this plugin is originally meant for HRSD but I’ve read that it is possible to tweak it to work with ITSM by modifying some of the associated ACLs. 

So far, I’ve managed to add the plugin, create the necessary Granular delegation tables, rules and category records, but I haven’t been able to managed to get it to work.

All that to say, are you familiar at all with implementing this plugin for ITSM use cases rather that HRSD? If so, how did you manage to do it.

Thank you in advance.