Hello! I’m trying to include a dynamic selection field to an Ecto query, instead of a hard-coded one. So instead of manually running a query & update for every field, I can just pass in a list of atom fields and have it run through dynamically:
for field <- list_of_fields do
from(t in Post, where: ^t[field] < 0) |> Repo.update_all(set: [{field, 0}])
end
But running this gives me (CompileError) iex:5: undefined function t/0 (there is no such import)
Is there any way to dynamically query on fields like this? Have tried a few different ways but no luck.