Firestore update allows to use inequality filters on multiple fields but Flutterflow block it

[armanddebesse]

Can we access your project?

• I give permission for members of the FlutterFlow team to access and test my project for the sole purpose of investigating this issue.

Current Behavior

When I want to add multiple inequality filters on the backend query of my list view, I got this error : You can only use <, <=, >, >=, !=, and not-in operators on one field per query.
Firebase can now handle this, since they released an update for this problem : https://www.youtube.com/watch?v=qMZ_q-iHqsU

Expected Behavior

As firestore has been updated to support multi inequality filters, I expect flutterflow to stop blocking this behavior.
The error You can only use <, <=, >, >=, !=, and not-in operators on one field per query. prevents me to use this usefull feature released by Firebase.

Steps to Reproduce

1. Create a project with firestore as backend DB
2. Create a list view
3. Add a backend query on a list view with multiple inequality filters on different fields.
4. Click on "confirm"
5. You will get the error message You can only use <, <=, >, >=, !=, and not-in operators on one field per query.

Reproducible from Blank

• The steps to reproduce above start from a blank project.

Bug Report Code (Required)

IT4gi8mAw49OsdhE7aX6bu9WhiYsH1g3bIc0sNtuTQIdCYDuBIYiacz4RxdVZMyodGNhKEWLpDs0wNLUvdnDL8I7G02ZbqI5yZYNQxXvXTi/aoS0Cs+eWkdDM/phJ2HG0p+n3AhSNu9pWV4O6mb7Fum/TgLbQo/7Zwh9f6PHaOI=

Visual documentation

Environment

- FlutterFlow version: 4.1.79
- Platform: desktop / web
- Browser name and version: Chrome 127.0.6533.89
- Operating system and version affected: All

Additional Information

No response

[Alezanello]

Hello!

You are right, but this is more of an enhancement request than a bug. I'm going to pass it directly to the engineering team so they are aware of it and can determine a deadline for improvement. Thank you very much for bringing this to our attention!

Best regards,
Azanello

[armanddebesse]

Hello, You are right it's not really a bug.. Thanks a lot for your answer and for all the work made by Flutter flow team ! Have a great week.

…

________________________________ From: Alezanello ***@***.***> Sent: Friday, August 2, 2024 3:29:38 PM To: FlutterFlow/flutterflow-issues ***@***.***> Cc: Armand DEBESSE ***@***.***>; Author ***@***.***> Subject: Re: [FlutterFlow/flutterflow-issues] Firestore update allows to use inequality filters on multiple fields but Flutterflow block it (Issue #3533) Hello! You are right, but this is more of an enhancement request than a bug. I'm going to pass it directly to the engineering team so they are aware of it and can determine a deadline for improvement. Thank you very much for bringing this to our attention! Best regards, Azanello — Reply to this email directly, view it on GitHub<#3533 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ARTF7WQX3GN5GND2T2SHBPDZPOCUFAVCNFSM6AAAAABL2PQUHCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENRVGQYDSNBRGI>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[Alezanello]

No problem, and thank you for bringing this to our attention. I've already generated a ticket and added it to the engineering team's backlog. :)

Have a nice weekend!

Best regards,
Azanello

[AnkitaMalik22]

Hello @Alezanello,

Do you have any updates on this? I'm currently facing the same issue.
Or is there any alternative approach we can try for now?

[npanagop]

This is issue is closed but the feature is not implemented. Are there any updates?

@AnkitaMalik22 The only workaround I found is to make a query with a single range filter and then add more filters in the Generate Dynamic Children tab of the ListView. Use the most "restrictive" filter in the query to reduce reads and cost.