How do i add a custom filter to my create_query api call

Knowledge Drop

Last tested: Aug 27, 2020
 

Something like this by amending your filter_expression parameter with the same syntax as you would put in your custom explore filter

 

"filter_expression": "${order_items.id} > 5 AND ${users.id} < 5",

"id": 71,

"view": "order_items",

"fields": [

"orders.id",

"order_items.count"

],

"pivots": null,

"fill_fields": null,

"filters": nul,

"filter_expression": "${order_items.id} > 5 AND ${users.id} < 5",

"sorts": [

"order_items.count desc"

]

This content is subject to limited support.                

Version history
Last update:
‎07-07-2021 01:15 PM
Updated by: