I&#39;m new in using GenericForeignKey, and I couldn&#39;t make it to work in a query statement. The tables are roughly like the following:

    class Ticket(models.Model):
        issue_ct = models.ForeignKey(ContentType, related_name=&#39;issue_content_type&#39;)
        issue_id = models.PositiveIntegerField(null=True, blank=True)
        issue = generic.GenericForeignKey(&#39;issue_ct&#39;, &#39;issue_id&#39;)
    
    class Issue(models.Model):
        scan = models.ForeignKey(Scan)

A scan creates one issue, an issue generates some tickets, and I made Issue as a foreign key to Ticket table. Now I have a Scan object, and I want to query for all the tickets that related to this scan. I tried this first:

    tickets = Tickets.objects.filter(issue__scan=scan_obj)

which doesn&#39;t work. Then I tried this:

    issue = Issue.objects.get(scan=scan_obj)
    content_type = ContentType.objects.get_for_model(Issue)
    tickets = Tickets.objects.filter(content_type=content_type, issue=issue)
Still doesn&#39;t work. I need to know how to do these kind of queries in django? Thanks.

All Generic Foreign-Key Solutions on Gang of Coders

Total of 1 Generic Foreign-Key Solutions

django: how do I query based on GenericForeignKey's fields?