Mailing-List: contact couchdb-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: couchdb-user@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of jchris@gmail.com designates
 74.125.46.154 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:sender:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references:x-google-sender-auth;
        b=Kwx98S5bsu+oJNMdi/1oQnUVc0gbaEhw3HSBnDN1+tqBY8+xxAlb8QDjFy6bsH4L/s
         x7uNCeb1Qbc2cm11wPr/WOk6csKRy8PUCPJDCyJ3pmNkLJ26c3X3ao8LjOueUj8vv0p0
         09nHBdEU5NRP6HAKQvFVzf2TsdDhDe97Wykrw=
Message-ID: <e282921e0811241422r1c9a41a8ycca337a414363cfb@mail.gmail.com>
Date: Mon, 24 Nov 2008 14:22:31 -0800
From: "Chris Anderson" <jchris@apache.org>
Sender: jchris@gmail.com
To: couchdb-user@incubator.apache.org
Subject: Re: threaded email view
In-Reply-To: <492A505E.5050104@silencegreys.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <492A505E.5050104@silencegreys.com>

On Sun, Nov 23, 2008 at 10:57 PM, Jedediah Smith
<jedediah@silencegreys.com> wrote:
> I'm using CouchDB to store and process emails.
>
> Every email has a "message-id" header field containing a globally unique
> identifier and zero or more "references" and "in-reply-to" fields, each of
> which contains the message-id of a different message.

You might have the easiest time providing this view if you can have an
original-message-for-thread-id that is attached to all messages that
are replies or references to another message.

That way you can pull out an entire thread by finding all messages
that reference the thread-originating message in the parent field(s).

The method you describe (where each message links only to its
immediate parent) leaves you no common identifier for an entire
thread. By linking to the first message in a thread, from all
subsequent replies, you'll have an easy way to pull all replies
together in one view.

I hope this helps.

Chris


-- 
Chris Anderson
http://jchris.mfdz.com