Schema Changed?
In an ideal world we would design the project schema first and then run our project from that point on. However, that’s not always how real life pans out, changes post ‘work starting’ can create questionable item integrity.
Cradle’s WorkBench Item Integrity checker allows an authorised user to check the status of items in the database. The thorough check ensures each item’s attributes are consistent with the schema and valid. It highlights areas that need the database administrator’s attention.
These issues may have been created in a number of normal operational ways.
- Altering the schema after these items have been created and saved.
- Importing items whilst overriding data validation. (In order to get items in to the database, so that they can be edited it is quite logical to want the old value to remain. The user then has a chance to view and edit and save with the new parameters).
- Creating, say, a hierarchy of items and subsequently not editing them to fill in all required category fields or filling mandatory frames with content. (It would be most laborious to be forced to fill each one at the time of creation. It is better allowing a hierarchy to be created and then subsequently edited)
Item Integrity Checker
New Cradle-7.2 Item Integrity Fix Feature
A Fix button has been added to the Item Checks section of the Item Integrity Checker. This button only apply to certain checks. These checks are shown below with details of what happens when the Fix button is pressed:
| Check | Fix Operation |
|---|---|
| Category values are defined in project schema | Clear the category values. |
| Category values match data type in project schema | If it has a default value, set it to this value, otherwise don’t do anything, i.e. this cannot be fixed using the Fix button. |
| Categories are not empty when predefined values exist | If it has a default value, set it to this value, otherwise don’t do anything, i.e. this cannot be fixed using the Fix button. |
| All mandatory categories have values | If it has a default value, set it to this value, otherwise don’t do anything, i.e. this cannot be fixed using the Fix button. |