Hello 👋
I would like to ask a few questions about CRUD using cluster queries and key value pair requests. Using K/V operations, I successfully managed to:
get a document by id;
delete a document by id;
update a document by id;
create a document using general base URL;
When I am making a K/V create operation, as a key, I am using “nanoId” library to generate a random string that will be the key; So I can post the new document into a base URL without a query string with params;
Furthermore, my document has its own Id which is a numeric value different from the key.
So when I am trying to get all documents by using K/V, I am not sure how to do it.

export async function getBooks() {
try {
const cluster = await couchbaseConnect();
const bucket = cluster.bucket("BookStore");
const scope = bucket.scope("books")
const collection = scope.collection("books");
const result = await collection.get(id)
//id would be undefined here and I want to get all documents
console.log("I am the result from models", result)
return result.content;
} catch (error) {
console.log(error);
}
}
router.get("/", async function (req, res) {
const result = await getBooks();
return res.json({ success: true, payload: result });
});
I can’t get my head around what to put inside const result = await collection.get as I want to get all documents?
Can I do it using K/V pairs or shall I use cluster.query?
when I am trying to use cluster.query, to get documents by a certain query parameter, it seems that there are some errors in the syntax that I can’t resolve…
SELECT id, title, info FROM \BookStore`.books.books
WHERE title = ${title}`;
My bucket is called BookStore, with the scope called “books” and the collection called “books”
key "KQKk6pqbk3TSH" from nanoid

{"id":7,"title":"Book","info":[{"description":12002223,"price":123,"cover":"https://m.media-amazon.com/images/I/61NP3Oa+TSL.jpg"}]}
Also, this is my document structure, if info has nested object in an array, do I need to reflect it in SELECT id, title, info [{something something?}]
Thanks! 😊