Clarity Service Management

Expand all | Collapse all

How to use status_prev for stored query

Jump to Best Answer
  • 1.  How to use status_prev for stored query

    Posted 05-02-2018 03:09 AM

    I am trying to create a stored query for scoreboard nodes.

    The nodes should display reopened tickets, that is: current status = open and previous status = closed

    I saw the status_prev field in the cr object so the query should be pretty straightforward: status = 'OP' and status_prev = 'CL'

     

    But I am getting this error:

    AHD03053:Bad where clause: invalid constraint. Could not recognize status_prev.



  • 2.  Re: How to use status_prev for stored query
    Best Answer

    Posted 05-02-2018 03:53 AM

    The _prev fields are only available in the context of an activity log, you'll not be able to use them in a stored query.



  • 3.  Re: How to use status_prev for stored query

    Posted 05-02-2018 04:29 AM

    Hi Ruben,

     

    A similar thread provides you with some explanation on the usage of those fields

     

    https://communities.ca.com/thread/241778870-can-it-be-used-the-statusprev-in-the-event-condition

     

    Hope this helps you .