Postgresql – How to annotate django queryest using subquery where that subquery returns list of ids from related model records
I have one database model, let's say ModelA: class ModelA(models.Model): field_1 = models.ManyToManyField( "core.ModelB", blank=True ) user = models.ForeignKey("core.User", on_delete=models.CASCADE) type = models.CharField(choices=ModelATypes.choices) The field_1 of ModelA is a many to many field that references ModelB. class ModelB(models.Model): uid =…