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>
 
...