Performing a WHERE - IN query in CouchDB
You need to use views keys query parameter to get records with keys in specified set.
function(doc){ emit(doc.table.id, null);}And then
GET /db/_design/ddoc_name/_view/by_table_id?keys=[2,4,56]To retrieve document content in same time just add include_docs=True query parameter to your request.
UPD: Probably, you might be interested to retrieve documents by this reference ids (2,4,56). By default CouchDB views "maps" emitted keys with documents they belongs to. To tweak this behaviour you could use linked documents trick:
function(doc){ emit(doc.table.id, {'_id': doc.table.id});}And now request
GET /db/_design/ddoc_name/_view/by_table_id?keys=[2,4,56]&include_docs=Truewill return rows with id field that points to document that holds 2,4 and 56 keys and doc one that contains referenced document content.
In CouchDB Bulk document APi is used for this:
curl -d '{"keys":["2","4", "56"]}' -X POST http://127.0.0.1:5984/foo/_all_docs?include_docs=true