Clarity Service Management

Expand all | Collapse all

Time Based stored query

  • 1.  Time Based stored query

    Posted 06-09-2016 03:09 PM

    Hello All,

     

    I am looking to create time based stored queries which will be used for aging i.e. requests > 30 days old (from open date) , requests between 31 days and 60 days old, etc. I have attempted to create a few but am receiving errors. Please assist. Thanks in advance.

     

    Here is what I have so far: type \'R\' AND open_date > StartAtTime (\'TODAY\') + 30



  • 2.  Re: Time Based stored query

    Posted 06-09-2016 06:42 PM

    What specific errors are you receiving?



  • 3.  Re: Time Based stored query

    Posted 06-10-2016 09:55 AM

    ADH05800: Bad where clause, invalid constraint. Could not recognize +



  • 4.  Re: Time Based stored query

    Posted 06-14-2016 05:35 PM

    Hi Chavarousk  - Did jmayer 's response help answer your question? If so please mark as Correct Answer. Thanks!



  • 5.  Re: Time Based stored query

    Posted 06-10-2016 10:17 AM

    well you need to create your timestamp with start and end date. for the evaluation not doing the math inside the query itself

     

    look there for idea that I just responded this morning:

    Stored Query based on mins

    A quick search in community is always helpful

    /j