sezaru
How to sort by a value from a joined resource?
Let’s say I have this resource;
defmodule A do
...
relationships do
belongs_to :b, B do
allow_nil? false
attribute_writable? true
end
end
end
defmodule B do
...
attributes do
...
attribute :score, :decimal
end
end
I want to query the resource A but join resource B and sort it by the score attribute. How can I do that?
Marked As Solved
zachdaniel
The most straightforward way is to use a calculation and sort on the calculation.
calculate :score, :decimal, expr(b.score)
and now you can sort by score 
Also Liked
jclement
Disregard. I forgot to mark the calculation value as public. parse_input is totally doing it’s job! Sorry.
For anyone else who makes the same mistake. Calculation should have been:
calculations do
calculate :customer_name, :ci_string, expr(customer.name), public?: true
end
jclement
So sorry about that! I appreciate the response and the note on additional handler. That’ll come in handy. Thank you!
Popular in Questions
Other popular topics
Latest Ash Threads
Latest on Elixir Forum
Sponsor Spotlight
Real-time error tracking, performance insights, and observability for devs.
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.
Producing high quality Elixir screencasts since 2017.
Courses that'll move you from confusion to "Aha, now I get it!"