| Author |
Message
|
| YESRK |
 Posted: Fri Apr 11, 2008 8:40 am Post subject: "GROUP BY" functionality in Esql. |
 |
|
Newbie
Joined: 11 Apr 2008
Posts: 2
|
hello,
Kindly excuse if the question is trivial,
we have a functionality that can be easliy acheived using the "group by" clause of SQL in a select stmt.
do we have similar function in ESQL.
Details:
The incoming XML has multiple occurance of a particular group of elements say state,city,dealer,quantity the requirement is to group the elements that have same state,city and dealer to 1 element in output and sum all the qty.
For Ex
Input
st1 ct1 d1 10
st2 ct2 d2 15
st1 ct3 d3 20
st1 ct1 d1 25
Output should be,
st1 ct1 d1 35
st2 ct2 d2 15
st1 ct3 d3 20 |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Apr 11, 2008 8:41 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
No, there is no GROUP BY or ORDER BY on ESQL select.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| AkankshA |
| Posted: Mon Apr 14, 2008 8:14 pm Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
  passthru
 
_________________
Cheers |
|
| Back to top |
|
|
| YESRK |
| Posted: Mon Apr 14, 2008 9:12 pm Post subject: |
|
|
Newbie
Joined: 11 Apr 2008
Posts: 2
|
I was referring to processing of incoming XML( from a Q as input to the flow) in the post not the data in database. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Mon Apr 14, 2008 11:12 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi YESRK,
Can you please paste your sample input xml structure....and output too preferably.
You might be able to use the SELECT on the message tree, else use a reference too....but we need to look at your XML for that.
Regards. |
|
| Back to top |
|
|
| AkankshA |
| Posted: Tue Apr 15, 2008 12:29 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
| YESRK wrote: |
I was referring to processing of incoming XML( from a Q as input to the flow) in the post not the data in database. |
oops... my mistake...
guess my weekend hangover is still there..
_________________
Cheers |
|
| Back to top |
|
|
|
|
