MetaData - Processing Rules - Data Management
From All n One's bxp software Wixi
Contents
1 Overview
For more information on
Area | Link |
---|---|
MetaData please refer here | MetaData_-_Start_Here |
Processing rules please refer here | MetaData_Process_Rules |
Parameter construction please refer here | MetaData_Program_and_Outcomes |
2 Reference
This wixi article is meant to serve as a reference guide to a subset of MetaData Processing Rules.
3 Rules
3.1 Deletion
The Deletion rule allows for records to be deleted from any form
Required fields to execute rule:
- Rule Name
- Form id (the same as the current sequence)
- intCDA_X_Id
Example:
Rule Name[[-SEP-]]Form Id[[-SEP-]]intCDA_X_Id[[-SEP-]][[-SEP [[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
Example (with replacement values):
Delete[[-SEP-]]1[[-SEP-]]intCDA_1_Id[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
3.2 Remove Duplicate Records
The remove duplicate records function allows for the deletion of all duplicate records in a form.
Required fields to execute rule:
- Rule Name
- Form id (the same as the current sequence)
- Field that contains the values to group on
Example:
Rule Name[[-SEP-]]Form Id[[-SEP-]]intCDA_X_Id[[-SEP-]][[-SEP]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
Example (with replacement values):
DeDupe[[-SEP-]]1[[-SEP-]]strCDA_1_field_0_1[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
3.3 Flag Duplicate Records
The flag duplicate records function allows for the duplicate records in a form to be flagged as duplicates
Required fields to execute rule:
- Rule Name
- Form 1 Id
- Form 1 fields
- Form 2 Id
- Form 2 fields
- Outcome for CCL
- Add CCL
- Fields to update
- Values to insert
- CCL Coments
- Comments additional
- Current Record Id
Example:
Rule Name[[-SEP-]]Form 1 Id[[-SEP-]]Form 1 fields[[-SEP-]]Form 2 ID[[-SEP]]Form 2 fields[[-SEP-]]Outcome CCL[[-SEP-]]Add CCL[[-SEP-]]Fields to update[[-SEP-]]values to update[[-SEP-]]CCL Coments[[-SEP-]]Additional comments[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
Example (with replacement values):
DeDupe_Flag[[-SEP-]]1[[-SEP-]]strCDA_1_field_0_8,strCDA_1_field_0_7[[-SEP-]]1[[-SEP-]]strCDA_2_field_0_79,strCDA_2_field_0_80[[-SEP-]]Flagg CCL Outcome[[-SEP-]]true[[-SEP-]]strCDA_1_field_0_23[[-SEP-]]True[[-SEP-]]MetaData Program - Flag[[-SEP-]]true[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]