Such clarifications to dynamic/2 docs would be really welcome too. 
josevalim
Creator of Elixir
konstantine
This passage is very informative. Assuming that it is accurate, it should be part of the dynamic/2 section in the docs. Also, the general advice (part of the docs) that “one should never need to invoke [Query.API functions] directly” seems to be misleading unless the ubiquity of field/2 contravenes best practice.
(This is my first post, I hope that this is the right place for stimulating improvements in the documentation.)
0
LostKobrakai
Ecto is open source. You could add those parts yourself and submit a pull request on github.
1
rafaelbatistamarcili
Hello people,
I started learning Elixir and was trying to create a dynamic filter to send an object with non-mandatory properties, so I came up with this solution.
I hope it helps.
def search filter do
query = from user in User, where: 1==1
filterByName = fn (query, filter) ->
unless is_nil Map.get(filter, :name) do
from(user in query, where: user.name == ^filter.name)
else
query
end
end
filterByEmail = fn (query, filter) ->
unless is_nil Map.get(filter, :email) do
from(user in query, where: user.email == ^filter.email)
else
query
end
end
filterByBirth = fn (query, filter) ->
unless is_nil Map.get(filter, :birth) do
from(user in query, where: user.birth == ^filter.birth)
else
query
end
end
query = filterByName.(query, filter)
query = filterByEmail.(query, filter)
query = filterByBirth.(query, filter)
Repo.all query
end
1