script
Put conditional clause dynamically in where query
I got a list of maps like this:
[%{"id" => 1}, %{"name" => "John"}]
I want to insert them in where query. These maps can be of any size.
The end query should be like this:
From q in table,
where: q.id == ^1 or q.name == "John"
I cannot hard code the above query due to the dynamic size of the list.
The end goal is to add each map with or inside where. I cannot use or_where due to requirements constraint.
Dynamics don’t solve this for me.
Is there any solution or workaround.
Any help or suggestion will be much appreciated.
Thanks
Marked As Solved
OvermindDL1
Yeah this seems precisely the use case of a dynamic:
where = Enum.reduce(conditionals, false, fn {key, value}, acc ->
dynamic([q], acc or field(q, ^key) == ^value))
end)
from q in table,
where: ^where
Also Liked
LostKobrakai
script
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Supporting innovation across the BEAM ecosystem.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #elixirconf-us
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #security
- #hex
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"