You are viewing a plain text version of this content. The canonical link for it is here.

Posted to oak-issues@jackrabbit.apache.org by "Thomas Mueller (JIRA)" <ji...@apache.org> on 2015/10/22 09:41:27 UTC

[jira] [Updated] (OAK-862) Aggregate (count, group by) queries

     [ https://issues.apache.org/jira/browse/OAK-862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Mueller updated OAK-862:
-------------------------------
    Fix Version/s:     (was: 1.4)

> Aggregate (count, group by) queries
> -----------------------------------
>
>                 Key: OAK-862
>                 URL: https://issues.apache.org/jira/browse/OAK-862
>             Project: Jackrabbit Oak
>          Issue Type: Improvement
>          Components: query
>            Reporter: sakshi arora
>            Assignee: Thomas Mueller
>            Priority: Minor
>
> ‘Group by’ query to get count(frequency) for each uid(could be a no. or string). This will extend to 'group by' on multiple fields, with the usual predicates ('where' - already available).
> The use-case involves, frequency-based summary charts.
> As charts are mostly frequency based, e.g. on duration, on category, on date/month/time/year.
> The data collection could range from live data to the daily scheduled synchronization.
> Required efficiency: Queries should be pretty fast, as usual location of these charts is on dashboards (which are the home pages for most sites).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)