cpsys_DataDiffs

This table is designed to create a relationship from the content record to changed values of attributes within the record.

The cpsys_DataDiffs table was released in Centralpoint version 8.11.51 and is supported against content residing in GenericEnhanced modules.

Records are only inserted in this table when content is submitted with trigger execution. Difference recording is a moving forward feature. This means that if the tools below are applied to existing content, there is no means to determine the changes that occurred prior to this feature being enabled.

Console Instructions

Module Properties > Is Data Diffs Relation Enabled

Go to this location within the desired module. Set the radio-button to Yes.
Module Properties > Data Diffs Attributes

This attribute is visible when the previous step is completed. Enter a comma-separated list of Attribute System Names. When a value in one of these defined attributes have changed, a record is recorded to cpsys_DataDiffs.

*IMPORTANT*
- Ensure the list of defined attributes which detect changes is a complete and final list before using this feature.
- If new attributes are added after data begins recording, the original recorded diffs will not be able to render these attribute values.
- These notes do not mean that an excessive list of attributes should be entered for the concern of possibly using them in the future. Doing this is likely to lead to other problems which may not be resolvable and require deleting the problem data out of cpsys_DataDiffs.
Module Configuration This step is recommended if this feature is applied against existing content and one of the defined attributes is generating data from Word Document HTML. Go to the Module Configuration within the desired module. Add a custom attribute with a System Name of: IsCpMovingAsposeExtractedFiles. This should be a Yes/No attribute and the XML required is shown below. The purpose of this step is that differences in extracted files from the Word Document could not be tracked until this release. The files generated when using this feature are created with a SHA256 hash as the file name. The unique names applied to embedded files within the Word Document allow us to detect when changes occur within the embedded files. Previously, the file names were generic and overwritten each time a record using Word Document features was saved. This attribute will move the old files to the website's \Temp directory to free up disk-space.
```
<property id="IsCpMovingAsposeExtractedFiles">
	<value>1</value>
	<attribute name="Is Moving Aspose Extracted Files?" isEnabled="false" isVisible="false" allowScripts="false">
		<control id="CpKeywordRadioButtonList" type="Centralpoint.Web.UI.Controls.CpKeywordRadioButtonList">
			<controlProperty name="RepeatColumns" value="0" />
			<controlProperty name="RepeatDirection" value="Horizontal" />
			<controlProperty name="KeywordListId" value="c52d9d0d-09f4-4547-96b0-0850f7fade47" />
		</control>
	</attribute>
</property>
```
Design > Script Generator > Script This step is where the DataDiffs UI is managed. Set this attribute to Data Diffs. A default UI is provided and the attributes contain instructions and allow for customization. Take the CpScript produced from this record and place it into a Details View of a module designer record that is tied to a content module where this feature is enabled.