nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to query index of Document (the "ecm:pos") via Java API?

erdmann_

While coreSession.query() works fine for "SELECT * FROM Document WHERE ... order by ecm:pos " i do not find a way to get this ecm:pos value.

Unfortunately, it is not one of the getters of DocumentModel. The simple trial with "SELECT * , ecm:pos FROM" does not throw an error, but always 0 items (at least against SQLRepositoryTestCase)

and if it would work, what is the result object's type?, The only docs i found are the NXQL spec and the API (but i'am sure, i missed some)

Thanks,

[And as this is my first post ever: Many thanks for nuxeo! Great job!]

Find more posts tagged with

Accepted answers

Florent_Guillau

Today the only way to get at the ecm:pos of a document is to do a query using the queryAndFetch API and request the value of ecm:pos:

SELECT ecm:uuid, ecm:pos, ... FROM Document WHERE ...

All comments

Florent_Guillau

Today the only way to get at the ecm:pos of a document is to do a query using the queryAndFetch API and request the value of ecm:pos:

SELECT ecm:uuid, ecm:pos, ... FROM Document WHERE ...

erdmann_

Thanks, works fine.

Florent_Guillau

Orderable is a property of the folder contain the documents, not of the documents themselves.