How to merge incident and incident sla tables and generate the report?

[prasadrauc]

How to merge incident and incident sla tables and generate the report?

[Jill14]

Hello 

Thanks for information.

But in this case , I need to merge Incident & Incident (SLA) table bcoz i need "business time left" column.

Reason behind it is there are some incident where we do not have SLA .

Main purpose is to show a report which contain SLA and Non SLA Incident together with " business  time left" column.

So could you Help me know if below solution would not work , so can we go with some other solution.

Regards

[tanumoy]

You can get the report by selecting Incident SLA(incident_sla) table in the Reports module..

[Blaze2]

What information do you need from the report? That will help more with determining if you are combining the correct table or if you can get what you need from the ISLA Table