how to write a query to get find value in a json field in django

by

If you are using the django-jsonfield package, then this is simple. Say you have a model like this:

from jsonfield import JSONField
class User(models.Model):
    jsonfield = JSONField()

Then to search for records with a specific username, you can just do this:

User.objects.get(jsonfield__contains={'username':username})

More Related Contents:

  1. How to filter empty or NULL names in a QuerySet?
  2. Custom QuerySet and Manager without breaking DRY?
  3. Why does django’s prefetch_related() only work with all() and not filter()?
  4. Select DISTINCT individual columns in django?
  5. Raw SQL queries in Django views
  6. How to limit queryset/the records to view in Django admin site?
  7. Django: implementing JOIN using Django ORM?
  8. Django – filtering on foreign key properties
  9. Django query datetime for objects older than 5 hours
  10. Django: Does prefetch_related() follow reverse relationship lookup?
  11. django most efficient way to count same field values in a query
  12. Django Order By Date, but have “None” at end?
  13. How do I do an OR filter in a Django query?
  14. How to express a One-To-Many relationship in Django?
  15. Django – Circular model import issue
  16. Setting the selected value on a Django forms.ChoiceField
  17. Django: Set foreign key using integer?
  18. Django ModelForm: What is save(commit=False) used for?
  19. django – get() returned more than one topic
  20. Django custom managers – how do I return only objects created by the logged-in user?
  21. Django: Validate file type of uploaded file
  22. Django data migration when changing a field to ManyToMany
  23. Django accessing ManyToMany fields from post_save signal
  24. Dropdown in Django Model
  25. how to show datepicker calendar on datefield
  26. How to query Case-insensitive data in Django ORM?
  27. Django comparing model instances for equality
  28. How to select a record and update it, with a single queryset in Django?
  29. Django Migrations Add Field with Default as Function of Model
  30. Can a dictionary be passed to django models on create?

Leave a Comment