N1ql deep nested array returns empty

SQL++
1

hi folks,

I have a document that looks like this:

{
“name”: “Server1”,
“configuration_category”: {
“config.category.admin”: [
{
“admin.container.basicauth.enabled”: “false”
}
],
“config.auz.client”: [
{
“cached.auz.decision.service.expirationTimeInSeconds”: 43000
},
{
“cached.auz.decision.service.cacheTimeout”: 300
}
]

i am trying to get the value of cached.auz.decision.service.cacheTimeout, however it returns an empty result

example:
cbq> select configuration_category.config.category.admin.admin.container.basicauth.enabled from EM-NP USE KEYS [“soa.nd.config.dv-laird-mp-virt.dvsoa”];
{
“requestID”: “e425844e-6e53-4369-9be9-e6b222b62ff6”,
“signature”: {
“admin.container.basicauth.enabled”: “json”
},
“results”: [
{}
],
“status”: “success”,
“metrics”: {
“elapsedTime”: “1.766721ms”,
“executionTime”: “1.711098ms”,
“resultCount”: 1,
“resultSize”: 2
}
}

expected result:
“admin.container.basicauth.enabled”: “false”

2

Several issues. See documentation for (1) syntax for path expressions, and (2) using back ticks to escape field names.

3

mus be copy-paste error:

here is my actual statement with backticks

select configuration_category.‘config.category.admin’.‘admin.container.basicauth.enabled’ FROM ‘EM-NP’ USE KEYS [“soa.nd.config.dv-laird-mp-virt.dvsoa”];

4

got it sorted out :slight_smile:

configuration_category.‘config.category.admin’[0].‘admin.container.basicauth.enabled’

1 Like