I would like to check, if for example the field 'street' does not exists.
I tried this: SELECT * FROM c WHERE NOT IS_DEFINED(c.street)
This query gives me all entries that do not have the 'street' defined. If instead of 'street', 'street: "abc"' were written there, then this query would return no result.
I am looking for something else. I want to know if 'street' or 'abc' does not 开发者_Go百科exist. I think, I need an CosmodDB query, which checks, if the property is not in this array. I hope it was understandable.
{
"customerId": "123456",
"adress": [
"street",
"streetnumber": 1,
"postcode" : 52965,
"city": "test"
],
}
Thank you.
精彩评论