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 jjfutbol@gmail.com designates
 209.85.213.180 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:from:date:message-id:subject:to:content-type;
        b=C5FBOTUiW0COGCYdiQ5Y1wbwTWU/PkjckB+QUVI38DkUoZRXfaqebkJcQy8y18SIAc
         m4hIDVvUfO6Y3otXkutKfN3ttMx79Ltamy7AcOmIqhNG6nefcZx5hKn0SpbyFgIYOtXP
         EStZJvE5azj5PbGO27WGIiR0yKgOOCZRAhIVg=
MIME-Version: 1.0
From: Javier Julio <jjfutbol@gmail.com>
Date: Tue, 8 Feb 2011 18:34:38 -0500
Message-ID: <AANLkTikQqiHHXX8daW1xJyUpZLeAkKq1k3eTMd1xmAth@mail.gmail.com>
Subject: Query a view with id list but for one key
To: user@couchdb.apache.org
Content-Type: multipart/alternative; boundary=00163630f2b7e5203a049bcdcb11

--00163630f2b7e5203a049bcdcb11
Content-Type: text/plain; charset=ISO-8859-1

Hey all,

I've been reading on and using CouchDB since December last year. It's been
great and I've gotten my head around it quite well but on some harder tasks
I'm struggling a little. Let me talk about what I'm currently doing.

I'm using CouchDB for a social app where users can save places. The same
place can be stored in the db multiple times since its tied to a user. Each
place has a unique id. Since this is a social app, say if User A has various
friends and they have saved the same place, I'd like have a view where I can
get a list of those friends. Think like in Facebook when you have a comment
or status update and a bunch of people "like" it, you'd see something like
"You and 5 others like this". When you click on that link you'll get a list
of those people's names.

I can easily create a view that has a map function that just emits the
document id, place id, and user id. The problem I have figuring out is if I
have an id list of User A's friends how can I pass that into the view? From
what I know this doesn't seem like how it works. I'm most likely approaching
this wrong and thinking to much about how I would do this with SQL
(basically using a WHERE IN statement).

Any suggestions? While I just could have the view return all places saved by
anyone else but that seems excessive because there is definitely the
potential that many people have that place saved that aren't even that
users' friend.

Ciao!
Javi

-- 
Javier Julio
Senior Software Developer, 9mmedia
www.javier-julio.com

--00163630f2b7e5203a049bcdcb11--