Couchdb/Cloudant view for document property with array

Question

I have three docs in CouchDB/Cloudant as follows:

all_docs :[{
    _id: "content1"
    files: ["fileA", "fileB", "fileC"]
}, {
    _id: "content2"
    files: ["fileD", "fileE", "fileC"]
}, {
    _id: "content3"
    files: ["fileF", "fileG", "fileH"]
}

I need to get content1 and content2 as result for FileC where I can pass FileC as key.

Is there a way to write a view that returns doc ids (content1 and content2) where the file is FileC?

Jonathan Hall · Accepted Answer · 2018-05-12 09:01:25Z

4

This just requires a standard, straight-forward view.

As documented:

Note that emit() may be called many times for a single document, so the same document may be available by several different keys.

So you just need to call emit() for each file in the document. Something like this:

function (doc) {
  for (i = 0; i < doc.files.length; i++) {
    emit(doc.files[0])
  }
}

answered May 12, 2018 at 9:01

Jonathan Hall

80.5k19 gold badges162 silver badges206 bronze badges

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

1 Comment

keeterDev Over a year ago

Thank you @Flimzy!

Collectives™ on Stack Overflow

Couchdb/Cloudant view for document property with array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related