How to Do a Not Equal in Django Queryset Filtering

How do I do a not equal in Django queryset filtering?

You can use Q objects for this. They can be negated with the ~ operator and combined much like normal Python expressions:

from myapp.models import Entry
from django.db.models import Q

Entry.objects.filter(~Q(id=3))

will return all entries except the one(s) with 3 as their ID:

[<Entry: Entry object>, <Entry: Entry object>, <Entry: Entry object>, ...]

How do I change the filter in django to reflect not equal to?

Use the exclude method. Details here.

open_slots = Opening.objects.filter(club_id=club_id, day=datetime.date.today()).exclude(reservation ='Open')

Django model query with not equal exclusion

It's a kind of logical question.

Exclude (field1 != value1) is same as Include(field1 = value1)

So, you can use the filter() metbod as,

Object.objects.filter(param1=p, param4=q).exclude(param2=False, param3=False)

Or

Use Q() object with ~ symbol

from django.db.models import Q
Object.objects.filter(param1=p).exclude(~Q(param4=q), param2=False, param3=False)

How to filter queryset not equal to in Django?

I think you would combine the records for each of your conditions using Qobjects, then do distinct() to remove duplicates:

now = timezone.now()
items_within_date_range = Q(start_date__lte=today, end_date__gte=today)
curr_store_items = Q(store=store_id)

result = SaleItems.objects.filter(items_within_date_range|curr_store_items).distinct()

The first query would get all items within time range for both your store and other stores, second query would get all items for your store, then combine then would get everything.

In a Django QuerySet, how to filter for not exists in a many-to-one relationship

Note: this answer was written in 2013 for Django 1.5. See the other answers for better approaches that work with newer versions of Django

Use isnull.

users_without_reports = User.objects.filter(report__isnull=True)
users_with_reports = User.objects.filter(report__isnull=False).distinct()

When you use isnull=False, the distinct() is required to prevent duplicate results.

, , = and = don't work with filter() in Django

Greater than:

Person.objects.filter(age__gt=20)

Greater than or equal to:

Person.objects.filter(age__gte=20)

Less than:

Person.objects.filter(age__lt=20)

Less than or equal to:

Person.objects.filter(age__lte=20)

You can find them all in [the documentation].(https://docs.djangoproject.com/en/stable/ref/models/querysets/).

Combination of equals and not equals in Django filter

You can use Q objects for such a scenario,

from django.db.models import Q
peculiarties = MetricAssociation.objects.filter(Q(metric=metric) & ~Q(specifics=None))

Django filtering on a queryset not working

You need to update query_set not just call the function.

...
if len(self.status) > 0:
    queryset = queryset.filter(status__in=self.status)

queryset = queryset.order_by('-created_on')

---

Related Topics