Advanced query options in filtering information in Microsoft Dynamics 365 Finance and Operations apps

value

Equal to the value that is entered

!value (exclamation point)

Not equal to the value that is entered

from-value..to-value (double period)

Between the two values that are separated by double periods

..value (double period)

Less than or equal to the value that is entered

value.. (double period)

Greater than or equal to the value that is entered

>value (greater than sign)

Greater than the value that is entered

<value (less than sign)

Less than the value that is entered

value* (asterisk)

Starting from the value that is entered

*value (asterisk)

Ending with the value that is entered

*value* (asterisk)

Containing the value that is entered

? (question mark)

Having one or more unknown characters

value,value (comma)

Matching the values that are separated by commas

"" (two double quotes)

Matching a blank value