Couchbase Document Not Found in Query Work Bench

Couchbase Server
1

Hi Team,

We had seen one strange behavior in the CB cluster. While searching the document with the doc id in the document search section, I was able to find it, but while searching the same in the query work bench result showed zero. Any idea why such a thing is happening. Please suggest if anything I am missing.

Thanks,
Debasis

2

Probably the document did not match the search you did in the query workbench. It’s not possible for me to tell as you didn’t post the document and the search.

To reference the document id in n1ql, use meta().id. (just id would reference a json property named id).
i.e. “SELECT * from my_collection where meta().id=‘abc123’”

1 Like
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.