#i need to aggregate on the Dict field

4 messages · Page 1 of 1 (latest)

safe trout
#

i need to aggregate on the model have field dict the value for this

{
    "kk22": {"status": "New", "condition": "Free"},
    "kk33": {"status": "New", "condition": "Free"}
}

i need to get count of serials that have status 'New'

# 
 
serial_numbers__contains={"status": "New"}

can't use this because the contains not see the nested JSON

past pebble
#

You'll have to chain the keys.