1

I have issue with key and keys filter parameter in Couchbase (Version: 3.0.0 Enterprise Edition) in the web console. Whatever value I set in those parameters, no record is returned.

Documents look like:

{
   "folder": "F3",
   "ccy": "USD",
   "pnl": 789700,
   "maturity": "4424-10-16 00:00 AM CEST",
   "source": "BackOffice1",
   "npv": 341684,
   "symbolic_id": 880888,
   "bpv": 374000,
   "cpty": "CPTY2"
}

Map function is:

function (doc, meta) {

 emit([doc.source,doc.cpty], doc.npv); 

}

Reduce is the built in function

_count

I assume that I should be able to get all documents with the key ["BackOffice1","CPTY2"] by setting the key parameter in the querystring ?key=["BackOffice1","CPTY2"]&reduce=true&group=true. But nothing is returned.

I may miss something in how we should use key and keys parameters.

For information, startkey and endkey work as expected.

Is there something wrong with my approach ?

Community
  • 1
  • 1
Hieroglyphe
  • 53
  • 7

2 Answers2

0

You have to add 

keys=["BackOffice1","CPTY2"]

as parameter .

Arun M R Nair
  • 653
  • 7
  • 30
  • It does not work. If I set both group_level and group parameter, the application complains that they are not comptible. If I set only group level, the application complains that group is mandatory for reduce view. (message: Multi-key fetchs for reduce view must include 'group=true') – Hieroglyphe Nov 03 '14 at 10:51
0

I figured out what was the issue with the key parameter. In the Couchbase version 3.0.0, we need to add inclusive_end=true parameter to get results.

Looking at Couchbase bugs, it looks like it was not required in previous versions and that it will be reverted back in next version, refer to https://www.couchbase.com/issues/browse/MB-12378.

After reviewing samples in Couchbase documentation, my usage of keys parameter was not correct. To query view with array as a key, keys parameter should be formatted as follow: keys=[["value1",value2"],["value3",value2"]].

If I apply this to the example I provided in my question, the query will look like: ?keys=[["BackOffice1","CPTY2"]] or key=["BackOffice1","CPTY2"]

Thanks

Hieroglyphe
  • 53
  • 7