Data Filter

You can define more than one filter and apply them together. This element can contain a child element, filter.

To print the returns in an order, filter the returns by using the In type of Movement Direction. For this, create an each node for order.loPrintItems and define the filter criteria.

<table tableLayout="lightHorizontalLinesMainItemsOnly" name="ReturnsTable">
<thead>
<tr>
<th width="75">{{Labels::PrdNumberId; defaultLabel=No.}}</th>
<th width="*">{{Labels::TextId; defaultLabel=Product}}</th>
<th width="25" alignment="center">{{Labels::UnitId; defaultLabel=Unit}}</th>
<th width="25" alignment="center">{{Labels::QuantityId; defaultLabel=Qty}}</th>
<th width="40" alignment="center">{{Labels::UnitPriceId; defaultLabel=Unit Price}}</th>
<th width="48" alignment="center">{{Labels::FullAmountId; defaultLabel=Full Amount}}</th>
<th width="48" alignment="center">{{Labels::NettoAmountId; defaultLabel=Net. Amount}}</th>
<th width="18" alignment="center">{{Labels::TaxClassificationId; defaultLabel=T}}</th>
</tr>
</thead>
<tbody>
<each name="ReturnEach" value="{{Declarations::order.loPrintItems}}">
<filters>
<filter fieldName="quantity" value="0" operator="GT" compareMode="NUMBER" />
<filter fieldName="movementDirection" value="In" operator="EQ" />
</filters>
<orderCriteria>
<orderCriterion fieldName="prdId" direction="ASC" compareMode="NUMBER" />
</orderCriteria>
<tr>
<td>{{.prdId}}</td>
<td>{{.text1}}</td>
<td alignment="center">{{.quantityLogisticUnit; toggleId=DomPrdLogisticUnit; toggleField=shortText}}</td>
<td alignment="right">{{.quantity}}</td>
<td alignment="right">{{.basePriceReceipt; numberFormat=8.2}}</td>
<td alignment="right">{{.grossValueReceipt; numberFormat=8.2}}</td>
<td alignment="right">{{.valueReceipt; numberFormat=8.2}}</td>
<td alignment="center">{{.taxClassification; toggleId=DomTaxClassification; toggleField=shortText}}</td>
</tr>
<correlation name="correlation2" value="{{Declarations::order.loSdoConditions}}" key="pKey" correlationKey="sdoItemPKey">
<filters>
<filter fieldName="sdoItemPKey" value=" " operator="NE"

The supported attributes are:

Example This example defines the filter for a listObject in the print layout where the value in Quantity is greater than 0, and the value of Movement Direction is other than In:

<filters>
<filter fieldName="quantity" value="0" operator="GT" compareMode="NUMBER" />
<filter fieldName="movementDirection" value="In" operator="NE" />
</filters>