N1QL - Getting Started

Thanks for your reply…

My issue got resolve.

I have one quick question if could help me with this.

how to query below data , If my profile is stored in plain array.

[
123, - > country Code
865, -> Telco
456789079 -> Mobilenumber
]

If i want to select Telco count by country wise , then how to use this array in query.

select doc[0] from ifa limit 1 ;

above query is not working , can you please let me know how to solve this.

or else i will have to update my all profiles with at list one key , eg
{
“u”: [
123,
865,
456789097
]
}

Then i can query like select u[0] from ifa limit 1 ;

SO , DO i Need to ADD “u” for all profiles which are already exist

Regards,
Ashwini Ahire