AX / D365FO – FIlter an AOT Query by multiple Enum types fields

Are you creating an AOT Query and want to create a filter condition by multiple ENUM types field?

In the AOT query you can do it by using a data source Range object and separate value by comma

In the value field property just insert the numeric or string value of the the ENUM fields.

In this example I used the string value (ReportFinished, Completed) of the field ProdStatus, but you could also use the numeric value of the enum

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s