web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Dynamics Lifestyle – Business Central & NAV... / How-To: Use Dynamics NAV Se...

How-To: Use Dynamics NAV Search Criteria in Filters

Views (10546)
Ahmed Mohamed Rafik Profile Picture Ahmed Mohamed Rafik 3,049 User Group Leader

One of the many features of Microsoft Dynamics NAV is the ability to search for data using criteria in filters and advanced filters.

There are available formats you can use on Microsoft Dynamics NAV, in addition you can use special characters to find specific data

The following tables show the symbols which can be used in filters in Microsoft Dynamics NAV:

Symbol Meaning Sample Expression Records Displayed
= Equal to 377 Number 37
.. Interval 1100..2100 Numbers 1100 through 2100
..2500 Up to and including 2500
..12 31 00 Dates up to and including 12 31 00
P8.. Information for accounting period 8 and thereafter
..23 From the beginning of time until 23-current month-current year 23:59:59
23.. From 23-current month-current year 0:00:00 until the end of time
22..23 From 22-current month-current year 0:00:00 until 23-current month-current year 23:59:59
| Either/or 1200|1300 Those with number 1200 or 1300
& And <2000&>1000 Numbers that are less than 2000 and greater than 1000.

The ampersand (&) cannot be used by itself with numbers because no record can have two numbers.
<> Not equal to <>0 All numbers except 0

With the SQL Server option, you can combine this symbol with a wildcard expression. For example, <>A* meaning not equal to any texts that begin with A.
> Greater than >1200 Numbers greater than 1200
>= Greater than or equal to >=1200 Numbers greater than or equal to 1200
< Less than <1200 Numbers less than 1200
<= Less than or equal to <=1200 Numbers less than or equal to 1200
* An indefinite number of unknown characters *Co* Texts that contain Co
*Co Texts that end with Co
Co* Texts that begin with Co
? One unknown character Hans?n Texts such as Hansen or Hanson
@ Ignore case (either uppercase or lowercase allowed) @location Texts such as LOCATION, location, or Location
‘’ Blank ‘’ All records with a blank value in the field for which the criteria is used, for example, the Contact Person field on the customer card, to view all customers without a contact person.

Note: The criteria consist of two single quotation marks, not one double quotation mark.

 

See you in the next post.


This was originally posted here.

Comments

*This post is locked for comments