Ecto allows to compose a query, like this: def for_patio(query \\ __MODULE__, %Patio{} = patio) do query |> join(:inner, [pe], _ in assoc(pe, :patios), as: :patios) |> where([patios: p], p.id == ^patio.id) end def for_parceiro(query \\ __MODULE__, %Parceiro{} = parceiro, voucher) do query …

Honestly it just depends on how you’re using it. For instance, if you’ve got a live view somewhere, you can do this: assign(socket, :published_posts, Post.published!()) But you can also do assign(socket, :published_posts, Post.read!(query: Ash.Query.filter(published == true)) If you are consider…

You’d use calculations for this: calculations do calculate :for_patio, :boolean, expr(exists(patios, id == ^arg(:id)) do argument :id, :uuid, allow_nil?: false end calculate :for_parceiro, :boolean, expr(exists(parceiros_precos_estadias, parceiro_id == ^arg(:parceiro_id) and voucher == ^…

You can also just let the caller filter Query |> Ash.Query.filter(exists(patios, id == patio_id)) |> Ash.Query.filter(exists(parceiros_precos_estadias, parceiro_id == ^parciero_id and voucher == ^voucher)) |> YourApi.read() this is safe to let them do, because all logic ultimately goes through a r…

Thanks @zachdaniel . With all this explanation I can move on. I think I get stucked 'cause I feel I have to put all queries inside actions. As far as I can see, it’s not true. Many examples you give show queries that don’t rely on actions, right? In this case, should I create a regular module and put…

No problem :slight_smile: I appreciate your questions, and I while we definitely want to improve the documentation, having these kinds of questions here in the forum will help other people when they have similar questions. Documentation improvements are a longer term type thing, but this will help p…

Sure. I hope more devs jump into Ash’s world and take advantage of it. These newbie’ questions may help them too.

Hey @tellesleandro i just wanna say that your questions and the ensuing discussion is very helpful for newbies like me. Thanks for asking these questions! :grin:

Welcome @yasoob . I’m developing real world application for real world customers, not only CRUD examples. So, expect to find more and more newbie questions from me here.

Elixir Programming Language Forum

How to compose queries?

Questions & Help Questions

tellesleandro October 9, 2023, 7:48pm 6

Great. I’ll follow these advices. Thanks.