Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of patcito@gmail.com designates
 209.85.218.170 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type
         :content-transfer-encoding;
        b=NO6DvQniST2Dx8Boxco5m+nTGnQqkWsbDaDjvftYeTSyyEEBWab1+c1MJPNGgJNOwC
         PwD+tQg7bNa93ArATbNFKsmNJ/pDrKbqVB7M2XKuiGtnWYCPT1yEZFx4IhTe3Li2krQi
         7qipXOqlEFTLfygerhGv9J6Rmy9oBYqr+fmA0=
MIME-Version: 1.0
Date: Thu, 21 May 2009 18:39:46 -0500
Message-ID: <6b6419750905211639u7888a6e6k5e9c166454819377@mail.gmail.com>
Subject: need help for a query
From: Patrick Aljord <patcito@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hey all,

I have a blog with many posts and many comments done by many users, a
comment has a post_id, a user_id and a created_at holding the creation
date of the comment.

I would like to query the 20 latest comments done only by user X, Y
and Z together, that is to say, if user X did the 20 latest comments
then it should return those 20 latest comments done by x only, but if
not, it should return for example something like 10 comments done by
X, 7 comments done by Y and 3 by Z, I hope you get the idea. And I
want them to be ordered by created_at.

I don't think there is a way to do so with one query only. What would
be the best way to do this query with couchdb?

Thanks in advance,

Pat