Ecto AND OR precedence

[dsissitka]

It looks like this is what you’re looking for:

Is this query possible in Ecto?

Is this query possible in Ecto?

Good catch. For now you can also move the v.app_id == 123 to inside each OR. I think the query engine will be able to optimize it anyway.

Is this query possible in Ecto?

Good news! Ecto master now allows developers to build dynamic queries. Here is an example from the documentation: dynamic = false dynamic = if params["is_public"] do dynamic([p], p.is_public or ^dynamic) else dynamic end dynamic = if params["allow_reviewers"] do dynamic([p, a], a.reviewer == true or ^dynamic) else dynamic end from query, where: ^dynamic This means you should now be able to write the query above by building each dynamic piece bit by bit and then …