Entity History Query

The Entity History query recounts all the activities that have occurred for an entity. You can see when the entity was created, who created it, how and when it changed over time, and who performed each action included in the query results.

For example, some of the properties on an application are used to identify the relationship of the application to its parent product family. These contextual properties, including Family Code and Family Name, are references to the parent product family, and cannot be changed when the application is deemed to be a child of the parent product family. Most of the other properties on an application are used to define the application itself. These are properties such as Application Name, Application Code, and Procedure Type.

Due to the way Calyx RIM currently stores contextual properties, Entity History 'Action' queries (the query that displays when the user selects the I/U/D from the Action column of the query) show this data as an internal system ID, not as the name one sees through the user interface of the entity itself. These internal system IDs are typically a series of five or six digits, such as 12345.

For example, the Entity History 'Action' query for the application entity shows the internal system ID for the Family Name column. However, the Entity History 'Action' query for the product family shows the expected product family name in the Product Family Name column.

The Entity History query also enables you to view information for discussion threads and notifications, which have an associated entity value to specify the entity, such as product, application or event, to which the discussion thread or notification belongs. Due to the way Calyx RIM stores associated entity values, Entity History ‘Action’ queries do not show the associated entity if the associated entity has been deleted.

For example, the Entity History 'Action' query for an application’s discussion thread will show the application as the associated entity so long as the application exists. However the Entity History 'Action' query shows a blank value for the associated entity on the discussion thread’s Entity History ‘Action’ query if the application was deleted.

On the entity attributes page, clicking the Report icon on the action toolbar opens the Entity History Query page where you can enter a date range during which changes occurred that you want to review. If you enter no dates, all change activity is included in the query results.

In addition, you can select the columns to display and the order in which to sort the results.

Results include all entity history records based on the selected date range. Additionally the results include the current values for the selected entity.