Knowledge Drop

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


Userlevel 1

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.                

 

 


0 replies

Be the first to reply!

Reply