How to filter queryset not equal to in Django?

Question

I have models called Stores and SaleItems which look some what like this.

class Stores(models.Model):
    name = models.CharField(unique=True, max_length=20)


class SaleItems(models.Model):
    sale_by = models.ForeignKey(Stores)
    start_date = models.DateTimeField()
    end_date = models.DateTimeField()

So I need to retrieve sale items based on the following conditions.

If its not my store, then leave out items having start_date greater than today and end_date lesser than today.
If its my store, then get items irrespective of start_date and end_date.

So in my views.py, this is how far I have come up.

class SaleItemsView(viewsets.ModelViewSet):
    querys = SaleItems.objects.all()


def get_queryset(self):
    #get my store id
    store_id = self.request.query_params.get('store_id')
    querys = SaleItems.objects\
            .exclude(store__ne=store_id, end_date__lt=timezone.now())\
            .exclude(store__ne=store_id, start_date__gt=timezone.now())
    return querys

But it seems django doesn't have not equal operator any more. Is there any other way I can achieve this?

1) What is the error you're getting? 2) Does it maybe have to do with the typo ".exculde" ? — RemcoGerlich, Nov 17 '15 at 14:57
@RemcoGerlich Thats just a typo over here. This is the error which I'm getting for using __ne 'TypeError: Related Field got invalid lookup: ne' — Karthik RP, Nov 17 '15 at 15:01
[this](http://stackoverflow.com/questions/687295/how-do-i-do-a-not-equal-in-django-queryset-filtering) is the same question, doesn't it? — DevilPinky, Nov 17 '15 at 15:20
@DevilPinky Nope its not., Please read the question description. — Karthik RP, Nov 18 '15 at 06:08

score 1 · Accepted Answer · answered Nov 17 '15 at 16:05

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.

How to filter queryset not equal to in Django?

1 Answers1