Context Navigation

Changes between Initial Version and Version 1 of Ticket #29697

Ticket #29697
- Property Triage Stage Unreviewed → Accepted
- Property Summary Missing FROM-clause entry for table → Complex query crashes with "missing FROM-clause entry for table"

-              initial
+              v1
 {{{
+from django.db import models
+from django.contrib.postgres.fields import JSONField
+class Company(models.Model):
+   ...
 class Status(models.Model):
     ...
     company = models.ForeignKey(
         'customauth.Company',
+        Company,
         on_delete=models.CASCADE)
     key = models.SlugField(max_length=255)
 …
     ...
     company = models.ForeignKey(
         'customauth.Company',
+        Company,
         on_delete=models.CASCADE,
         related_name='employees',
         db_index=True)
     permissions = postgres.fields.JSONField(blank=True, default=list)
+    permissions = JSONField(blank=True, default=list)
     is_superuser = models.BooleanField(default=False)
     ...
-class Company(models.Model):
-   ...
 }}}
 …
 {{{
+from django.db.models import Q, Value
+from django.db.models.functions import Concat
 Status.objects.filter(
     Q(company__employees__is_superuser=True) |