topic Re: How to query index of Document (the "ecm:pos") via Java API? in Nuxeo Forum

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

erdmann_ — Mon, 13 Aug 2012 12:08:08 GMT

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!]

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

Florent_Guillau — Tue, 14 Aug 2012 16:52:21 GMT

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 ...

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

erdmann_ — Wed, 15 Aug 2012 14:11:55 GMT

Thanks, works fine.

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

Florent_Guillau — Tue, 21 Aug 2012 15:40:01 GMT

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