I’m trying to do something but I’m not sure how to achieve the desired result. So I’m asking for your help to understand if I’m doing something wrong
I have a collection with some fields. One of these fields is an amount which is stored in the DB in cents and it’s shown in forest accordingly (with the “price” widget Display widgets - Documentation).
Now, I want to filter the records in this collection, in order to find the items with a specific amount. As far as I can see, I need to input in the filter the amount in cents, matching the underlying data. Isn’t it?
How can I enable users to fill in the actual value? I mean, if the “logical” amount is
1234,56, in the database I have
1234.56 is shown in the collection. I want the users to type in
1234.56 in the filter to match this item. But it looks like they have to type in
123456 in order to have a match.
How can I manage “price” items in the filters as well?