Hi @schulte
In create Index it needs to be
`location`.`city`
Inside back-ticks everything consider as IDENTIFIER/field it will not consider nested object. For nested objects needs separate back-ticks (or omit if no special characters present) for each field
Doc1 {"location.city" : "SJC"}
Doc2 {"location":{"city":"SJC"}}
`location.city` = "SJC" returns Doc1 not Doc2
`location`.`city` = "SJC" returns Doc2 not Doc1