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
martmull
martmull3mo ago
filter=position[gte]:4,position[lte]:5 seems to work properly. Can you paste your url query parameters?
basicbass
basicbassOP3mo ago
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}}}
charles
charles3mo ago
@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
basicbass
basicbassOP3mo ago
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?
charles
charles3mo ago
@basicbass let's open a Discussion with your usecase. We can discuss from there too
Want results from more Discord servers?
Add your server