Django filter on generic relationship

Question

I have a model below which points to a generic relationship. This can either be a contact object or a customer object.

class Unsubscribe(models.Model):
    """
    Notes:
    See: http://www.screamingatmyscreen.com/2012/6/django-and-generic-relations/
    """
    content_type = models.ForeignKey(ContentType, help_text="Represents the name of the model")
    object_id = models.PositiveIntegerField(help_text="stores the object id")
    content_object = generic.GenericForeignKey('content_type', 'object_id')

    reason = models.CharField(max_length=60)

    request_made = models.DateTimeField(auto_now_add=True,
                                   help_text="Shows when object was created.")


    class Meta:
        ordering = ['-request_made']

I would like to list out all unsubscribed both unsubscribe customers and contacts only for the user.

 queryset = Unsubscribe.objects.filter()

Above gives me all unsubscribe customers and contacts for any users normally I would solve this by doing....

queryset = Unsubscribe.objects.filter(user=request.user)

However, Unsubscribe object does not have a user, but both customers and contacts do.

So how can I filter on the generic relationship?

Answer 1

You could try this

Unsubscribe.objects.filter(content_type__name='user', user=request.user)

For content_type__name='user' specify name of your model class for user or whatever you have associated it with.

Or this also

Unsubscribe.objects.filter(content_type__name='user', object_id=request.user.id)