Using the 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 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

To read the full article please use following link

Thank you and Regards,
Tharanga Chandrasekara. 

Click on a star to rate it!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?