Create a Metric on task_sla table

[Natsufab3]

I want to create a metric on task_sla table. This table contains has_breached field. When ever that field is true, I want to capture the assignment group at that particular time when the SLA is breached.

I have created a metric on Task_sla table and struck up at the scripting part.

Any help is appreciated.

Thank you.

[Michael Fry1]

I don't believe you need to change the event, just duplicate the business rule with the task_sla table.

[Natsufab3]

I did the after BR according to you, But in the event what all conditions should be mentioned. I am attaching the image. Let me know if I am wrong somewhere.

[Michael Fry1]

Change the type to Script and use the script from the earlier post:

if (current.active) {

      if (current.has_breached.getDisplayValue() == 'true') {

                createMetric();

      }

}

function createMetric() {

  var mi = new MetricInstance(definition, current);

  if (mi.metricExists())

      return;

  var gr = mi.getNewRecord();

  gr.field_value = current.task.assignment_group;

  gr.calculation_complete = true;

  gr.insert();

}

[Natsufab3]

Michael,

Thanks for your patience on this. One final clarification, The script you have posted would be in Business rule and the script David has posted will be in the metric right?

Thanks

[Michael Fry1]

The script I posted would be a metric script, not a business rule.