Can I filter backend queries using a combination of ANDs and ORs?

Database & APIs

I need to put multiple filters on a backend query but I only see I can either relate all the filters by ANDs or ORs.

Is there a way to filter by a combination of ANDs and ORs?

For example: [match is in the future] AND[ [authUser= player 1] OR [authUser ==player2] ]

What have you tried so far?

I have tried complex logic to get around the issue including conditional visibility on the children of the listview containing the query but it's super inefficient and unreliable

Did you check FlutterFlow's Documentation for this topic?

Yes

2 replies