----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Extended Aggregates Functionality CREATION DATE..: Tue, 19 Jul 2011, 13:43 SUPERVISOR.....: IMPLEMENTOR....: COPIES TO......: CATEGORY.......: Server-RawIdeaBin TASK ID........: 230 (http://askmonty.org/worklog/?tid=230) VERSION........: WorkLog-4.0 STATUS.........: Un-Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: DESCRIPTION: This idea is really an extension to SQL. It was implemented at my suggestion for the SQL like EPL (Event Processing language) over at Esper project (http://esper.codehaus.org). Basically the idea is to extend all aggregates (count(), avg() etc) so that they can accept an optional boolean filter expression as a second argument. Example use case: select count(*, color='black'), count(*) as percentBlack from Marbles; This is more expressive and more efficient than using subselects. original suggestion can be found at http://old.nabble.com/Feature-suggestion--filtering-inside-aggregates-to3193... Mitch ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v4.0.0)