user13729875
user13729875

Reputation:

how can I get related users, of a given team? DRF

How can I get the users that are to a team, Ex: where Team master = 1 for example

this is my models :

from django.db import models
from users.models import CustomUser

# Create your models here.
class Team(models.Model):
    master = models.ForeignKey(CustomUser, on_delete=models.CASCADE)
    name = models.CharField(null=False, blank=False, max_length=255)
    comment = models.CharField(null=True, blank=True, max_length=255)

class TeamUser(models.Model):
    team = models.ForeignKey(Team, on_delete=models.CASCADE)
    user = models.ForeignKey(CustomUser, on_delete=models.CASCADE)

My serializer :

from rest_framework import serializers
from apps.teams.models import Team, TeamUser

class TeamUserSerializer(serializers.ModelSerializer):
    class Meta:
        model = TeamUser
        fields = '__all__'


class TeamSerializer(serializers.ModelSerializer):
    
    class Meta:
        model = Team
        fields = '__all__'

I want to get all the users that are related to team master 1

Upvotes: 0

Views: 35

Answers (1)

willeM_ Van Onsem
willeM_ Van Onsem

Reputation: 477230

You can filter with:

CustomUser.objects.filter(teamuser__team__master_id=1)

This will retrieve all CustomUsers that have a related TeamUser that relates to a Team with as master a CustomUser with as primary key 1.

Upvotes: 1

Related Questions