Building reports

[ameykelkar]

A department uses SLA data extensively to run reports; they keep asking for help with building reports off of the same set of tables. They seem to be conducted by dot-walking. What can we do to make it easier for them to build their reports?

[NityaB161013953 · Accepted solution]

Hi @ameykelkar ,

The best approach is to create a Database View that joins the commonly used SLA tables (e.g., task_sla, incident, etc.) into one reporting-friendly view. This eliminates the need for heavy dot-walking and gives the department a single, consistent data source for reports.

If you find my answer useful, accept it as solution and mark it helpful.