Wherefields are the fields that are used in the wheregroup and haven't already been used as a field item.

Attributes

Name	Description	Value
field	The field name that is included in a condition statement. It can be used to define calculated fields.	Any
alias	The alias name for the field.	Any
expression	The field expression.	VALUE

Example

Note that in the cases of calculated fields, their alias should be used in the wheremember section.

Wherefields

Wherefields

<wherefields>
 	<wherefield>
    	<field>CONTACTINFORMATION.CIDELETED</field>
    	<alias>Expr001</alias>
    	<expression>VALUE</expression>
	</wherefield>
	<wherefield>
    	<field>
			(CASE 
				WHEN CONTACTINFORMATION.CIUSERFIELD1 = 'FIRST_NAME'
				THEN CONTACTINFORMATION.CIFIRSTNAME
				WHEN CONTACTINFORMATION.CIUSERFIELD1 = 'LAST_NAME'
				THEN CONTACTINFORMATION.CILASTNAME
			END)
		</field>
    	<alias>CONTACTNAME</alias>
    	<expression>VALUE</expression>
   </wherefield>
</wherefields>
 
...