AX / D365FO – Use Wildcards (..LIKE SYNTAX..) in AOT Query objects

Are you creating an AOT Query and want to use a wildcard filter?

An example could be that you want to filter all the items that starts with a specific word.

In an ideal world you would use the SQL keyword “LIKE”.

In the AOT query you can do it by using a data source Range object

and put inside the value the initial of the word you want to use (for example “LAM“) followed by the * character like shown below

In this case the Query will use the LIKE wildcard to create the filter condition.

Leave a Reply

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

You are commenting using your 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