In order to ensure optimized consistency checking a field of Timestamp data type should be implemented. Consistency then only checks the value of this field to determine if data is valid.

Implementing Consistency 

User requirements specify that data must be refreshed every 30 seconds in order to ensure data consistency.

Example (MxSpace)

In the user interface for managing bills of materials data displayed in the grid is reloaded every 30 seconds. To see the implementation of data consistency feature in MxSpace application click Production -> BOM.

To implement consistency validation

1. Open appropriate adapter (BomAdapter) in Solution Explorer.
2. Expand the desired data source (BOM) 
3. Select Consistency.
4. Set Enabled property to True.
5. In property PositionRetain select value KeyField.
6. In property Added select value Override.
7. In property Changed select value Override.
8. In property Missing select value Override.
9. Set Interval property to 30000.
10. Expand Schema node of the same data source.
11. Expand the field (Id) which is unique identifier and select Consistency node.
12. Set IsConsistencyKey property to True.
13. Expand the field (RecordChanged) which will be monitored for a change and select Consistency node.
14. Set IsConsistencyTimestamp property to True.
15. Select the field (Id) node.
16. Set property Key to True.

See Also