IRV_QUERY_STATE_CHANGES

This view contains a history of state changes for each query.

Column Name (Key indicator)	Column Description
QUERYID (PK)	Numeric identifier for the query.
QUERYREV (PK)	Revision number for the query.
QUERYSTATE	Query state: 0 - Candidate 1 - Opened 2 - Answered 3 - Closed 4 - Deleted
QUERYSTATETIME	Time the query was changed to the state.
QUERYUSERID	Numeric identifier of user who made the state change.
QUERYTEXT	Text associated with the state change.
QSTATEORDER	Query change ordinal 1..n (ordered by QUERYREV).
PREVQUERYSTATE	Previous query state (NULL if first revision).
PREVQUERYSTATETIME	Time the state was previously changed (NULL if first revision).
PREVQUERYUSERID	User who made the previous state change (NULL if first revision).
PREVQUERYTEXT	Previous query text (NULL if first revision).
NEXTQUERYSTATE	Next query state (NULL if current revision).
NEXTQUERYSTATETIME	Time the query was changed to the next state (NULL if current revision).
NEXTQUERYUSERID	User who made the next state change (NULL if current revision).
NEXTQUERYTEXT	Next query text (NULL if current revision).
CREATEDBYUSERID	User ID of the user whose action resulted in the given view row being created.
CREATEDBYDATETIME	Date and time when the view row was created.
MODIFIEDBYUSERID	User ID of the user whose action resulted in the most recent change to data in the given view row.
MODIFIEDDATETIME	Date and time when the data in the view row was most recently updated.