/build/static/layout/Breadcrumb_cap_w.png

Time range for Help Desk tickets in reporting

I am working to create a report that will show tickets received between 1630 and 1800, Monday through Friday. Has anyone out there invented this wheel yet or have a suggestion on how to proceed? 

I have tried Between with AND, greater than less than, it will work for one day, but not multiple days.

Thanks for any assistance. 


0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 4 years ago
Red Belt
0

If you have created a report that shows calls logged on Monday between your times, why not try and show the SQL and then duplicate the where statement for Monday, adding it in as an OR and changing the day to Tuesday. Which in effect will create an SQL statement that says....

Show me all calls where 

The log time is Monday between A and B or

Tuesday between A and B or

Wednesday between A and B etc etc 

Which may be a little cumbersome to build in a wizard, and I would sort by Day logged and break on days so it splits down to each day in the report



Comments:
  • Thanks for the input!

    I had tried something like that in SQL, I will give it a go in the wizard too. I have been playing with it more since I asked and may answer my own question soon. - tmscott 4 years ago
    • if not, why not post your SQL in here and we can take a look for you ;o) - Hobbsy 4 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ