Show 'Breached' or 'Not Breached' instead of true/false for Incident SLA

[athavichith]

I am working on a report for incidents sla, how can i show a 'breached' or 'not breached' instead of true/false for incident.has_breached

[Runjay Patel]

Hi @athavichith ,

In your report configuration, locate the Field Settings or Columns.

• • Create a new Calculated Field based on the incident.has_breached value.

• Write a Script for the Calculated Field: You can use the following formula in a calculated field or script to transform the true/false values into 'Breached' and 'Not Breached'.

• use below script 

if (incident.has_breached) {
return 'Breached';
} else {
return 'Not Breached';
}

[athavichith]

Actually, my report is on incident_sla, which is a database view of incident and task_sla. I tried creating a calculated field on task_sla.has_breached. Did not work. 

[Runjay Patel]

you should create calculated filed on database view and use task_sla column to check true and false.

[athavichith]

if i create a calculated field on the database view table...it will apply to all database views.