How to add a group of or_where conditions to the query which already has some where closes

[igor]

Found two similar topics on this forum:

Grouping where and or_where clauses

Sorry to resurrect an old thread, but I’m facing a similar issue composing this query (which is used in a larger composed query). I’m using Ecto.Query to implement an AND and grouped OR query, similar to SELECT * FROM cities as c WHERE c.founded > '1900-01-01' AND c.founded < '1950-12-31' AND ( c.population > 1000000 OR c.has_landmark = true ) #this is what I'm trying to replicate I tried chaining or_where/2, like so: or_where(query, status: "Locked") |> or_where(statu…

Is this query possible in Ecto?

Hi I am putting together a dynamic query with an arbitrary number of conditions SELECT v.id FROM visitors v JOIN trackings t ON t.visitor_id = v.id WHERE v.app_id = '123' AND -- N conditions.. ( (t.field = 'admin' AND t.boolean_value) OR (t.field = 'users_created' AND t.integer_value > 1) OR ... (t.field = 'username' AND t.string_value = 'jack') ) GROUP BY v.id HAVING COUNT(*) = <number of conditions> But I don’t seem to be able to find a wa…

That’s where the dynamics were presented by Ecto. But I can’t figure out how to apply them to my case.