Django filter JSONField list of dicts

by

If you wan’t to filter your data by one of fields in your array of dicts, you can try this query:

Test.objects.filter(actions__contains=[{'fixed_key_1': 'foo2'}])

It will list all Test objects that have at least one object in actions field that contains key fixed_key_1 of value foo2.

Also it should work for nested lookup, even if you don’t know actual indexes:

Test(actions=[
    {'fixed_key_1': 'foo4', 'fixed_key_3': [
        {'key1': 'foo2'},
    ]}
}).save()

Test.objects.filter(actions__contains=[{'fixed_key_3': [{'key1': 'foo2'}]}])

In simple words, contains will ignore everything else.

Unfortunately, if nested element is an object, you must know key name. Lookup by value won’t work in that case.

More Related Contents:

  1. How do I filter query objects by date range in Django?
  2. Django Aggregation: Summation of Multiplication of two fields
  3. How do I do a not equal in Django queryset filtering?
  4. Django values_list vs values
  5. “_set” in a queryset object in Django
  6. Count number of records by date in Django
  7. QuerySet, Object has no attribute id – Django
  8. Get the latest record with filter in Django
  9. How to delete a record in Django models?
  10. Can a dictionary be passed to django models on create?
  11. Datetime On Django on models?
  12. What is a “slug” in Django?
  13. How can I filter a Django query with a list of values?
  14. Django: add image in an ImageField from image url
  15. Django Model Field Default Based Off Another Field in Same Model
  16. Django orm get latest for each group
  17. Django: Why do some model fields clash with each other?
  18. Using a Django custom model method property in order_by()
  19. Split models.py into several files
  20. Django DateField default options
  21. How do I make an auto increment integer field in Django?
  22. How to override the default value of a Model Field from an Abstract Base Class
  23. How can I find the union of two Django querysets?
  24. Django override save for model only in some cases?
  25. What is the best way to access stored procedures in Django’s ORM
  26. Using .aggregate() on a value introduced using .extra(select={…}) in a Django Query?
  27. how to manually assign imagefield in Django
  28. How to annotate Count with a condition in a Django queryset
  29. Add custom form fields that are not part of the model (Django)
  30. How to perform filtering with a Django JSONField?

Leave a Comment