[rules-users] Drools fusion

[Raja Sekhar]

Sorry for the typo. I am looking for something like group by in a sql query
where i can group by hid and sum up the values
Is this something available .

Regards,
Raj


On 11 February 2014 17:03, Wolfgang Laun <wolfgang.laun at gmail.com> wrote:

> See below.
>
> On 11/02/2014, Raja Sekhar <raja.amirapu at gmail.com> wrote:
> > Hi,
> > I have values like this
> >
> > id hid value1 value2 value3 value4
> > 1 1     100     100    100     100
> > 2 1      100    100     100     100
> > 3 2       150   150     150     150
> > 4 2      150    150     150     150
> >
> > the end result should be e
> > all hids with 1's should summed up
> > all hids with 2's should summed up depends on so on
> >
> > i.e
> >  valuessum1 valuesum2 valuesum3 valuesum4
> >   200               200            200          200
> >  200                 200            200          200
>
> A second line with "300 300 300 300" would make more sense.
>
> Expecting a feature to iterate over fields with names differing in a
> suffix ordinal is a bit much. You can use Java's reflection or decide
> on a data model where the valueN fields are stored in a List.
>
> -W
>
> >
> > I did this with accumulate by comparing the hids and using the sum
> function
> >
> > I looking for group by hid and sum l
> >
> > Regards,
> > Raj
> >
> >
> >
> >
> >
> > On 11 February 2014 15:49, Wolfgang Laun <wolfgang.laun at gmail.com>
> wrote:
> >
> >> On 11/02/2014, Raja Sekhar <raja.amirapu at gmail.com> wrote:
> >> > Hi All,
> >> > How can i perform aggregation on group with drools fusion.
> >>
> >> By performing all the necessary steps.
> >>
> >> A more detailed answer might be provided for a more detailed question.
> >>
> >> -W
> >>
> >> >
> >> > Regards,
> >> > Raja Sekhar A
> >> >
> >> > --
> >> > Raja Sekhar Amirapu
> >> > ------------------------------------------------------
> >> > "If any anyone can do it, i can do it. If no one else can do it, i
> must
> >> do
> >> > it"
> >> >
> >> _______________________________________________
> >> rules-users mailing list
> >> rules-users at lists.jboss.org
> >> https://lists.jboss.org/mailman/listinfo/rules-users
> >>
> >
> >
> >
> > --
> > Raja Sekhar Amirapu
> > ------------------------------------------------------
> > "If any anyone can do it, i can do it. If no one else can do it, i must
> do
> > it"
> >
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>



-- 
Raja Sekhar Amirapu
------------------------------------------------------
"If any anyone can do it, i can do it. If no one else can do it, i must do
it"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20140211/578cb696/attachment.html