How to get SC_Task number, Assigned to and Assignment Group from Task SLA Table?

[ladrake]

How can I reference the fields in the sc_task table from the sc_req_item_sla or task_sla tables?

I built an SLA report using the Task SLA table and I need to add several fields of data to my report from the sc_task table.  The fields are as follows: (sc_task) number, Assigned to, and Assignment group.  Also, I need to use the Assignment group as a filter.

I've tried to navigate to this table with no success.  Any help would be greatly appreciated.  Thanks

Larry

[Russell Abbott]

@ladrake I'm looking into this myself for a requirement. Did you have any success creating a database view? I'm having a hard time figuring out the Where Clause. Thanks!

[ladrake]

Russell, I did not build a database view as this effort got deprioritized.

[Russell Abbott]

Understood. Thanks for the reply. I did do some more looking in to this and I have it working. For reference in future if the need returns see the image below.

[sdf1]

Do it like this : 

Click on the + icon nearby task and pull the assignment group and assigned to to the right

Do the dot walking similarly in the filter as well.

[ladrake]

Thanks for the quick reply.  Unfortunately, this method only pulls in the Incidents that were created and I need to report on RITM SLA results for a particular Request Item from a particular assignment group.