Filtering with MS Dynamics NAV uses NAV's native filter syntax, which is similar to SQL but with some NAV-specific conventions. NAV filters support wildcards, ranges, and logical operators to create flexible query conditions.
Filter Syntax Rules
[Field_Name] or double quotes "Field_Name"| (OR) and & (AND) operators| Field Name | Filter |
| No_ | [No_] = '1000' |
| Name | Name = 'CRONUS International Ltd.' |
| No_ | "No_" = '1000' |
| Order Status Text | [Order Status Text] = 'Released' |
| Order Status Text | "Order Status Text" = 'Released' |
| Description | Description = 'BICYCLE' |
| No_ | [No_] = '1000*' |
| External_Document_No_ | [External_Document_No_] = '' |
| Item No_ | "Item No_" != '' |
| Amount | Amount > 1000 |
| Posting_Date | [Posting_Date] = '01-01-2024..31-12-2024' |
| Document Date | [Document Date] > '2025-05-01' |
| Location_Code | [Location_Code] = 'BLUE'|'RED' |
| Document_Type | [Document_Type] = 'Order'|'Invoice' |
| Base Unit of Measure | [Base Unit of Measure] IN ('001','002','003','005','007','008','010','050','100','120','200','MM') |
| No_ | [No_] NOT IN ('','EP-00001744','1000001') |
| Document Type | [Document Type] = 0 |
| Order Status Text | "Order Status Text" != 'Open' AND "Order Status Text" != '' |
| Document No_ | [Document No_] IN (SELECT No_ from [%%DATABASE%].[dbo].[%%COMPNAME%$Sales Header] WHERE [Document Date]>='2025-05-01' AND [Sell-to Customer No_] NOT IN ('','1005317','1005095','1006618','1001321')) |
[Field_Name] or double quotes "Field_Name" when the field name contains underscores, spaces, or special characters.[Field Name] and "Field Name" work identically - choose whichever you prefer.%%DATABASE%% and %%COMPNAME%%.<> and != operators work for "not equal" comparisons.& or AND to combine multiple conditions on the same field.[%%COMPNAME%$Sales Header]).IN and NOT IN operators are useful for filtering against multiple specific values efficiently.