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 north.n@gmail.com designates
 209.85.212.171 as permitted sender)
Subject: Re: [ASK] How to passing 1st view data to 2nd view??
References: 
 <CAER55cHLZwN+DvkGZFwAr7iEnXZfwUOxVz-+a-y7KtU4x2+Tuw@mail.gmail.com>
 <CABu8_fXP7i7ZDwdYzXdo1gTi+zuud-tPdcZg-CwNWVE4LhauMw@mail.gmail.com>
 <CABvT1DFuVn-sm5CczUeNxmFT+bSi8Xdg6k2BZ=wDmfU6qR7tCA@mail.gmail.com>
From: Nick North <north.n@gmail.com>
Content-Type: multipart/alternative;
	boundary=Apple-Mail-E02A80C6-76C9-447D-BB47-7769339238A3
In-Reply-To: 
 <CABvT1DFuVn-sm5CczUeNxmFT+bSi8Xdg6k2BZ=wDmfU6qR7tCA@mail.gmail.com>
Message-Id: <2B71623A-C9F5-4801-8F81-39D0FC805F49@gmail.com>
Date: Sat, 1 Jun 2013 20:17:58 +0100
To: "user@couchdb.apache.org" <user@couchdb.apache.org>
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (1.0)

--Apple-Mail-E02A80C6-76C9-447D-BB47-7769339238A3
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable

There is a discussion of why transactions are not necessary at http://guide.=
couchdb.org/draft/recipes.html.

Nick

On 1 Jun 2013, at 19:59, Robert Newson <robert.newson@gmail.com> wrote:

> Document updates are atomic.
> On 1 Jun 2013 18:12, "Brad Rhoads" <bdrhoa@gmail.com> wrote:
>=20
>> You dont have atomic transactions in couchdb. So it might not be the righ=
t
>> db for an accounting app.
>> On May 21, 2013 11:53 PM, "polutan" <linspirell@gmail.com> wrote:
>>=20
>>> Hello Folks :)
>>>=20
>>> I learn to make a very simple accounting app using CouchDB as my data
>>> storage.
>>> I need to create balance sheet report, and certainly the report must be
>>> able to show by date periode
>>> (example: from 2013-01-01 unti 2013-0131) . My plan is create two view.
>> And
>>> i will doing query 2 times.
>>> The 1st view will give me data filtered by date range. The 2nd view will=

>>> filter data from 1st view by account number range.
>>> So.. i need to know, how to passing 1st view data to 2nd view?
>>>=20
>>> Ok, what i've done so far is created two view with two different key
>>> arrangement.
>>> My 1st view http://easycaptures.com/fs/uploaded/641/0865962213.png named=

>>> journal_date_acc which is
>>> having date-accountNumber key arrangement. ["2013/05/14", 1000, 1010,
>> 1011]
>>> then My 2nd view
>>> http://easycaptures.com/fs/uploaded/641/2476449270.pngnamed
>>> journal_acc_date which is
>>> having accountNumber-date key arrangement. [1000, 1010, 1011,
>> "2013/05/14"]
>>>=20
>>> And this is my document structure http://pastebin.com/RUrBYMWR .
>>>=20
>>> I've test my views, and i doing test bellow:
>>> this is for my 1st view
>> http://host:5984/myfinance/_design/journal/_view/journal_date_acc?group=3D=
true&startkey=3D[
>>> "2013/05/14"]&endkey=3D["2013/05/16"]
>>> {"rows":[
>> {"key":["2013/05/14",1000,1010,1011],"value":{"debit":0,"credit":60000000=
,"totalItem":2,"accLevel1Desc":"Aset","accLevel2Desc":"Kas","accLevel3Desc":=
"Kas
>>> Kantor Pusat"}},
>> {"key":["2013/05/14",1000,1100,1101],"value":{"debit":50000000,"credit":0=
,"totalItem":1,"accLevel1Desc":"Aset","accLevel2Desc":"Kendaraan","accLevel3=
Desc":"Mobil
>>> Dinas"}},
>> {"key":["2013/05/14",5000,5100,5101],"value":{"debit":10000000,"credit":0=
,"totalItem":1,"accLevel1Desc":"Biaya_dan_Beban","accLevel2Desc":"Gaji","acc=
Level3Desc":"Gaji
>>> Karyawan Bagian Penjualan"}}
>>> ]}
>>>=20
>>>=20
>>> this is test for my 2nd view
>> http://host:5984/myfinance/_design/journal/_view/journal_acc_date?group=3D=
true&startkey=3D[1000,1010,1011
>>> ,
>>> "2013/05/14"]&endkey=3D[1000,1100,1101,"2013/05/16"]
>>> {"rows":[
>> {"key":[1000,1010,1011,"2013/05/14"],"value":{"debit":0,"credit":60000000=
,"totalItem":2,"accLevel1Desc":"Aset","accLevel2Desc":"Kas","accLevel3Desc":=
"Kas
>>> Kantor Pusat"}},
>> {"key":[1000,1100,1101,"2013/05/14"],"value":{"debit":50000000,"credit":0=
,"totalItem":1,"accLevel1Desc":"Aset","accLevel2Desc":"Kendaraan","accLevel3=
Desc":"Mobil
>>> Dinas"}}
>>> ]}
>>>=20
>>> Ok, once again, how to passing 1st view data to 2nd view? I want to
>> filter
>>> data by date range in 1st view,,  then i want to filter it again
>>> by account number range in 2nd view. How to?
>>>=20
>>> Thank You :)
>>=20

--Apple-Mail-E02A80C6-76C9-447D-BB47-7769339238A3--