How to pull incident list which are SLA Business percentage is 75% or more than 75% ?

[Deepika61]

Hi All, 

Actually I have a requirement that , in workspace we have create new List called "SLA Due", so which pulls the list of incidents  which are SLA Business percentage is 75% or more than 75% ?

Please help me to achieve this

Thanks

Deepika

[Mark Manders]

You can do this in one of two ways: query the incident_sla table for all records that are on 75% or more, or query the incident table with a related list condition of the task_sla table where it is at 75% or more. 

Do know that you need some refreshing on your report, because it won't just automatically add new records if you query the incident table. There has to be some interaction to update.

[Deepika61]

@Mark Manders 

Thanks for the response, Actually i don't want report, basically i need a new 'list" in incidents , that will shows the list of incidents  which are SLA Business percentage is 75% or more than 75%

[Mark Manders]

In that case you need to create your list on the incident_sla table with a filter on Business elapsed percentage >= 75%. You can just put the Incident number as first column so clicking on that gets people to the incident.

[Deepika61]

@Mark Manders 

Actually i want to show the  the list of incidents, not the SLA list, i meant to say need to create list on incident table, in that i need to pull the records based on SLA Business percentage