How to perform filtering with a Django JSONField?

by

As per the Django JSONField docs, it explains that that the data structure matches python native format, with a slightly different approach when querying.

If you know the structure of the JSON, you can also filter on keys as if they were related fields:

object.filter(data__animal="cat")
object.filter(data__name="tom")

By array access:

object.filter(data__0__animal="cat")

Your contains example is almost correct, but your data is in a list and requires:

object.filter(data__contains=[{'animal': 'cat'}])

More Related Contents:

  1. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  2. Django JSONField inside ArrayField
  3. django.db.utils.OperationalError Could not connect to server
  4. Use Django ORM as standalone [duplicate]
  5. GeoDjango on Windows: “Could not find the GDAL library” / “OSError: [WinError 126] The specified module could not be found”
  6. Django connection to postgres by docker-compose
  7. How to set up a PostgreSQL database in Django
  8. Composite primary key in django
  9. How do you join two tables on a foreign key field using django ORM?
  10. Case insensitive unique model fields in Django?
  11. Django JSONField filtering
  12. Docker- django throws error while connecting to postgres: psycopg2.OperationalError: could not connect to server: Connection refused
  13. How to find pg_config path
  14. Django ConnectionAbortedError: [WinError 10053] An established connection was aborted by the software in your host machine
  15. Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
  16. What is the default order of a list returned from a Django filter call?
  17. Django 1.9 ImportError for import_module
  18. Django filter JSONField list of dicts
  19. Deploying Django to Heroku (Psycopg2 Error)
  20. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  21. Django set default form values
  22. ImproperlyConfigured: You must either define the environment variable DJANGO_SETTINGS_MODULE or call settings.configure() before accessing settings
  23. Django Admin – change header ‘Django administration’ text
  24. find_element_by_class_name for multiple classes [duplicate]
  25. Django Rest Framework – How to add custom field in ModelSerializer
  26. django – getlist()
  27. DateTimeField doesn’t show in admin system
  28. Serializing list to JSON [duplicate]
  29. Pass additional parameters to post_save signal
  30. Django foreign key relation in template

Leave a Comment