CA Service Management

  • Private Community
Back to discussions
Expand all | Collapse all

How to make a query that shows me the cases that have not been updated for more than a week?

  • 1.  How to make a query that shows me the cases that have not been updated for more than a week?

    Posted Jun 13, 2017 12:42 PM

    How to make a query that shows me the cases that have not been updated for more than a week



  • 2.  Re: How to make a query that shows me the cases that have not been updated for more than a week?

    Posted Jun 13, 2017 08:19 PM

    Hi John777,

     

    I presume you want to define a stored query for this?  Use the 'StartAtTime' or 'EndAtTime' function and a 'timespan' - something like this:

    last_mod_dt < StartAtTime('PAST_WEEK')

     

    Hope that helps!

    Regards,

    James