Skip to content
Guide

Search the Guide

Enter a query to search the Guide.

Íslenska
Menu
On this page

Table Filters

Table filters allow you to limit which records are exported from Business Central. Filters are added using the Filters action on the table card.

Columns

ColumnDescription
Field IDBC field to filter on. Use the lookup to browse available fields for the table.
Field NameAutomatic field name
Field CaptionAutomatic field caption
Field FilterStandard BC filter (e.g. 1000..2000&<>*BLOCKED*, <>'', A*). Validated against the field to ensure correct syntax.

Example

To export only customers in the range 10000–20000, add a filter on the "No." field with the value 10000..20000.

Filters