benonymus
Ecto query for list of items' ids
Hey I am returning a list of users from a function, and I want to use that list for a query.
how could I use the ids of those items for the query selection?
def get_recording_list_by(team_members) do
recording_query =
from(
r in Recording,
preload: [:user],
where: r.user_id == ^team_members.user.id, --- questionable part
select: r
)
Repo.all(recording_query)
end
Marked As Solved
benonymus
fixed it by using in instead of ==
so the final code looks like this:
def get_recording_list_by_team_id(team_members) do
IO.inspect(team_members)
team_members_ids = Enum.map(team_members, fn team_member -> team_member.id end)
IO.inspect(team_members_ids)
recording_query =
from(
r in Recording,
preload: [:user],
where: r.user_id in ^team_members_ids,
select: r
)
Repo.all(recording_query)
end
Also Liked
LostKobrakai
Or just recording_query = from Ecto.assoc(team_members, :recording), preload: [:user]
peerreynders
though you’re possibly talking about from p in Post
In general the in expression is looking for an Ecto.Queryable on the right hand side - if it’s a string it is referring to a DB table. The Ecto.Queryable is usually a module that uses Ecto.Schema
alexandre
Can anybody point to me where this IN is documented in ecto? I cannot find, and it took me so long to find this post 
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Build Elixir applications with speed and confidence.
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
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
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.
Real-time error tracking, performance insights, and observability for devs.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"