Service Desk Practitioners Forum
cancel

Search for calls between certain times

SOLVED
Go to solution
Highlighted
Amanda Duesterb
Contributor.

Search for calls between certain times

I'm trying to do a search for calls that come in between 5 and 6 pm. When I do an advanced search and select Registration;Created, I only get date fields under Operators. Has anyone found a way to search on the time the registration was created? We're using version 4.5 sp 21.
3 REPLIES
George M. Meneg
Acclaimed Contributor.
Solution

Re: Search for calls between certain times

Hello Amanda,

You can't (at least directly).

What you can do however is to create a chart view. Enter your filters and select a drill down view (this drill down view better to have no filters defined).

On the X-Axis select "Registration;Created". At display format select Hour.

Press ok to create the chart. To get a list of calls created between 5 and 6 just double click the bar with label 5 pm. To export this view just right click on Data and as report style select anything but Standard. Then do a print preview and either copy paste the data or press publish to save as html file.
menes fhtagn
Amanda Duesterb
Contributor.

Re: Search for calls between certain times

Thanks for the workaround George! It is surprising how many workarounds are necessary to do basic tasks in Service Desk. Thanks again!
Amanda Duesterb
Contributor.

Re: Search for calls between certain times

The chart view worked.