IRV_QUERY_STATE_CHANGES
This view contains a history of state changes for each query.
Columns in the IRV_QUERY_STATE_CHANGES view
IRV_QUERY_STATE_CHANGES |
IRV_QUERY_STATE_CHANGES |
---|---|
QUERYID (PK) |
Numeric identifier for the query. |
QUERYREV (PK) |
Revision number for the query. |
QUERYSTATE |
Query state: 0 - Candidate |
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. |