2. Last Modified Date and Version Properties
Last Modified Date: Last Modified Date is used at item level to identify the items that are being changed from given timestamp.
<item-descriptor ......... last-modified-property="lastModDate">
<attribute name="updateLastModified" value="true"/>
<table ...>
<property name="lastModDate" data-type="timestamp"/>
</table>
</item-descriptor>
Last Modified Date: Last Modified Date is used at item level to identify the items that are being changed from given timestamp.
<item-descriptor ......... last-modified-property="lastModDate">
<attribute name="updateLastModified" value="true"/>
<table ...>
<property name="lastModDate" data-type="timestamp"/>
</table>
</item-descriptor>
The five important must points to set the last modified date are
- data-type of last-modified-property has to be "date" or "timestamp".
- Property should be persistent and single valued.
- Property should be placed in Primary or Auxillary table.
- item descriptor should contain last-modified-property.
- Attribute "updateLastModified" should be set to true.
Additional Safety:
- Column in DataBase can have default value to set to sysdate, so that, in case of insertion of Null, DataBase Updates the row with system date(current date).
- Hide the Property in ACC and BCC by adding hidden="true".
