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.
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.
A similar thread provides you with some explanation on the usage of those fields
Hope this helps you .