Filtering a product collection on price

[sdussaut]

Hi!

I am trying to filter a collection on price and it seems to filter against the augmented value of the price (15,00€) instead of the raw value.

Here is what I do:

{{ collection:products as="products" paginate="24" price:gt="2000" }}

With this, some products with a price tag of 6,00€ show up while clearly they should be filtered out.

If I try a direct comparison, like these:

{{ price > 2000 }} => True for all products
{{ (price | raw) > 2000 }} => True only for products with price > 2000

Any idea on how to achieve filtering against the raw value?
I am pretty sure I am missing something obvious here 😅

Thanks!

[duncanmcclean]

The {{ collection }} tag should be querying against the raw value - augmentation only takes place after the results have been returned.

How are the prices stored in the product entries? They should be integers.

[sdussaut]

Prices are integers, yes.

[duncanmcclean]

Your code looks fine to me, and filtering like that is working on my end.... 🤔

[sdussaut]

Here is what I do and what I get: so weird!

[sdussaut]

Not sure if it can be involved in any of that, but I am using eloquent to store all products entries into a DB.
I checked the DB records, and prices are stored as integers "price": 600.

[sdussaut]

I noticed another weird behaviour: inside CP, ordering by price also seems broken. See:

[duncanmcclean]

Does sorting by stock work, or is it broken as well?

[sdussaut]

It does work as does sorting by date or any other.

[duncanmcclean]

I've just installed the Eloquent Driver, and filtering by price isn't working at all there, whereas it works using flat files.

Would you be able to open an issue on the statamic/eloquent-driver repo and I can take a look next week when I'm back at work? Feel free to link back to this discussion.

[sdussaut]

Thanks ! I will open it right away.

Edit: issue report opened here statamic/eloquent-driver#416