Reporting SLA near breach and task due

[paulharman]

Hi,

I'd like to create a report titled "Tasks nearing SLA or due date".  Problem tasks don't have an SLA, only a due date so do not appear in the task_sla table, and I can't seem to get SLA data from the task table through dot walking.

Can this only be achieved with a view or is there another way?

[abbasshaik4]

Hello @paulharman,
You can refer to this video:
https://www.youtube.com/watch?v=jGZh2qqUR70

Mark my correct and helpful, if it is helpful and please hit the thumbs-up button to mark it as the correct solution.
Thanks & Regards,
Abbas Shaik

[Dr Atul G- LNG]

Hi @paulharman 

As you said, problem task dont have SLA then why you worry about same.

You can create report on Ptask 

[paulharman]

Unfortunately neither reply really helps, although I appreciate your responses.

I want a report to add to a dashboard that tells users which tasks they need to focus on. This is because either:

SLA is within 2 days of breaching

or

Task due date is within 2 days