Follow-On Topics

Related Topics

# About the Mapping Tab

The Mapping tab of the Repository Filter dialog box is used to select the recordset columns to be used by the filter which are then mapped to the Repository columns.

It contains a table which is automatically populated when a Repository is selected.
|  | Column — A row is provided for each column available in the Repository with the following:
|  | Repository Column — Displays the Repository column name.
|  | Recordset Column — Displays the recordset column name to which the recordset column is mapped. This is initially selected automatically if the column names are the same or displays None if it is not. However clicking on the name displays a drop down list of all available columns in the recordset for selection. Each row for the mapped column value created at Task run time is then processed by the filter and stored in the Repository against the selected Repository column name.
NOTE: Repository "key" columns should not be mapped to non-unique columns to ensure that duplicate rows are not memorised. | Click the image to view full size.

|  | Parameter — Displays the parameter for the selected column. The parameter is resolved for each row in the record source and is used to look up existing entries in the Repository when the Task is run. This is the mechanism used to detect new rows, if rows have changed, and so on.

Copyright © 2018 Quadrant Software B.V. All rights reserved.