开发者

QuerySet for non-empty TextField

开发者 https://www.devze.com 2022-12-18 20:21 出处:网络
For a model like: class Item(models.Model): notes = models.TextField(blank=True) .... I\'m attempting to do a simple queryset for all Items where the \"notes\" field is non-empty. Not finding menti

For a model like:

class Item(models.Model):
    notes = models.TextField(blank=True)
    ....

I'm attempting to do a simple queryset for all Items where the "notes" field is non-empty. Not finding mention of this capability in the docs, but via a comment on a bug report, discovered that you can actually compare with greater than:

items_with_notes = Item.objects.filter(notes__gt='')

This works, but feels like a hack. "Greater than" seems like it should be开发者_高级运维 used for numeric comparisons, not for checking whether a text field is blank. Surprised not to find something like:

Item.objects.exclude(notes=blank)

Am I overlooking something, or is .filter(notes__gt='') the right way to do it?


.exclude(notes=u'')

Read more here: django.db.models.query.QuerySet.exclude


you can also use Q object:

from django.db.models import Q
Item.objects.filter(~Q(notes=''))
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号