Using the Quick Filter in Microsoft Dynamics NAV
Views (1933)
Tharanga Chandrasekara
23,118
Like
Share
Report
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.
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.
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.
This was originally posted here.
*This post is locked for comments