couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adam Sobotka <vorciger...@gmail.com>
Subject master/detail
Date Thu, 27 May 2010 07:37:22 GMT
Dear docmasters, help a poor sql jockey, please. I have lot of
documents of this type:

{"_id":"001600","_rev":"4465-d94d5e93fe8ec1ca88581243e3602d50","Branch":"001","GoodsGrp":600,"Turnover":"12850.5"}

I am displaying them in some tables and now I got request to group
them by next level of aggregation for "GoodsGrp". I can modify each
document to include "Goods category" from some script, but if I got it
right it is not best practice. Or is it? Is there some alternative
like document with this content?

{"_id":"G10","_rev":"someuglynumber","Cat":"10","GoodsGrp":600}

If so, how do I make a query to get all turnover values with branch
for each category?

Thanks

Adam

Mime
View raw message