Groupby - how does this works?

From: "Rick" <r_chav@xxxxxxxxx>
Date: 4 Dec 2006 12:57:56 -0800

Hi,

I've seen that the CALM schema provdes a <groupby> aggregation
function. I've been trying to build a CAML query to ger items from a
list using the groupby. The final intention is to agregate by a
categroy field and then show a SUM of another field, like in SQL:

SELECT category, SUM(column1)
FROM listname
GROUP BY category

Has anyone used the groupby element in CAML?

Many thanks.

.

Next by Date: Form Authentication problem in Sharepoint site
Next by thread: Form Authentication problem in Sharepoint site
Index(es):
- Date
- Thread

Relevant Pages

Re: in a SPQuery lookup
... So far I was able to build a CAML query to filter and sort elements. ... I've seen that the CALM schema provdes a <groupby> aggregation ... categroy field and then show a SUM of another field, ...
(microsoft.public.sharepoint.portalserver.development)
in a SPQuery lookup
... So far I was able to build a CAML query to filter and sort elements. ... I've seen that the CALM schema provdes a <groupby> aggregation ... categroy field and then show a SUM of another field, ...
(microsoft.public.sharepoint.portalserver.development)