annotated with M2M field (sum values from related model)

[diegocgaona]

I have 2 models:

class Clients(model.Model):
    id = fields.IntField(pk=True)
    email = fields.CharField(max_length=60, required=True)
    industry = fields.CharField(max_length=60)
    jobs: fields.ReverseRelation["Jobs"]
    created_at = fields.DatetimeField(auto_now_add=True)


class Jobs(model.Model):
    id = fields.IntField(pk=True)
    value = fields.FloatField()
    description = fields.CharField(max_length=3000)
    client: fields.ForeignKeyRelation[Clients] = fields.ForeignKeyField(
        "models.Clients", related_name="client_job")

I want to filter some clients (by some fields, like industry) and sum the value of their related jobs:
I thought about something like this:

    result = await Clients.filter(**used_filters, owner_id=user.id) \
            .annotate(result=Sum("jobs__value")).first()

But I receive:
tortoise.exceptions.ConfigurationError: jobs__value not resolvable

It is possible to do that in a way like this?

I will try to get the client ids (filtered) and make another filter and annotate on the Jobs model, but I think maybe there's a better approach like the above. I tried some ways in the documentation, but I couldn't adapt or understand for my case.

Regards, Diego.