| Panel |
|---|
|
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 | | VALUEThe field expression. | VALUE |
Example
Note that in the cases of calculated fields, their alias should be used in the wheremember section.
| Expand |
|---|
|
| Code Block |
|---|
| theme | Eclipse |
|---|
| language | xml |
|---|
| title | 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>
... |
|