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 blogs.msdn and to read the complete blog post please refer the original article by Mictosoft NAV team ( to link please scroll to the bottom of the post).
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
|