This is what happens in the video
When you work with lists in Business Central, you often need to locate a specific item or a set of records. You have two tools for that: search and filter. They behave differently, and knowing when to use which saves you time and gives you more precise results.
Search looks only in the columns that are visible on the list, and it matches on text placement and ignores casing. Filter looks in every field on the table, including fields that are not shown as columns, and it also works on calculated fields such as Inventory. Filtering matches on the exact value, so it is more precise but stricter than search.
Use search for quick, loose lookups across visible columns. Use filter when you need an exact match, want to filter on a field that is not visible, or need to filter on a calculated field.
The difference between search and filter on a list
When you want to find records on a list, you have two options. You can search for them, or you can filter for them. Which one works best depends on what you are looking for.
The first difference is in the fields each tool looks at. When you use search, it only looks in the columns that are currently visible on the list. When you filter, the first fields you can choose from are the same ones search looks in, but you also get access to all the other fields on the table.
This matters because search cannot look in calculated fields. A field like Inventory is calculated, so you can only search it through the filter, not the search box.
How search and filter match values differently
The second difference is in how each one matches values. Search matches on text and placement, and it ignores casing. If you type “bike”, it finds “Bike” wherever the word appears in a field, regardless of whether it is written in lower or upper case.
Filter works the other way. It needs the exact same value. If you put the same text into a filter, you may get no results at all, because the field does not contain that exact value.
You can get around this matching behaviour by using special search and filter symbols, but the basic distinction stands: search is loose and forgiving, filter is exact.
Why filtering is the more powerful tool
Because filtering lets you work on fields that are not visible in the list, and because it works on calculated fields, it gives you more control than search.
Here is an example. If you search for “10” because you want to see how many records have an inventory of 10, you get all kinds of results. The search runs across every visible column, so you get the records where the Number contains 10, but also records where 10 appears in the Production BOM No. field, and so on.
If you filter instead, setting Inventory equals 10, you only get the records that have an inventory of exactly 10. That is the precision filtering gives you that search cannot.
Q&A
What fields does search look in on a Business Central list?
Search only looks in the columns that are currently visible on the list. It does not look in hidden fields or calculated fields.
Can I search in a calculated field like Inventory?
No. Search cannot look in calculated fields. To find records by a calculated field such as Inventory, you have to use the filter.
Does search match on upper and lower case?
No. Search ignores casing and matches on text and placement. If you type “bike”, it finds “Bike” anywhere in a visible field regardless of case.
Why does filtering give fewer results than searching for the same value?
Filter requires an exact match on the value, while search matches the text wherever it appears across all visible columns. Searching for “10” returns records where 10 appears in any visible column, while filtering Inventory equals 10 returns only records with an inventory of exactly 10.
When should I use filter instead of search?
Use filter when you need an exact match, when you want to filter on a field that is not visible in the list, or when you need to filter on a calculated field. Use search for quick lookups across the visible columns.