django filter on the basis of text length

by

For modern Django (>=1.9) @hynecker‘s answer is better.

For Django >= 1.8 you can use an annotation and the Length function:

from django.db.models.functions import Length
qs = MyModel.objects.annotate(text_len=Length('text_field_name')).filter(
    text_len__gt=10)

Under the hood, Django uses is @Pratyush’s suggested CHAR_LENGTH() MariaDB (MySQL) function. But the Django Length function will work for any Django-compatible db by using LENGTH() for Postgres and other databases.

More Related Contents:

  1. How do I filter query objects by date range in Django?
  2. Django filter queryset __in for *every* item in list
  3. Django Aggregation: Summation of Multiplication of two fields
  4. How can I filter a date of a DateTimeField in Django?
  5. How can I filter a Django query with a list of values?
  6. Getting the SQL from a Django QuerySet [duplicate]
  7. How do I do a not equal in Django queryset filtering?
  8. Django Query That Get Most Recent Objects From Different Categories
  9. How do I get the object if it exists, or None if it does not exist in Django?
  10. Django orm get latest for each group
  11. django – convert a list back to a queryset [duplicate]
  12. Django values_list vs values
  13. many-to-many in list display django
  14. How to combine multiple querysets in Django?
  15. “_set” in a queryset object in Django
  16. Count number of records by date in Django
  17. aggregate() vs annotate() in Django
  18. Count() vs len() on a Django QuerySet
  19. How to perform OR condition in django queryset?
  20. Simple Subquery with OuterRef
  21. QuerySet, Object has no attribute id – Django
  22. Django custom annotation function
  23. Using .aggregate() on a value introduced using .extra(select={…}) in a Django Query?
  24. How to do many-to-many Django query to find book with 2 given authors?
  25. Get the latest record with filter in Django
  26. Django filter JSONField list of dicts
  27. How to annotate Count with a condition in a Django queryset
  28. How to delete a record in Django models?
  29. Can a dictionary be passed to django models on create?
  30. How to use custom AdminSite class?

Leave a Comment