Move object values from objec to array in RethinkDB

Question

I cannot figure out how to convert objects into a JsonArray.

r.db('data').table('user').filter({'_deleted':false}).pluck(['id'])

My result looks like this:

{
   "id":  "10008590"
}, 
{
   "id":  "10006821"
}

And i want it to look like this:

[ "10008590", "10006821"]

what do i add to a query after .pluck()?

taygetos · Accepted Answer · 2019-01-05 13:26:53Z

1

Simple, after the pluck() you use the map() function to extract the id field:

.map(function(doc){return doc('id')})

in shorter form:

.map(r.row('id'))

Note: in the UI i also needed .coerceTo("array") to the end

answered Jan 5, 2019 at 13:26

taygetos

3,0502 gold badges23 silver badges30 bronze badges

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

2 Comments

Ben Over a year ago

I am having trouble finding examples / documentation online. Do you happen to know where using map in this context is documented? None of the rethinkdb official docs show how things are outputted in their examples.

taygetos Over a year ago

True, the official docu doesnt mention this exact use case and do not bother providing sample outputs. But rethinkdb provides the web UI which makes the experiencing pretty quick and easy, i usually do that. Your use case can be achieved with map, concatMap, and do, you can find some examples and ideas there in the official documentation.

Collectives™ on Stack Overflow

Move object values from objec to array in RethinkDB

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