11 replies

Relational Queries

AshPostgres✅Solved

I'm new to Ash Framework and ORM frameworks
I'm trying to define a read action in a resource where I filter based on the value of a nested resource

    read :select_by_user_questionnaire do
      argument :user_id, :uuid, allow_nil?: false
      argument :questionnaire_id, :uuid, allow_nil?: false
      prepare load :question
      filter expr(user_id == ^arg(:user_id) and question.questionnaire_id == ^arg(:questionnaire_id))
    end

    read :select_by_user_questionnaire do
      argument :user_id, :uuid, allow_nil?: false
      argument :questionnaire_id, :uuid, allow_nil?: false
      prepare load :question
      filter expr(user_id == ^arg(:user_id) and question.questionnaire_id == ^arg(:questionnaire_id))
    end

Here I have

Answer

Answer

which belongs to a

Question

Question

which belongs to a

Questionnaire

Questionnaire

I'm trying to load the question resource from answers so I can see the questionnaire ID and filter by it

Here's an example of the loaded resource

   %Quiz.Answer{
     id: "11905dee-59ef-4bde-8c0a-fd192e7d7512",
     timestamp: ~U[2026-01-14 19:24:46Z],
     answer: %{"answer" => "A"},
     question_id: "050f0e5e-a748-42cd-9c83-a89a666b377b",
     user_id: "c495bfdc-d450-40f0-8d77-5f48bf4386c0",
     question: %Quiz.Question{
       id: "050f0e5e-a748-42cd-9c83-a89a666b377b",
       prompt: "new question",
       order: 1,
       type: :multiple_choice,
       options: %{"options" => ["A", "B", "C", "D"]},
       published: true,
       answer: "A",
       publish_date: ~U[2025-09-27 10:00:00Z],
       send_email: true,
       questionnaire_id: "8183b57a-80de-4bfb-a1dd-4e46dbf8bda4",
       image_id: nil,
       answer_count: #Ash.NotLoaded<:aggregate, field: :answer_count>,
       questionnaire: #Ash.NotLoaded<:relationship, field: :questionnaire>,
       image: #Ash.NotLoaded<:relationship, field: :image>,
       answers: #Ash.NotLoaded<:relationship, field: :answers>,
       __meta__: #Ecto.Schema.Metadata<:loaded, "questions">
     },
     user: #Ash.NotLoaded<:relationship, field: :user>,
     __meta__: #Ecto.Schema.Metadata<:loaded, "answers">
   }

   %Quiz.Answer{
     id: "11905dee-59ef-4bde-8c0a-fd192e7d7512",
     timestamp: ~U[2026-01-14 19:24:46Z],
     answer: %{"answer" => "A"},
     question_id: "050f0e5e-a748-42cd-9c83-a89a666b377b",
     user_id: "c495bfdc-d450-40f0-8d77-5f48bf4386c0",
     question: %Quiz.Question{
       id: "050f0e5e-a748-42cd-9c83-a89a666b377b",
       prompt: "new question",
       order: 1,
       type: :multiple_choice,
       options: %{"options" => ["A", "B", "C", "D"]},
       published: true,
       answer: "A",
       publish_date: ~U[2025-09-27 10:00:00Z],
       send_email: true,
       questionnaire_id: "8183b57a-80de-4bfb-a1dd-4e46dbf8bda4",
       image_id: nil,
       answer_count: #Ash.NotLoaded<:aggregate, field: :answer_count>,
       questionnaire: #Ash.NotLoaded<:relationship, field: :questionnaire>,
       image: #Ash.NotLoaded<:relationship, field: :image>,
       answers: #Ash.NotLoaded<:relationship, field: :answers>,
       __meta__: #Ecto.Schema.Metadata<:loaded, "questions">
     },
     user: #Ash.NotLoaded<:relationship, field: :user>,
     __meta__: #Ecto.Schema.Metadata<:loaded, "answers">
   }

If someone could point me in the right direction, I'd appreciate it.

Solution

oh, your prepare should be

prepare build(load: :question)

prepare build(load: :question)

Jump to solution

Relational Queries

AshPostgres✅Solved

I'm new to Ash Framework and ORM frameworks
I'm trying to define a read action in a resource where I filter based on the value of a nested resource

    read :select_by_user_questionnaire do
      argument :user_id, :uuid, allow_nil?: false
      argument :questionnaire_id, :uuid, allow_nil?: false
      prepare load :question
      filter expr(user_id == ^arg(:user_id) and question.questionnaire_id == ^arg(:questionnaire_id))
    end

    read :select_by_user_questionnaire do
      argument :user_id, :uuid, allow_nil?: false
      argument :questionnaire_id, :uuid, allow_nil?: false
      prepare load :question
      filter expr(user_id == ^arg(:user_id) and question.questionnaire_id == ^arg(:questionnaire_id))
    end

Here I have

Answer

Answer

which belongs to a

Question

Question

which belongs to a

Questionnaire

Questionnaire

I'm trying to load the question resource from answers so I can see the questionnaire ID and filter by it

Here's an example of the loaded resource

   %Quiz.Answer{
     id: "11905dee-59ef-4bde-8c0a-fd192e7d7512",
     timestamp: ~U[2026-01-14 19:24:46Z],
     answer: %{"answer" => "A"},
     question_id: "050f0e5e-a748-42cd-9c83-a89a666b377b",
     user_id: "c495bfdc-d450-40f0-8d77-5f48bf4386c0",
     question: %Quiz.Question{
       id: "050f0e5e-a748-42cd-9c83-a89a666b377b",
       prompt: "new question",
       order: 1,
       type: :multiple_choice,
       options: %{"options" => ["A", "B", "C", "D"]},
       published: true,
       answer: "A",
       publish_date: ~U[2025-09-27 10:00:00Z],
       send_email: true,
       questionnaire_id: "8183b57a-80de-4bfb-a1dd-4e46dbf8bda4",
       image_id: nil,
       answer_count: #Ash.NotLoaded<:aggregate, field: :answer_count>,
       questionnaire: #Ash.NotLoaded<:relationship, field: :questionnaire>,
       image: #Ash.NotLoaded<:relationship, field: :image>,
       answers: #Ash.NotLoaded<:relationship, field: :answers>,
       __meta__: #Ecto.Schema.Metadata<:loaded, "questions">
     },
     user: #Ash.NotLoaded<:relationship, field: :user>,
     __meta__: #Ecto.Schema.Metadata<:loaded, "answers">
   }

   %Quiz.Answer{
     id: "11905dee-59ef-4bde-8c0a-fd192e7d7512",
     timestamp: ~U[2026-01-14 19:24:46Z],
     answer: %{"answer" => "A"},
     question_id: "050f0e5e-a748-42cd-9c83-a89a666b377b",
     user_id: "c495bfdc-d450-40f0-8d77-5f48bf4386c0",
     question: %Quiz.Question{
       id: "050f0e5e-a748-42cd-9c83-a89a666b377b",
       prompt: "new question",
       order: 1,
       type: :multiple_choice,
       options: %{"options" => ["A", "B", "C", "D"]},
       published: true,
       answer: "A",
       publish_date: ~U[2025-09-27 10:00:00Z],
       send_email: true,
       questionnaire_id: "8183b57a-80de-4bfb-a1dd-4e46dbf8bda4",
       image_id: nil,
       answer_count: #Ash.NotLoaded<:aggregate, field: :answer_count>,
       questionnaire: #Ash.NotLoaded<:relationship, field: :questionnaire>,
       image: #Ash.NotLoaded<:relationship, field: :image>,
       answers: #Ash.NotLoaded<:relationship, field: :answers>,
       __meta__: #Ecto.Schema.Metadata<:loaded, "questions">
     },
     user: #Ash.NotLoaded<:relationship, field: :user>,
     __meta__: #Ecto.Schema.Metadata<:loaded, "answers">
   }

If someone could point me in the right direction, I'd appreciate it.

Solution

oh, your prepare should be

prepare build(load: :question)

prepare build(load: :question)

Jump to solution

Relational Queries

Relational Queries

Similar Threads

Similar Threads

Similar Threads