Skip to content

filtering.md

Latest commit

 

History

History
35 lines (21 loc) · 947 Bytes

filtering.md

File metadata and controls

35 lines (21 loc) · 947 Bytes

Filtering

Filtering reduces result size and improves performance.

Equality Filter

GET /api/data/v9.2/accounts?$select=name&$filter=name eq 'Contoso'

Multiple Conditions

GET /api/data/v9.2/accounts?$select=name,telephone1&$filter=statecode eq 0 and contains(name,'Health')

Date Filter

GET /api/data/v9.2/incidents?$select=title,createdon&$filter=createdon ge 2026-01-01T00:00:00Z

Null Filter

GET /api/data/v9.2/contacts?$select=fullname,emailaddress1&$filter=emailaddress1 eq null

Practical Tips

  • filter early
  • retrieve only needed columns
  • test with realistic data volume
  • watch for permissions affecting returned data

Language Examples

For practical $filter examples in code, see: