开发者

CosmosDB - SQL: Check if property in JSON file not exists

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜