Django : Ignore a __in type filter in the queryset if it searches the empty list

user_19460381 0
Viewed 54

Having this code sequence:

queryset = self.filter(
            brand_id__in=(
                UserObjectPermission.objects.filter(
                    content_type=brand_ctype,
                    user=user,
                ).values_list('object_pk')
            )
        )

If there is no UserObjectPermission object that matches the filter content_type=brand_ctype, user=user then the end result will be empty queryset, because brand_id __in will search in [empty queryset].

But I need the reverse. If there is no UserObjectPermision object for this filter (content_type=brand_ctype, user=user) then return all objects, that is, ignore this filter (

brand_id__in=(UserObjectPermission.objects.filter(
                    content_type=brand_ctype,
                    user=user,
                ).values_list('object_pk')
            )

I need the brand_id__in filter to run only if there is at least one object in the queryset.

django-queryset django-orm django python
1 Answers

You can check if the queryset contains any items:

brands = UserObjectPermission.objects.filter(
    content_type=brand_ctype,
    user=user,
).values_list('object_pk')

if brands:
    queryset = queryset.filter(brand_id__in=brands)
user_675790
Related