Filter syntax for BAQ using REST API

Kinetic ERP
,
2

If you’re using OData they use a type of syntax

  1. Equality Operators:
  • eq: Tests whether a field is equal to a constant value.
  • ne: Tests whether a field is not equal to a constant value.
  1. Range Operators:
  • gt: Tests whether a field is greater than a constant value.
  • lt: Tests whether a field is less than a constant value.
  • ge: Tests whether a field is greater than or equal to a constant value.
  • le: Tests whether a field is less than or equal to a constant value.

OData comparison operator reference - Azure AI Search | Microsoft Learn

So in the filter box it would something like

SellingQuantity gt 0 - > This would be SellingQuantity greater than 0

2 Likes