Arthur Bogaart wrote:
Hi Dennis,
AFAIK this is not possible in a DASL query.
You can try to mimic this behaviour by doing a dasl without a limit (or
a big limit) and then filtering the unique values with an xsl, or first
doing a dasl on the last 5 news-articles and with the returned UIDs
construct 5 dasls that search for the last corresponding comments on
these news articles.
Keep in mind that:
- there is a hard limit of 1000 results in the repository
- sorting large datasets with xsl can be really slow and cpu intensive
So maybe you want to tackle this from another angle. For example set a
extra property on the article with the date when the last comment was
added. That way you can get the five new articles that where last
commented with one query.
Regards,
Bart
regards,
Arthur Bogaart
[EMAIL PROTECTED] - www.onehippo.com
-------------------------------------------------------------
Amsterdam - Hippo B.V. Oosteinde 11 1017 WT Amsterdam +31(0)20-5224466
San Francisco - Hippo USA Inc. 101 H Street, suite Q Petaluma CA
94952-3329 +1 (707) 773-4646
-------------------------------------------------------------
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dennis de Boer
Sent: dinsdag 22 april 2008 13:33
To: [email protected]
Subject: [HippoCMS-dev] distinct searches
Hello everyone,
Another question I have regards 'distinct' searching using
DASL queries.
I have two datatypes, lets call them a news article and a comment.
The comment datatype has a reference (the UID) to the news article.
What I try to get from my DASL query is the following:
Get the 5 latest comments, but with a distinct article UID
reference. If I get the latest 5 comments, it could happen
that they all reference the same article, so I want a
distinct/ unique article reference.
Is this possible using a DASL query?
Thanks in advance.
Dennis de Boer
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
--
Hippo
Oosteinde 11
1017WT Amsterdam
The Netherlands
Tel +31 (0)20 5224466
-------------------------------------------------------------
[EMAIL PROTECTED] / http://www.hippo.nl
-------------------------------------------------------------
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
