AX / Dynamics 365 For Finance and Operations blog

To add a range with an OR condition on a filter field in an AOT View in Dynamics 365 Finance and Operations, you can follow these steps:

1. Open the AOT (Application Object Tree) and find your View.
2. Expand the View and go to the Data Sources section.
3. Select the Data Source where you want to apply the filter.
4. Add a range for the field that you want to filter (for example, FieldName).
5. Configure the range properties:
   • Go to the Value property of the range.
   • To apply an OR condition, use the following syntax:

((FieldName == value1) || (FieldName == value2))

Example:

((FieldName == "ABC") || (FieldName == "XYZ"))

If you need to handle more complex cases with multiple OR conditions across different fields, you may need to use a custom query. In this case, you would implement the logic in X++ to manage the OR condition correctly.

If your scenario involves a more advanced setup or multiple fields, you might need to write X++ code to handle the OR condition in the query.