MetaData - Processing Rules - CCL Specific
From All n One's bxp software Wixi
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 Insert Into CCL Simple
This function allows you to get information from the CCL table of a form and insert the data returned from the CCL table into a CDA table
Required fields to execute rule:
- Rule Name
- CCL Table (the same as the current sequence)
- Fields to retrieve from the CCL table
- CDA table to insert data to
- Fields to insert the data to
Example:
Rule name[[-SEP-]]CCL table[[-SEP-]]Fields to retrieve[[-SEP-]]CDA table[[-SEP-]]Fields to insert[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
Example (with replacement values):
InsertIntoCCL_Simple[[-SEP-]]CCL_1[[-SEP-]]intCCL_1_CDAId,dteCCL_1_FirstCCLDateTime[[SEP-]]CDA_2[[-SEP-]]strCDA_2_field_0_2,strCDA_2_field_0_8[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]] 3.2 Insert From CCL Custom
This function allows you to get information from the CCL table of a form and insert the data returned from the CCL table into a CDA table
Required fields to execute rule:
- Rule Name
- CCL Table (the same as the current sequence)
- Fields to retrieve from the CCL table
- CDA table to insert data to
- Fields to insert the data to
Example:
Rule name[[-SEP-]]CCL table[[-SEP-]]Fields to retrieve[[-SEP-]]CDA table[[-SEP-]]Fields to insert[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]]
Example (with replacement values):
InsertFromCCL_Custom[[-SEP-]]CCL_1[[-SEP-]]intCCL_1_CDAId,dteCCL_1_FirstCCLDateTime[[SEP-]]CDA_2[[-SEP-]]strCDA_2_field_0_2,strCDA_2_field_0_8[[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]][[-SEP-]] 
