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.