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: local policy)
From: Sean Coates <sean@seancoates.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Subject: Need to "subquery" in a view?
Date: Fri, 25 Jun 2010 12:40:28 -0400
Message-Id: <BE44DF37-9077-4843-8F45-5F048AB228C3@seancoates.com>
To: user@couchdb.apache.org
Mime-Version: 1.0 (Apple Message framework v1081)

("subquery" for lack of a better term)
(Apologies if this is a duplicate message. I subscribed in the wrong =
order.)

Hello.

I asked this in #CouchDB, but Jan suggested I also email it here.

I have a problem where I have data in couch, and I want to perform what =
seems like one too many leaps of logic from within a view. Here's some =
sample data:

[
{"_id":1,"_rev":1,"type":"user","following":[2,3]},
{"_id":2,"_rev":1,"type":"user","following":[1]},
{"_id":3,"_rev":1,"type":"user","following":[1]},
{"_id":4,"_rev":1,"type":"asset","ownerid":1},
{"_id":5,"_rev":1,"type":"asset","ownerid":1},
{"_id":6,"_rev":1,"type":"asset","ownerid":2},
{"_id":7,"_rev":1,"type":"asset","ownerid":3},
{"_id":8,"_rev":1,"type":"asset","ownerid":3}
]
I want to query for a given id where type=3Duser, and get all type=3Dasset=
 records owned by that user, or by users that the queried user is =
following. Here are some examples that hopefully help:

_id=3D1; want documents with IDs: [4,5,6,7,8]
_id=3D2; want documents with IDs: [4,5,6]
_id=3D3; want documents with IDs: [4,5,7,8]
I hope that's clear enough. if not, please let me know, and I'll try to =
expand my explanation.

The foundation of the problem seems to be that from within a map, I =
can't fetch secondary type=3Duser documents in order to perform what =
amounts to a join (in SQL-speak).

Any help is appreciated. I'm currently solving this problem on the app =
side, but that's far from ideal (causes a mess with things like limits, =
for example).

S