[NXP-13708] NXQL aggregates (COUNT, AVG, SUM, MIN, MAX) - Nuxeo Issue Tracker

XML

Word

Printable

Impact type:

API change
Upgrade notes:

Hide

NXQL can now do simple aggregates:

SELECT COUNT(ecm:uuid) FROM Document WHERE ...
SELECT SUM(my:value), AVG(my:value), MIN(my:value), MAX(my:value) FROM Document WHERE ...

CoreSession.queryAndFetch must be used to get the result.

Show
NXQL can now do simple aggregates: SELECT COUNT(ecm:uuid) FROM Document WHERE ... SELECT SUM(my:value), AVG(my:value), MIN(my:value), MAX(my:value) FROM Document WHERE ... CoreSession.queryAndFetch must be used to get the result.

Implement NXQL aggregates (COUNT, AVG, SUM, MIN, MAX).

They will be of course useable only when calling session.queryAndFetch.