how to query CouchDB array

Question

Our CouchDB contains many JSON documents with a nested Array, like this:

{ "_id": "3147cb0e74449e1c28c6ded2b4a3fa45e0d65481bd_RXMARTINEZ@miscemail.com_2017-11-30T13:38:33.955Z",
 "_rev": "3-99aef1458fe1a8f310c83156b9d06a69",
"delivery": {
 "application": "EnvSystem",
 "sender": {
  "id": "[email protected]",
  "type": "user"
 },
 "recipients": [
  {"type": "email",
   "recipient": "\"Artzer, Daniel J\" <[email protected]>",
   "sentTS": "2018-01-30T19:46:31.515Z",
   "id": "45281ab0-05f6-11e8-a86a-61a54dcb42aa"},
  {"type": "email",
   "recipient": "\"Hill, Robert V\" <[email protected]>",
   "sentTS": "2018-01-30T19:46:31.516Z",
   "id": "452841c0-05f6-11e8-a86a-61a54dcb42aa"},
  {"type": "email",
   "recipient": "\"Ledesma, Oscar\" <[email protected]>",
   "sentTS": "2018-01-30T19:46:31.516Z",
   "id": "452841c1-05f6-11e8-a86a-61a54dcb42aa"}

]

I have written a view which returns the entire array: emit(doc.delivery.recipients,1)

what I want is to only return the "sentTS" element within the array. How do I write my View do accomplish this?

Juanjo Rodriguez · Accepted Answer · 2018-01-31 22:38:49Z

1

You can use this map function if you want to emit the startTS as the key array

function (doc) {
  ts = [];
  doc.delivery.recipients.forEach(function(e){ts.push(e.sentTS)});
  emit(ts,1);
}

or this if you want to emit a key for each sentTS

function (doc) {
 doc.delivery.recipients.forEach(function(e){emit(e.sentTS)});
}

answered Jan 31, 2018 at 22:38

Juanjo Rodriguez

2,15111 silver badges21 bronze badges

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

2 Comments

CarCrazyBen Over a year ago

thank you for your response. These both seem to work and give me VERY close to what I am looking for. However, I do not fully understand the code; can you explain how these work?

Juanjo Rodriguez Over a year ago

forEach just iterate over recipients array and apply a function for extracting sentTS attribute of each array element.

Collectives™ on Stack Overflow

how to query CouchDB array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related