Does anyone know how to use the [$between] filter? I’ve reviewed the documentation and searched around the web but can’t find anything explaining how the Is Between filter works.
Hey there ,
In REST, you have to use between as below:
https://www.siteurl.com/api/tablename?filters[jobPrice][$between]=100&filters[jobPrice][$between]=250
Hope this helps you.
Thanks
Thank you for the response but I was hoping it worked differently. I was thinking I could check if a number was between two different fields.
Something like this:
/api/tablename?filters=1600[$between][start_time][$and][end_time]
I’m currently doing this with less than and greater than. Just seems like a lot to check:
/api/tablename?filters[$and][0][hours][start][$lt]=1600&filters[$and][1][hours][end][$gt]=1600