Recording Table Creation and Modification Times

When a table is created, the option to Record creation and modification times is selected by default. This option provides a record of each time a table row is created or modified. Repository blocks are added for the following attributes:

  • created at
  • created by
  • modified at
  • modified by

For example:

<repository-attribute name="created by">
   <repository-attribute-infos>
     <repository-attribute-info name="autoincrement" value="false"/>
     <repository-attribute-info name="default" value=" "/>
     <repository-attribute-info name="desc" value=" "/>
     <repository-attribute-info name="displayLabel" value=" "/>
     <repository-attribute-info name="format" value=" "/>
     <repository-attribute-info name="type" value="text"/>
   </repository-attribute-infos>
</repository-attribute>

 

Setting nonstandard column names

You can edit the xml file to add the following repository-infos to rename columns to a nonstandard label. The names of the repository-infos you can add are:

  • created-at-column
  • created-by-column
  • modified-at-column
  • modified-by-column

The values should be the new names for the relevant columns. The names in the following repository-attributes must be modified to match.

  • created at
  • created by
  • modified at
  • modified by