Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-13708

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

    XMLWordPrintable

    Details

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

      Description

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

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

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                PagerDuty

                Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.