Working on a simple query to a BAQ I have. I would like to filter my results using $filter. I can’t quite seem to get the syntax right. Any pointers?
Thanks in advance!
If you’re using OData they use a type of syntax
- 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.
- 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
That was the missing link. Thank you @aarong .
For my example, it’s PartPlant_PersonID eq ‘SOMEBODY’
I did that in Swagger just like I have it above and it worked. But I see the URL shows the spaces converted to %20 and the dollar sign was converted to %24. I’ll have to play with that in the get request and make sure that formats properly.
Swagger uses a URLEncode library.
If you’re writing external code, you can wrap it in a library… Take a look on npm there is multiple.
Sorry for the necro but it feels better to keep this all together. We were needing to use a precedence group filter and I found this MS github post helpful
1 Like