Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Report "All incidents": show sla name

edited Jul 20, 2017 8:43AM in Reporting & Analytics for B2C Service 2 comments

Content

Hello,

 

I want to display the sla name in the report "All incidents".
Therefore I add the column incidents.sla_id to that report. Next step is to add the column sla_instances.sla_id to that report. Now I get 3 join options (attachment: join_options.PNG).
If I choose the first option, I will get an overview of all incident records having a incidents.sla_id not equal to 0, that means all incidents record with  incidents.sla_id = 0 are not displayed.

If I choose the third option, the result is displayed as attachment result.PNG. If a organzation have more than one active sla, there are more than one incident data record of the same íncident id are displayed in that report,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!