How N1QL get doc ID?

SQL++
1

I use N1QL to select list of results, but seem to be that the results not shown ID of these documents.

So how do use N1QL query that the result includes doc.id?

2

select meta(t).id from t;

6 Likes
3

Thanks @geraldss.
It’s done.

4

How make order with this query please.
thx

5 
SELECT META(t).id
FROM t
ORDER BY META(t).id;
1 Like
6

thx Geral
(from Orange Sophia Antipolis 18/02/16 :wink: )

1 Like
7

Salut Marwen! :relaxed:

8

Salut Gerald
Thx for again for the presentation in February and for your answer
:slight_smile: :slight_smile:

1 Like
9

Hi, I have a little question about it
its possible get in a single response all the document and the id?

SELECT META().id, * FROM app WHERE type='example'

The response is something like:

[
  {
    "app": {
      "disabled": false,
      "email": "juan.ramirez@test.ai",
      "first_name": "ivan",
      "role": "admin",
      "type": "userprofile"
    },
    "id": "documentidxxx"
  }
]

I would like get the response:

[
  {
      "id": "documentidxxx"
      "disabled": false,
      "email": "juan.ramirez@test.ai",
      "first_name": "ivan",
      "role": "admin",
      "type": "userprofile"
  }
]

It is possible?

Thnks

10 
SELECT META().id,  app.* 
FROM app  WHERE type="example";

Note: If there is already id filed inside the document it will be overwritten. You need to alias to new one.

2 Likes