doableware / djongo

Django and MongoDB database connector
https://www.djongomapper.com
GNU Affero General Public License v3.0
1.86k stars 352 forks source link

Can not filter queryset multiple times, return not found on 2nd filterd. #612

Open tqlucitvn opened 2 years ago

tqlucitvn commented 2 years ago

One line description of the issue

Can not filter multiple times

Python script

  queryset = queryset.filter(tags=1)
  queryset = queryset.filter(tags=2)
```python class ContentListCreateAPIView(generics.ListCreateAPIView): queryset = Content.objects.all().order_by('id') serializer_class = ContentCreateSerializer pagination_class = ContentResultsetPagination # permissions_classes = [IsAuthenticated,] def list(self, request, format=None): queryset = self.get_queryset() queryset = queryset.filter(tags=1) queryset = queryset.filter(tags=2) # pagination page = self.paginate_queryset(queryset) if page is not None: serializer = ContentRetrieveSerializer(page, many=True, context={"request": request}) return self.get_paginated_response(serializer.data) serializer = ContentRetrieveSerializer(queryset, many=True, context={"request": request}) return Response(serializer.data) ``` #### Traceback No Error, only not found exception. Suppose I have Content and Tag models that have ManyToMany relationship and content objects that have tags_id = [1, 2] avaiable in database. I've tried with MySQL it work smooth. But with djongo + mongodb, it return not found.