Firstly, I'm sorry if this question sounds too stupid. But I recently study N1QL and need some way out for my statement. My bucket name is MultiSiteResponseTime, and I try to get the result of all the hours by doing " select HourResponsetime.Hour from MultiSiteResponseTime; ". But I do not get any result. From what I understand, if you want to access internal elements, you should use it like this: HourResponsetime.Hour , but I'm not sure where I am going wrong. Also, if you could help me get the result of a specific key, for example, I would like to know the ResponseTime result present for Hour 1.
{
"Para": "ResponseTime",
"Date": "18-04-2016",
"Qantas": {
"HourResponsetime": [
{
"Hour": 0,
"ResponseTime": 8
},
{
"Hour": 1,
"ResponseTime": 9
},
]
}
}