Create a filter showing tickets I updated and resolved
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-29-2015 05:50 PM
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-30-2015 05:25 AM
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()
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-02-2015 04:13 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-02-2015 05:50 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-30-2015 02:12 PM
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();
}