CA Service Management

  • 1.  Help store query between two times

    Posted 11-04-2014 05:23 PM

    Hi, i´m trying to make a store query to bring me request from 7:00 pm to 7:00 am  , every day so i can view the non business hours tickets. I use time span  but didnt work. Can you help please.

     

    Thanks.



  • 2.  Re: Help store query between two times

    Posted 11-05-2014 12:47 PM

    Are you trying to see the

     

    1. Service Desk requests opened from 00:00 today to 07:00 today and the Service Desk requests opened from 19:00 today to 23:59 today?

     

    or

     

    2. Service Desk requests opened from 19:00 yesterday to 23:59 yesterday and the Service Desk requests opened from 00:00 today to 07:00 today?



  • 3.  Re: Help store query between two times

    Posted 11-05-2014 02:34 PM

    Hi Lindsay, thanks for the quick answer. Will be the second choice.

     

    Regards

     

    Guido



  • 4.  Re: Help store query between two times
    Best Answer

    Posted 11-05-2014 03:17 PM

    So, your Time Span definition would be:

     

    Symbol

    NON_BUSINESS_HOURS

     

    Start Time

    Year +0   Month +0   Day -1   Hour 19   Minute 0

     

    End Time

    Year +0   Month +0   Day +0   Hour 6   Minute 59

     

    Trigger Time

    Year +0   Month +0   Day +0   Hour 7   Minute 0

     

     

    The Where Clause for your stored query would be:

     

    open_date >= StartAtTime(\'NON_BUSINESS_HOURS\') AND open_date <= EndAtTime(\'NON_BUSINESS_HOURS\')



  • 5.  Re: Help store query between two times

    Posted 11-18-2014 11:44 AM

    Thanks Lindsay, it works like charmed !!!