Value Class - Filter
The Filter option is only possible as a Value Class in the Mapping Filter table. This option works the same as the Constant option, with the difference in the use of the filter. The Filter Value completely replaces the filter routine and therefore enables an autonomous definition of the filter.
How to use mapping filters in different repository types
Mapping filters are technically carried out in the source code.
Table / Record Pool
<Field>.SetFilter(<Value>) (for example, Value = '01.01.2017..31.07.2017')
XPath += <Value> (for example, Value = '/book[price>35.00]')
For a filter value, the language code of the processing user must be considered for Microsoft Dynamics 365 Business Central fields.
Temp.Field = <Property> Temp.SetFilter(<Value>) not Temp.IsEmpty
Submit feedback for.