Filtering OData Results with $filter

Intermediate

Use OData $filter expressions to return only the records you need from a FileMaker table.

What you'll learn

OData $filter syntax and supported operators
String, date, and numeric filter examples
Combining filters with and/or
How $filter maps to FileMaker find operations

$filter is the OData system query option for restricting which records are returned. It supports comparison operators, logical operators, string functions, and date functions. In FileMaker OData, $filter translates to a FileMaker find -- understanding both is key to writing effective filters.

1/4

Basic comparison operators

OData $filter supports: eq (equal), ne (not equal), lt (less than), le (less than or equal), gt (greater than), ge (greater than or equal).

HTTP

// Equal
?$filter=Status eq 'Active'

// Greater than a date
?$filter=CreatedAt gt 2024-01-01T00:00:00Z

// Not equal
?$filter=Country ne 'US'

Querying Records with OData Selecting Fields and Sorting with $select and $orderby