This function merges a dynamicdata table into a result set. This function is similar to ddMergeResultSet except that it only merges those rows whose values for indexColumn match indexValue. The comparisons made on this column are case-insensitive.
The following table lists parameters for the function.
| Parameters | Description |
|---|---|
dataTableName |
The name of the dynamicdata table to load. |
idocTableName |
The name of the result set into which the dynamicdata table should be merged. |
indexColumn |
The name of an indexed column in the dynamicdata table. |
indexValue |
The value to use to select a section of the original table. This value is checked in a case-insensitive manner against the indexColumn in each row. If it matches, that row is loaded into the result set; otherwise it is skipped. |
mergeType |
The type of merge to perform. Set this to replace to prevent the merge from appending any new rows. Any other value for this parameter is treated as append. |
mappingTableName |
The name of a dynamicdata table which should be used to rename the columns of the final result set. This renaming is done by mapping the column names in this mapping table to the values of the first row in this same table. This is done exactly as it is done in ddLoadResultSet. |
If the dynamicdata table is successfully merged, it returns True.
<@dynamicdata MyDataTable@>fieldA, fieldB, fieldC1, 2, 34, 5, 61, 3, 9<@end@>
<$exec rsCreateResultSet("MyResultSet", "fieldA,fieldB,fieldC")$><$exec rsAppendNewRow("MyResultSet")$><$MyResultSet.fieldA = "4"$><$MyResultSet.fieldB = "8"$><$MyResultSet.fieldB = "23"$><$exec rsAppendNewRow("MyResultSet")$><$MyResultSet.fieldA = "8"$><$MyResultSet.fieldB = "21"$><$MyResultSet.fieldB = "59"$><$exec ddMergeIndexedColumnResultSet("MyDataTable", "MyResultSet", "fieldA", "4", "replace")$><$exec rsFirst("MyResultSet")$><$foo = MyResultSet.fieldB$> [[% (foo == '5') %]]<$exec rsNext("MyResultSet")$><$bar = MyResultSet.fieldC$> [[% (bar == '59') %]]