Can't filter between two number values
Wanted to ask here before raising a bug/featreq.
Currently, if I add a
greater than
filter to a number
field in Companies, then try to add a less than
filter, my first filter just gets replaced by the second. As far as I can tell, there's no way for me to filter between two values, which seems like a miss.
Can anybody replicate this or is it just happening on my local instance?5 Replies
filter=position[gte]:4,position[lte]:5
seems to work properly. Can you paste your url query parameters?Sorry, should have added that this is through the UI, not api
Validated though that the request body when doing this through the ui only submits one of gte or lte, not both.
"variables":{"filter":{"latestIncome":{"amountMicros":{"gte":1000000}}}
@basicbass yes it's not possible on the product indeed, having multiple filters on the same field is not possible at the moment
I have talked with @Thomas and that's something we would introduce as an "Advanced filters" (or Filter Group) where we would need to support "AND" and "OR" predicates
I'm sorry I don't see a workaround for this one
We will likely implement the Advanced Filters later this year but not likely before November
Cool, no worries @charles thank you. For what it's worth (in case anybody else has this issue in the meanwhile), I worked around it by figuring out which filter wouldl result in fewer records, then I just exported the companies and did it in a spreadsheet (good enough for my purpose).
Is there anywhere you'd like me to record my use case / user story so you have it when it's useful?
@basicbass let's open a Discussion with your usecase. We can discuss from there too