Filter deleted collections in Couchbase Views

Question

How can i write condition in Couchbase views to filter deleted collection from result.

function (doc, meta) {
  if(doc.type=='folder'){
    emit(doc.folder_id, doc);
  }
}

Here is my simple view, It gives some deleted folders in json response.

Answer 1

1. Keep in mind that views are only eventually-consistent. They dont return real-time data. It can take a little time for views to actually reflect the data in CB.

2. Specifically, it takes up to a minute for deleted items to get removed from CB view results. This is somewhat configurable.

3. Important : dont emit "doc" in your views - that's wasteful (since it stores another copy of each document in CB).

4. Instead, you can usually request that the document is attached to the result (in python its called "include_doc" - http://pythonhosted.org/couchbase/api/views.html). This can help you with the problem at hand: if you request that documents are included with the view results, then if the document has been deleted, it would simply not return it - telling you that its already been deleted.

   5. Alternatively, if you dont have 'include_doc' in your client, you could do it manually: get the view results (just the list of document ids) and for each document, perform "get" to retrieve the data. if you can't find the doc, its been deleted. (unlike views, 'get' actions are fully consistent - they reflect the data that was written to disc).