couchdb view using another view?

Question

I have got questions about views in couchdb At the moment, I have a number of views (e.g. view_A, view_B.... view_Z), for each view they contains same range of keys but with different values. ie:

view_A = {"key":"key_1", "value":10}, {"key":"key_2", "value":100}
view_B = {"key":"key_1", "value":5}, {"key":"key_2", "value":2}
view_C = {"key":"key_1", "value":1}, {"key":"key_2", "value":2}

I am expecting to have a view to represent values in view_A divided by values in view_B =>

view_A_over_B = {"key":"key_1", "value":2}, {"key":"key_2", "value":50}

A view to represent values in view_C times values in view_B =>

view_C_times_B = {"key":"key_1", "value":5}, {"key":"key_2", "value":4}

Would this be possible to have a map/reduce function which is calling the views and do the calculation as mentioned like above?

WiredPrairie · Accepted Answer · 2013-08-06 15:43:30Z

2

Views in CouchDB can only access the current document being processed and cannot access other documents, or data from other views. So, unfortunately, it is not possible using views in CouchDB to build the functionality you want.

As it's not clear how you're building the views, it may be possible to use List functions instead of views to build the results you need. List functions are more capable, but you're then responsible for outputting the results (as HTML, Json, etc.).

answered Aug 6, 2013 at 15:43

WiredPrairie

59.9k18 gold badges120 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Anthony · Accepted Answer · 2013-08-08 10:04:12Z

1

View function run just once during document save.

You can define javascript functions that calculate desired numbers, than include the following in your views:

view_A:

...
emit(doc._id, funcA(doc));
...

view_B:

...
emit(doc._id, funcB(doc));
...

view_C:

...
emit(doc._id, funcC(doc));
...

view_A_over_B:

...
emit(doc._id, funcA(doc)/funcB(doc));
...

view_C_times_B:

...
emit(doc._id, funcC(doc)*funcB(doc));
...

You can use CommonJS Modules to define funcA, funcB and funcC. Or use obsolete macro.

answered Aug 8, 2013 at 10:04

Anthony

12.9k13 gold badges68 silver badges92 bronze badges

Comments

Kxepal · Accepted Answer · 2013-08-08 16:16:40Z

1

There was already mentioned that it's not possible to use view against other views, maximum you may apply some list function to specific view (with cost of full scan processing complexity), but still you may look at third-party tools like Couch-Incarnate for chained views support. Also, Cloudant has support for chained views.

answered Aug 8, 2013 at 16:16

Kxepal

4,6891 gold badge23 silver badges16 bronze badges

Collectives™ on Stack Overflow

couchdb view using another view?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related