Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of rajkumars@gmail.com designates
 209.85.160.56 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;
        b=rrb6PEO7HvIsqikybRcIvmP4QqoevvE3dPxRw/gJKUWcpxeYm81N8ZgXa8g8C2fGXL
         ftxSuBHHDGdKzfsKOIBgbB1n2ujkU9ctiSkTrzXVvpxATBjf9N/aIJzXqvuUdQ3OrPFm
         ppND2amdevLqzDxdCF8MtWWQDezEb8fobwAHc=
MIME-Version: 1.0
Date: Thu, 17 Dec 2009 20:55:05 +0530
Message-ID: <64de5c8b0912170725k1f4c1c77m30b8dec90fdc36f1@mail.gmail.com>
Subject: map from multiple docs
From: Rajkumar S <rajkumars@gmail.com>
To: user@couchdb.apache.org
Content-Type: text/plain; charset=UTF-8

Hello,

I have a db which stores mail logs. Each log entry is stored as a
single document. for example (just the relevant fields):

{
   "_id": "2b93d795d483b1ca352f6596c5497c7f",
   "_rev": "1-1463054967",
   "queueid": "03DBB81E1F",
   "numrecipients": 1,
   "fromemail": "officefile631@yahoo.com",
   "logtype": "message_from"
}

{
   "_id": "5ade1602d52f75a4b35ab6c03aa5d8d9",
   "_rev": "1-2573414463",
   "queueid": "03DBB81E1F",
   "rcptemail": "joe@swinepro.info",
   "logtype": "message_delivery",
}

I want to get the queueid of all mails sent from yahoo.com domain to
swinepro.info domain.

If all entries with same queueid was in the same doc I can write a map
with key like ["yahoo.com","swinepro.info"] so that in my url I just
use startkey as ["yahoo.com","swinepro.info"] to get all mails from
"yahoo.com" to "swinepro.info.

Here my problem is that sender and recipient are in two different
docs, with queueid being the common key. Given this data structure is
there any way I can get the data out in the way I want?

Any help will be very much appreciated.

regards,

raj