I am uploading a CSV file which is been uploaded row wise in my couchbase. Now I want to show that data in table form in UI but while querying I’m getting old data first then the latest data in the end but I want to get my last uploaded or current uploaded data in that table. [data] select * fro…

Hey @shalabh.negi , I believe this is a simple case of the same query alias being used twice. Try giving your subquery a different table alias from the parent query, for instance: select b.* from Bilateral_Repo b where b.DocumentID = ((SELECT a.DocumentID from Bilateral_Repo a ORDER BY a.DocumentI…

How to get current data according to the time when it is updated

Node.js SDK

vsr1 April 18, 2018, 4:30pm 4

Hi @shalabh.negi,

Check this out for more simple approach Query for latest records of a given set of users

Topic		Replies	Views
N1QL to Node.js Node.js SDK n1ql	2	871	February 14, 2020
N1QL query to get the latest document having same value in other property in a join result of two different documents in couchbase Couchbase Server	0	501	May 28, 2019
Get document _id from N1QL query row SQL++ n1ql	1	2450	June 1, 2017
How to query all latest versions after implementing document versioning SQL++ query , n1ql	2	952	July 26, 2021
Get data by comparing the date SQL++	2	6288	September 13, 2017

How to get current data according to the time when it is updated

Related topics