RSS

Using Filters in Navision

25 Jan

Here is the breakdown of filters available.  When you enter criteria, you can use all the numbers and letters that you can normally use in the field. In addition, you can use some special symbols or mathematical expressions. Here are the available formats:

Symbol Meaning Sample Expression Records Displayed
= Equal to 377 Number 377
    BLUE Those with the BLUE code, for example, the BLUE warehouse code
    22 A datetime: from 22-current month-current year 0:00:00 to 22-current month-current year 22:59:59
    22 10 An exact datetime: 22-01-01 10:00:00
.. Interval 1100..2100 Numbers 1100 through 2100
    ..2500 Up to and including 2500
    ..12 31 00 Dates up to and including 12 31 00
    P8.. Information for accounting period 8 and thereafter
    ..23 From the beginning of time until 23-current month-current year 23:59:59
    23.. From 23-current month-current year 0:00:00 until the end of time
    22..23 From 22-current month-current year 0:00:00 until 23-current month-current year 23:59:59
| Either/or 1200|1300 Those with number 1200 or 1300
& And <2000&>1000 Numbers that are less than 2000 and greater than 1000.

The & sign cannot be used by itself with numbers because no record can have two numbers.

<> Not equal to <>0 All numbers except 0

The SQL Server Option allows you to combine this symbol with a wild card expression. For example, <>A* meaning not equal to any text that start with A.

> Greater than >1200 Numbers greater than 1200
>= Greater than or equal to >=1200 Numbers greater than or equal to 1200
< Less than <1200 Numbers less than 1200
<= Less than or equal to <=1200 Numbers less than or equal to 1200
* An indefinite number of unknown characters *Co* Text that contain “Co”
    *Co Text that end with “Co”
    Co* Text that begin with “Co”
? One unknown character Hans?n Text such as Hansen or Hanson
  Calculate before rest 30|(>=10&<=20) Those with number 30 or with a number from 10 through 20 (the result of the calculation within the parentheses)
@ Ignore case (either uppercase or lowercase allowed) @location Text such as LOCATION, location or Location

You can also combine the various format expressions:

5999|8100..8490 Include any records with the number 5999 or a number from the interval 8100 through 8490.
..1299|1400.. Include records with a number less than or equal to 1299 or a number equal to 1400 or greater (all numbers except 1300 through 1399).
>50&<100 Include records with numbers that are greater than 50 and less than 100 (numbers 51 through 99).
*A*&*B* Text containing both A and B.
@*No?* Text containing no, NO, No, nO, such as cot, cope and incorporated.

NO, nO, No or no must be present, followed by at least one character, but there can be an indefinite number of characters before and after these, and case is unimportant.

Advertisements
 
Leave a comment

Posted by on January 25, 2016 in Miscellaneous

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: