Couchdb Join Two Documents Using Key

I have two documents one with tree structure and the other one relation to the first doc. Im trying to join these two doc`s by fk and pk. I couldnt get the actual results and it di

Solution 1:

To simulate joins you have to output a doc with an _id in it, the value of the _id needs to point to an actual _id of a document. Then you can make use of include_docs=true to pull in the related documents. Example with many-to-many here: http://danielwertheim.se/couchdb-many-to-many-relations/

If this is not applicable, you can make a two step manual join by first returning custom keys. Then make a second query against the all documents view, with multiple keys specified.

Solution 2:

It is much late but For such kind of tree structure, documents should be kept separately such as

{
  id="firstDoc",
  type="rootLevel"
}
{
  id="secondDoc",
  type="firstLevel"
  parent="firstDoc"
}
{
  id="thirdDoc",
  type="firstLevel",
  parent="firstDoc"
}

Now different levels can be joined using the Map Reduce function, Make sure that you will use it in proper way, Also use Logging so that you will be able to know in which sequence map/reduce function are being called by CouchDB.

Further, map Function should only be used for emitting the required document suppose if you want to to emit your level3 then in emit's value part, root.level1.level2.level3 should be there.

For more detail about the join you can refer

CouchDB Join using Views (map/reduce)