Query CouchDB with multiple keys for multiple properties

Question

I'm using couch db to store subscription documents. While performing queries, I want to be able to query on multiple properties and also use an "IN" clause. For example, I have a subscriptionStatus property which can have multiple values (Active, Failed, In_Progress etc.) and subscriptions also have a customerID.

How can I create a query for all subscriptions where customerID = "JD212S" AND subscriptionStatus IN ["Active", "In_Progress"]

Essentially show me active and in progress subscriptions for a particular customer. I looked at combinations of views, multiple keys etc but I was not able to do this (or I've misunderstood the docs).

I've had a look at a number of Stack Overflow Q/A and CouchDB docs for this but seem to find options only for a single property at a time.

possible duplicate of Performing a WHERE - IN query in CouchDB — Chris Snow
– Chris Snow, Commented Feb 4, 2015 at 12:52

twilson63 · Accepted Answer · 2015-02-04 13:06:11Z

5

it does look list a duplicate, but in your context you would create a view return multiple keys then when executing that view, like the link here states, pass in your multi-key options

// view foo/bar
var view = function(doc) {
   doc.emit([doc.customerId, doc.subscriptionStatus]);
}

db.view('foo/bar', { keys: [['JD212S','Active'], 
['JD212S','In_Progress']], include_docs: true });

answered Feb 4, 2015 at 13:06

twilson63

4413 silver badges5 bronze badges

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

1 Comment

Arun Ramakrishnan Over a year ago

Ah thanks! I will try this. My confusion was I didn't realize I could specify the keys like so and was working out how to put them all in a single array. So essentially, each entry in the keys array is a complex key (JSON Array) in itself. Got it! It does mean though, for e.g. if I had many with many values, I'd be creating all combinations of complex key :) Anyways, thanks a lot for the answer, this is what I was looking for.

Collectives™ on Stack Overflow

Query CouchDB with multiple keys for multiple properties

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related