Hi Isuru, For 2nd issue, you can try with lucene range search[1].
[1] https://lucene.apache.org/core/2_9_4/queryparsersyntax.html#Range Searches Thanks and Regards. On Fri, Nov 20, 2015 at 5:37 PM, Isuru Wijesinghe <[email protected]> wrote: > Hi All, > > We're currently developing the dashboard for BPS statistics data and we > encounter some problems mentioned below. > > 1.) Does DAS already support a sorting feature to retrieve the aggregated > data in the ascending order ? > > Why we need sorting feature here because let's say as an example, if we > are analyzing the involvement of different users in a particular process, > we have to provide the process ID as the primary filter. There can be a > large number of users in the system which could result in too many entries > in the X axis. To overcome this, most graphs have to provide a secondary > filter to obtain only top X or bottom X entries (asc or dsc ordering). > > When retrieving the records through the faceted search for the columns > which have the aggregated values(eg: avg, sum, etc) from the DAS REST API, > the data is usually listed in random order. As a solution for that, need to > provide a mechanism in the DAS side to sort the records in the column such > a way that they will be retrieved in a specific order so that it can be > used to sort in ascending order, descending order according to the given > column or multiple columns. > > eg: { > "tableName": "USER_INVOLVE_SUMMARY_DATA", > "groupByField": "processDefKey", > "query": "assignee:admin", > *"sort":"totalInvolvedTime asc"*, > "aggregateFields": [ > { > "fieldName": "duration", > "aggregate": "SUM", > "alias": "totalInvolvedTime" > } > ] > } > > 2.) Is it possible to do range faceting in DAS? > > (Here the range facet produces multiple range buckets over numeric fields > or date fields.) > Let's say as an example we have a field called *price* in one of the > summarized tables and we have that field faceted. We want to get the facets > as ranges of values (*eg:* *0-100, 100-500, 500-1000, etc* - these are > the ranges that prices fall into). Is it possible to calculate the ranges > (facet counts for the ranges of prices - eg: say for 5 values) based on the > values in the table ? > > -- > Isuru Wijesinghe > *Software Engineer* > WSO2 inc : http://wso2.com > lean.enterprise.middleware > Mobile: 0710933706 > [email protected] > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Rukshan Chathuranga. Software Engineer. WSO2, Inc.
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
