AnsweredAssumed Answered

How to use status_prev for stored query

Question asked by Ruben.Co on May 2, 2018
Latest reply on May 2, 2018 by Maheshwar_Kusuma

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.

Outcomes