Hope you are fine.

Many tickets violated every week. Our customer wants report with violation reason but unfortunately there is no field name "Violation Reason" in template. We can create a common text  field  named "Violation Reason" in every template but it wont be the right one because this field should be visible only in violated tickets not every tickets.

so what we want?

A mandatory text field named "Violation Reason" should be visible once a ticket got SLA Violated. Can we do this from CUSTOM TRIGGER? if yes then provide us the query/code plz or if not then suggest us if there is any way to do this.

thanks for your continuous support as always.

Version: 9.0 MESDP

Build 9048

DB: PGSQL

Mohammad Golam Rabbany

MESDP 9.0 Proud Customer