CA Service Management

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.

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 .