Get Price Range on Server Action

I am trying to get a query of the price between two numbers:
For some reason, my server action does not have {{between}} in the condition area for filter.
Maybe I am missing something.
Is there anyone who can help with the input value to filter price range between 0 and certain number?

What type of fields are you using for the filter?

It should be there as per below.

The filter does change based on the type of field you select, so if your field is set up as text or varchar field in the DB it wont show BETWEEN as an option. But any sort of date or number field should show it.

3 Likes

Thank you. I saw the data was not in numeric value setup.

1 Like