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 andoriyu@gmail.com designates
 209.85.213.180 as permitted sender)
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1249)
Subject: Make a three
From: Andrey Cherkashin <andoriyu@gmail.com>
In-Reply-To: <FA69F5BA-4C83-4220-B40B-39FBEF442373@couchbase.com>
Date: Wed, 28 Sep 2011 12:05:30 -0700
Content-Transfer-Encoding: quoted-printable
Message-Id: <0A28DA04-6A54-4279-B8FC-D945EEC5268E@gmail.com>
References: 
 <CALOE=zuEVKLHMwGEMJb65=ncgSKDnMBm6gxsYZ2uv43amN0ppg@mail.gmail.com>
 <FA69F5BA-4C83-4220-B40B-39FBEF442373@couchbase.com>
To: user@couchdb.apache.org

I have a bunch of documents, and I would like to build a three based on =
data from them. For example I have objects like this:
[{=20
name: "1",
category: "Paint",
sub_category: "Inside",
brand: "ACME"
},
{=20
name: "2",
category: "Paint",
sub_category: "Inside",
brand: "ACME"
},
{=20
name: "asd",
category: "Tools",
sub_category: "Hammer",
brand: "ACME"
},
{=20
name: "asd",
category: "Tools",
sub_category: "Hammer",
brand: "UY"
},
{=20
name: "asd",
category: "Paint",
sub_category: "Outside",
brand: "UY"
}]

And I would like to build a three like this:=20

[ {category: "Paint",
subs: ["Inside", "Outside"],
brands: ["ACME", "UY"]=20
},
{
category: "Tools",
subs:["Hammer"],
brands: ["ACME", "UY"]
}]

Is it possible to build in inside couch? Or Move it to middleware?=