基于两个表Django的过滤器

from django.db import models

class ModelA(models.Model):
    field1 = models.CharField(max_length=100)
    field2 = models.CharField(max_length=100)

class ModelB(models.Model):
    field3 = models.CharField(max_length=100)
    field4 = models.ForeignKey(ModelA, on_delete=models.CASCADE)

from django.db.models import Q

# 查询ModelA中field1为"value1"且关联的ModelB中field3为"value2"的数据
result = ModelA.objects.filter(field1="value1", modelb__field3="value2")

# 查询ModelA中field1为"value1"或关联的ModelB中field3为"value2"的数据
result = ModelA.objects.filter(Q(field1="value1") | Q(modelb__field3="value2"))

from django.db.models import F

# 查询ModelA中field1的值等于关联的ModelB中field3的值的数据
result = ModelA.objects.filter(field1=F('modelb__field3'))

# 查询ModelA中field1的长度大于关联的ModelB中field3的长度的数据
result = ModelA.objects.filter(field1__length__gt=F('modelb__field3__length'))