question Reporting on "oldest 5" in ITSM forum

Reporting on "oldest 5"

ssoto — Tue, 08 Aug 2017 15:33:00 GMT

How can I build a report that will automatically update to only show the "oldest 5" incident tickets? I manually have to update the date to only show what I need. This is the filter I've been using:

Re: Reporting on "oldest 5"

harshinielath — Tue, 08 Aug 2017 16:46:27 GMT

You have to write the script that does the calculation of current date/time and opened date/time

there are methods to do this

Refer the glide date/time methods in wiki

GlideSystem Date and Time Functions - ServiceNow Wiki

datediff() or daysAgo()

Re: Reporting on "oldest 5"

ssoto — Tue, 08 Aug 2017 16:50:18 GMT

Ahhh ok thanks!

Re: Reporting on "oldest 5"

ssoto — Tue, 08 Aug 2017 16:51:29 GMT

And this will automatically set the date to show only the oldest 5 incident tickets?

Re: Reporting on "oldest 5"

harshinielath — Tue, 08 Aug 2017 16:53:59 GMT

Yup if you give the input from 'opened' field and current date/time.

Click like or helpful if it solved the issue

Re: Reporting on "oldest 5"

harshinielath — Tue, 08 Aug 2017 16:54:56 GMT

And keep a count variable to have the count for 5 incidents in the loop

Re: Reporting on "oldest 5"

tammyz — Wed, 16 Aug 2017 19:20:08 GMT

Where would you put the script? In the Report or in the Schedule Report?

Re: Reporting on "oldest 5"

harshinielath — Wed, 16 Aug 2017 20:34:24 GMT

While creating reports and selecting custom charts, the Type has to be set to 'Script Generated' which opens a 'Render script' window where you can write the script.