Create a filter showing tickets I updated and resolved

chadsw
Kilo Explorer

I'm trying to create a filter that shows the incidents I've updated and resolved in the last 24 hours. The easy part was getting it to show the incidents I have resolved. The part that's causing me problems is getting it to show any tickets that I've updated in the last 24 hours. I've been trying to use all the different options under "Updated by" with no success. Is there another field I should be choosing?

4 REPLIES 4

Mark Stanger
Giga Sage

Updated by is a standard string field that just stores your user name.   It's not a reference field that you can use 'isDynamic' against like 'Resolved by'.   You can use a dynamic function against it though to match that user name string.   Try this...



Updated by....is....javascript:gs.getUserName()


Thanks, Mark. That was a big help. I'm wondering if there's a simple way to have the filter only show tickets where I entered comments in the Additional Comments field or the Technical Work Notes field. The way I have the filter set up now, it does show me tickets that I updated. However, it that includes any type of update instead of only updates where I types notes in the ticket. Do you have any suggestions?


Those work notes and journal entries are kept in a separate table, so I don't think that incident even is aware of them.   The table is sys_journal_entry if you want to look into it.


Michael Fry1
Kilo Patron

You could create a Script Calculation Metric on the additional comments fields. Then create a report on the Incident metric's table. Here's a script that should get you started:



if (current.additional_comments != '') {


      var value = current.sys_updated_by;


      createMetric(value);


}


function createMetric(value) {


      var mi = new MetricInstance(definition, current);


      if (mi.metricExists()){


              //return;


      }


      var gr = mi.getNewRecord();


      gr.start = current.sys_created_on;


      gr.end = current.sys_updated_on;


      gr.duration = gs.dateDiff(gr.start, gr.end);


      gr.field_value = value;


      gr.field = null;


      gr.calculation_complete = true;


      gr.insert();


}