July 13, 2016
Less than or equal to: <=Number
Microsoft Dynamics NAV Filters
Similar to a Google search, you can perform advanced queries with Microsoft Dynamics NAV filters. In this free Quick Reference Guide, we review different expressions and what they mean. You can also download a printable version so you have a copy available wherever you are.
1) Filter on an IntervalTo filter between a range enter FirstNumber..LastNumber e.g. “1000..1200” would return results between 1000 and 1200 ..Number filters all numbers up to and including that Number e.g. “..2000” filters all results up to 2000 Number.. filters all numbers including and after that number For dates use the format Month Date Year to filter up to that date e.g. “.. 12 31 00” filters dates up to and including 12 31 00 To filter on accounting periods use the format PNumber e.g. “P8..” filters for account period 8 and thereafter
2) Equal, Greater than, and Equal toNot equal to: <>Number Greater than: >Number Greater than or equal to: >=Number Less than:
3) Either/OrTo filter using either/or use the format Number1|Number2 e.g. “1100|2100” would return entries with either 1100 or 2100
4) Specific CharactersTo filter results containing certain characters use *Characters* e.g. "*Co*" will find all entries that contain "Co" To find entries that begin with certain characters use Characters* e.g. "Co*" will find all entries that being with "Co" To find entries that end with certain characters use *Characters e.g. "*Co" will find all entries that end with "Co"
5) “And”To filter using “And,” use the format Condition1&Condition2 e.g. “>2000&<1000” will find all entries more than 1000 but less than 2000 The & sign cannot be used by itself with numbers because no record can have two numbers.
6) Unknown CharacterTo find a result with an unknown character use the format Letters?Letters e.g. To find entries containing either “Hansen” or “Hanson” you would enter “Hans?n”
7) Case insensitiveTo find results that are not case sensitive use @characters* e.g. “@man*” finds all entries that start with man and are not case sensitive
8) Exact Character MatchTo filter on an exact character match use the format ‘characters’ e.g. ‘man’ would only find entries with exactly “man” If you have any questions about filters, please contact ArcherPoint. And don’t forget to print and pin our Microsoft Dynamics NAV Filters Guide next to your NAV workstation. You may also be interested in dowloading our Microsoft Dynamics NAV Shortcuts, too!
- Login Error: Communication protocol mismatch between client and server
- Creating a Date Table in Power BI
- How to Make Measures Total Correctly in Power BI Tables
- The Microsoft Technology Stack – What It Is and Why You Should Care
- The Top Eight KPIs Retailers Should Be Tracking (with Formulas) for Your Retail KPI Dashboard