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.