Django filter object for multiple args

Question

The issue currently is filtering for all users that

Are not the user
Where model field == True

If I remove the ".filter(model="True")" than the first requirement is met. How can I add more filters to the users?

Current error message:

FieldError at /explore/ Cannot resolve keyword 'model' into field. Choices are: date_joined, email, emailaddress, favorite, first_name, groups, id, images, is_active, is_staff, is_superuser, last_login, last_name, logentry, owner, password, profile, socialaccount, user_permissions, username, webhook

I understand that the error means. However, I'm not sure how to implement it in the code.

view.py

def explore(request, pk=None):
    template_name = 've/cp/explore.html'

    users_list = User.objects.exclude(id=request.user.id).filter(model="True")

    paginator = Paginator(users_list, 16)  # Show x per page
    page = request.GET.get('page')
    users = paginator.get_page(page)

    try:
        favorite = Favorite.objects.get(current_user=request.user)
        favorites = favorite.users.all()
    except Favorite.DoesNotExist:
        favorites = None

    args = {
        'favorites': favorites, 'users': users,
    }

    return render(request, template_name, args)

models.py

class Profile(models.Model):
    user = models.OneToOneField(User, on_delete=models.CASCADE)
    bio = models.TextField(max_length=500, blank=True, null=True)
    model = models.BooleanField(default=False)
    ...

neverwalkaloner · Accepted Answer · 2018-03-09 10:16:23Z

1

Use __ with profile keyword:

users_list = User.objects.exclude(id=request.user.id).filter(profile__model="True")

answered Mar 9, 2018 at 10:16

neverwalkaloner

47.6k7 gold badges101 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Alex Winkler Over a year ago

Are you my guardian angel? This worked perfectly.. I'm a bit disappointed I did not realize that. If I need to add more filters could I keep adding .filter()

neverwalkaloner Over a year ago

@AlexWinkler you can just pass additional args to single filter: filter(profile__model="True", email="[email protected]"). This will filter records wich fit both conditions.

neverwalkaloner Over a year ago

@AlexWinkler check this section of doc: docs.djangoproject.com/en/dev/topics/db/queries/…

user459872 Over a year ago

@AlexWinkler If you wondering about profile.. in the answer it is related name that django automtically generates for the reverse relationship.(ie, User model to the Profile)

Collectives™ on Stack Overflow

Django filter object for multiple args

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related