Need query to get data using offset and limit

[PiyushHM]

hi,
I am trying to create query to get items like in pagination, using offset and limit from one of the document of database.

let db = new Couchbase("database");
const data = [ { timestamp: 111, ...}, {timestamp: 112, ...}, {timestamp: 113, ...}] // lets say 10 records

let documentId = db.createDocument(
{ "data": data },
);

const results = database.query({
select: [],
where: [
{
property: "data.timestamp",
},
],
order: [{ property: "data.timestamp", direction: "desc" }],
limit: 10,
offset: 5
});

But this is not working as expected.

---

I tried using lodash but this is affecting UI (don't know why)

const documentId = await db.getDocument('data');
items = _.orderBy(documentId.data, data=>data.timestamp, 'desc').splice(offset, count);

[triniwiz]

What results are you getting ? Sent from Yahoo Mail for iPhone On Saturday, November 7, 2020, 4:24 AM, PiyushHM <notifications@github.com> wrote: hi, I am trying to create query to get items like in pagination, using offset and limit from one of the document of database. let db = new Couchbase("database"); const data = [ { timestamp: 111, ...}, {timestamp: 112, ...}, {timestamp: 113, ...}] // lets say 10 records let documentId = db.createDocument( { "data": data }, ); const results = database.query({ select: [], where: [ { property: "data.timestamp", }, ], order: [{ property: "data.timestamp", direction: "desc" }], limit: 10, offset: 5 }); But this is not working as expected. I tried using lodash but this is affecting UI (don't know why) const documentId = await db.getDocument('data'); items = _.orderBy(documentId.data, data=>data.timestamp, 'desc').splice(offset, count); — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe.

[PiyushHM]

with below query, I am getting empty array.

const results = database.query({
select: [],
where: [
{
property: "data.timestamp",
},
],
order: [{ property: "data.timestamp", direction: "desc" }],
limit: 10,
offset: 5
});

Seems I am missing something here