| Panel |
|---|
|
Wherefields Wherefields are the fields that are used in the wheregroupwheregroup 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.
| Expand |
|---|
|
| Code Block |
|---|
| theme | Eclipse |
|---|
| language | xml |
|---|
| title | Wherefields |
|---|
| ...
<wherefields>
<wherefield>
<field>PRODUCTS.PRODDELETED< <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
<field>0< END)
</field>
<alias>Expr002< <alias>CONTACTNAME</alias>
<expression>VALUE</expression>
</wherefield>
</wherefields>
... |
|