You don't need to scroll through hundreds of records. These three operators let you narrow any list in Business Central to exactly what you need — in seconds.
Most Business Central users filter lists the same way: open the page, scroll, scan, scroll some more. Or they type a value and hope the default search is specific enough. When the list is short, it works fine. When you're looking at 400 vendor ledger entries or three years of purchase orders, it doesn't.
BC has a set of filter operators built into every list and filter field that most users never learn. Three of them — the range operator, the OR operator, and the wildcard — cover the majority of filtering situations you'll run into on any given day. Office workers spend roughly 10% of their working time on manual data entry and search tasks in business applications like ERP systems. Knowing these three symbols chips into that number.
These work in any filter field in Business Central — the filter pane, the search bar within a list, or inline field filters. You don't need to configure anything. They're ready to use.
The Range Operator: ..
Two periods between two values returns everything between them, inclusive. This is the most useful filter operator for finance and operations work, where date ranges and amount ranges come up constantly.
The OR Operator: |
A pipe character between two values returns records matching either one. Use it when you need to pull multiple specific values at once without running separate searches.
The Wildcard: *
An asterisk stands in for any number of characters. Use it when you remember part of a value but not the exact full entry.
Case sensitivity applies when you use wildcards or single quotes around a search term. Keep that in mind if you're not getting expected results — try uppercase if your data is stored that way.
These three operators work together. You can mix them in a single filter expression to get very specific results without stacking multiple separate filters.
The more specific your expression, the less time you spend reviewing results that don't apply. A well-built filter expression gets you to the records you need in one pass.
The filter operators above work in any filter field, but knowing how to open and navigate the filter pane quickly makes them even more useful.
Used together with the filter operators, these shortcuts mean you rarely need to touch the mouse to get from a full unfiltered list to exactly the records you're working with.
Finance Teams
AP and AR coordinators working with vendor ledger entries, customer ledger entries, and payment journals use date ranges and amount ranges constantly. The range operator cuts the time to isolate a specific period or transaction bracket from a scroll session to a single expression.
Inventory Managers
Users managing item lists, purchase orders, or transfer orders across multiple locations benefit from the OR operator when they need to pull specific items or categories without running separate queries for each one.
Operations Staff
Anyone who works with partial information — a fragment of a vendor name, part of a reference number, the first few characters of an item code — gets the most out of wildcards. You don't need to remember the exact entry. You need to remember enough to narrow the field.
Controllers and BC Admins
Power users and team leads who run reports or review data across periods find that precise filter expressions make their list views significantly more useful than default unfiltered outputs. They also make these shortcuts easy to pass on — the learning curve is a few minutes, not a training session.
Research consistently shows that employees working with business applications like ERP spend a meaningful portion of their day on repetitive manual tasks — searching the same records, scrolling the same lists, re-entering the same criteria. When those same teams adopt automation and better tooling, the typical gain is in the range of several hours per week.
These filter operators won't automate your work. But they do eliminate a specific category of friction — the kind that doesn't feel significant in the moment but compounds into real lost time over weeks and months. Learning three symbols takes ten minutes. Using them takes three seconds. That's the pattern we see with BC users who get the most out of the platform: they invest a small amount of time in the right shortcuts, and those shortcuts pay back every day.
If you want to know what else your team might be working around in your current BC setup, Western Computer's team has been doing this work for 35+ years, across more than 1,250 implementations. Contact us to learn more.