擅长:python、mysql、java
<p>如果用<a href="https://docs.djangoproject.com/en/stable/ref/models/fields/#django.db.models.ForeignKey.related_name" rel="nofollow noreferrer"><strong>^{<cd2>}</strong></a>更新<code>ForeignKey</code>字段,如下所示:</p>
<pre><code>class Calculator(models.Model):
tarifa = models.ForeignKey(Tarifa, on_delete=models.CASCADE, related_name='calculators')
base = models.DecimalField(max_digits=10, decimal_places=2, null=True, blank=True)
limite = models.DecimalField(max_digits=10, decimal_places=2, null=True, blank=True)
</code></pre>
<p>然后你可以这样尝试:</p>
<pre><code>Tarifa.objects.filter(Q(limite_s__gte=F('calculators__base'))&Q(limite_i__lte=F('calculators__base')))
</code></pre>