If the operation type of your destination database is update, you will have to define update criteria. These criteria define what data in your database will be updated when a respondent completes a survey. Each row in the destination table that matches the criteria that you define will be provided with the data that you have configured in the attributes setup tab of the template.
Figure 18: Define update criteria
Defining update criteria works in a similar fashion as creating target group rules. You can define different rules, that are combined with an AND or OR operator. You can place rules in rulesets. These rulesets can be combined with other rulesets or rules. Using rulesets is similar to using parenthesis in a mathematical equation.
In the first column of the rule you choose which column in the feedback table has to be matched. In the second column, you can choose if the rest of the statement has to be negated, by choosing the word Not. The third column contains the operators that can be used for matching. These operators depend on the data type of the column that will have to be matched.
The fourth column contains several locations that contain the matching attributes. These are:
| · | Project: match the selected column with a project value.
|
| · | Directory server: match the selected column with an attribute from a directory server.
|
| · | Custom attribute: match the selected column with a custom attribute.
|
| · | Survey: match the selected column with a value from the survey.
|
| · | Constant value: match the selected column with a constant value.
|
Depending on the matching attribute, there will be one or two columns from which you can select the desired attribute. Which attributes are shown in these columns depends on the data type of the column that has to be matched.