couchbase query returning empty answer

Question

hello im trying to get query from couchbase and getting a blank answer

this is my data :

this is my data and its keep going like that i cant get any tagnames and im kinda lost so i would be glad to get any help i tryed :

SELECT b.*
FROM mekorot[0] b
WHERE node.kind = 2

and im still getting :

{
 "results": []
}

Answer 1

I don't think IN is doing what you think it should be doing. IN is meant for queries like SELECT * FROM foo WHERE x IN ['array0','array1']. I'm not sure why this query isn't giving you parsing errors, but try this instead:

SELECT b.*
FROM backetname b
WHERE b.node.kind = 2

Here's some screenshots showing it in action: