DJANGO ORM LEFT JOIN [закрыто]

SQL:

` select u1.summaryUpdatedOn, u2.summary from sdgdb.user as u1 left join sdgdb.user as u2 on u1.user_id = u2.user_id and (u2.summaryUpdatedOn != '20221207030805'or u2.summaryUpdatedOn is null) where u1.sdgid = 'SDG-s6547df1445-ece35e6e-c1ea-45ae-83e8-9d9c19fab0cd';

` my Models:

` class User(BaseModel):

customer = models.ForeignKey( Customer, null=False, on_delete=models.PROTECT, db_column="customerid" )

group = models.ForeignKey(
    Group, null=False, on_delete=models.PROTECT, db_column="groupid"
)

licensetype = models.ForeignKey(
    LicenseType, null=False, on_delete=models.PROTECT, db_column="licensetypeid"
)
sdgid = models.CharField(
    max_length=64,
    null=False,
    default="temp-" + str(uuid.uuid4()),
    editable=False,
    db_column="sdgid",
)
name = models.CharField(max_length=100, null=False, default=None, db_column="name")
email = models.EmailField(
    max_length=254,
    unique=False,
    blank=True,
    null=True,
    db_column="email",
)
note = models.CharField(
    max_length=500, null=True, blank=True, default=None, db_column="note"
)
licensekey = models.CharField(max_length=100, null=True, db_column="licensekey")
isdisabled = models.BooleanField(null=False, default=False, db_column="isdisabled")
summary = models.TextField(null=True, db_column="summary")
summaryupdatedon = models.CharField(
    max_length=14, null=True, db_column="summaryupdatedon"
)

`

Я не переключился с SQL на API запрос. Пожалуйста, помогите мне

Вернуться на верх