In the below example, on the SalesLine DataItem (array) in the definition lines either filters or output conditions were added.
Output Conditions:
Condition | Value | Value 2 |
== (Equals) | [E0008-CUST] | Selangorian Ltd. |
> (Greater than) | [E0008-QTYSHIP] | 0 |
The first condition means the SalesLine element will only be added if the customer is Selangorian Ltd.
The second conditions means the SalesLine element will only be added if the Quantity Shipped is more than 0.
In case the customer is indeed Selangorian Ltd. but neither of the lines meets the Quantity Shipped condition, the result will look like this:
Filters
Field No. | Field Name | Filter Text |
2 | Sell-to Customer No. | 20000 |
60 | Quantity Shipped | >0 |
The first filter means the SalesLine is only in output in case the Sell to Customer no. is 2000 (this is customer Selangorian Ltd. like in the above example).
The second condition means only SalesLine elements with a Quantity Shipped of more than 0 are within the filter.
In case the customer is indeed Selangorian Ltd. (No. = 20000) but neither of the lines meets the Quantity Shipped condition, the result will look like this:
Note the difference in the output. In the filtered case, an empty array element was added. while in the output conditions version, the element was not added at all.
Need more help with this?
Product page