Quick Filter in Microsoft Dynamics NAV

 

 

With the introduction of Microsoft Dynamics NAV 2013, Microsoft had changed the Quick filter functionality and this blog post is a summarize version of the article published in the MSDN Blog.
The following table illustrates more Quick Filter search examples in Microsoft Dynamic NAV 2013.

 

Search Criteria	Interpreted as…	Returns…
Man	@man*	All records that start with the string man and case insensitive.
Se	@se*	All records that start with the string se and case insensitive.
Man*	Starts with Man and case sensitive	All records that start with the string Man
‘man’	An exact string and case sensitive	All records that match man exactly
*1	Ends with 1	All records that end with 1
@*man	Ends with and case insensitive	All records that end with man
@man*	Starts with and case insensitive	All records that start with man

The following table illustrates the Quick Filter search examples for the Cumulative Update 13 and later for Microsoft Dynamics NAV 2013 and Microsoft Dynamics NAV 2013 R2.

 

Search Criteria	Interpreted as…	Returns…
Man	@*man*	All records that contain the string man and case insensitive.
Se	@*se*	All records that contain the string se and case insensitive.
Man*	Starts with Man and case sensitive	All records that start with the string Man
‘man’	An exact string and case sensitive	All records that match man exactly
*1	Ends with 1	All records that end with 1
@*man	Ends with and case insensitive	All records that end with man
@man*	Starts with and case insensitive	All records that start with man

Enjoy.