Aggregates with filter arguments

You can’t do that with standard aggregates, but you can do that with the new(-ish) inline aggregates syntax.

calculate :total_feedbacks, :integer, expr(
  count(feedbacks, query: [filter: expr(class_id == ^arg(:class_id))])
) do
  argument :class_id, :uuid, allow_nil?: false
end

As always, worked like a charm!

Hey @zachdaniel, I have another case where I’m not 100% sure how to solve it.

The calculations with inline aggregates worked great, but what if I want to aggregate something from one of the relationships?

For example.

Let’s say that the Class resource has a has_many relationship with another resource called Lessons.

I want to have a calculation in my Student resource that would give me number of lessons inside that class that a student is in.

What I tried to do was to first create an aggregate in the Class resource like this:

  aggregates do
    count :total_lessons, :lessons
  end

And then, inside the Student resource, I tried to create a calculation using that:

    calculate :total_lessons_in_class,
              :integer,
              expr(first(classes, query: [filter: expr(class_id == ^arg(:class_id))]).total_lessons) do
      argument :class_id, :string, allow_nil?: false
    end

But that doesn’t work.

I also tried adding a calculation that would return the current class and then I would be able to get the total_lessons field directly from it:

  calculate :current_class, :struct, expr(first(classes, query: [filter: expr(id == ^arg(:class_id))])) do
      constraints [instance_of: Core.Feedbacks.Class]

      argument :class_id, :string, allow_nil?: false
    end

But using the first aggregate doesn´t seem to be working, not sure if I’m doing something wrong with it.

So, what I’m about to show you wont’ work, but what you would want is this:

    calculate :total_lessons_in_class,
              :integer,
              expr(first(classes, query: [filter: expr(class_id == ^arg(:class_id))], field: :total_lessons)) do
      argument :class_id, :string, allow_nil?: false
    end

However, you can’t use an aggregate as the field of another aggregate. However, you can do this:

    calculate :total_lessons_in_class,
              :integer,
              expr(count(classes.lessons, query: [filter: expr(class_id == ^arg(:class_id))])) do
      argument :class_id, :string, allow_nil?: false
    end

Assuming that lesson has class_id on it.

Yep, this worked great, thanks again!