5 Filtering Tricks Every Business Central User Should Know

The filter box in Business Central accepts a whole syntax most users never discover. Here are five patterns that will change how you work with lists.

1. Ranges with ..

Two dots create a range — and it works on dates, numbers, and even text:

1000..2000       Numbers 1000 through 2000
..12/31/25       Everything up to Dec 31, 2025
01/01/26..       Everything from Jan 1, 2026 onward
A..C             Text values starting A through C

2. OR conditions with |

Need records matching one value or another? Use the pipe:

10000|20000|30000

This works with ranges too: 1000..1999|5000..5999.

3. Wildcards with * and @

* matches any characters, and @ makes a filter case-insensitive:

*seattle*        Contains "seattle" (case-sensitive)
@*seattle*       Contains "seattle" in any casing
S*               Starts with S

4. Exclusions with <>

Filter out values instead of in:

<>0              Everything except zero
<>''             Only records where the field is not blank

5. The %me shortcut

In user-related fields (like Assigned User ID), type:

%me

It resolves to your own user ID — perfect for saving a personal view like “my documents” that works for every user who applies it. There’s also %mycustomers, %myitems, and %myvendors, which resolve to the lists on your Role Center.

Bonus: Save any filtered list as a view (the bookmark icon next to the filter pane header) and it’ll be waiting for you in the left column of the filter pane every time you open that list.