Verify/Export interaction on Task for specific assignment group

[LDeMatteis]

Good afternoon

I would ask help on topic in object

I have a request from the owner of an Assignment Group, to export all SCTasks and relative Items on whitch groups has interacted, and report if interaction is directly as first assignment group, or indirectly as part of the life of tasks

How I could achieve?

Many thanks for help

Luigi

[Dr Atul G- LNG]

Hi @LDeMatteis 

There are two possible requirements:

1. The owner needs a list of SC Tasks and Requests where the group has been assigned and is still currently assigned. OR

2. The owner wants to see if a task was assigned to the group at least once, regardless of whether it is still assigned. If this is the case, you need to:

   • Create a metric on the SC_Task table, specifically on the Assignment Group field.

   • Build a Database View that joins the SC_Task table with the Metric table.

   • Use this DB View to generate the required report.

This approach is simple and can be achieved using out-of-the-box (OOB) metric definitions.