{"id":3238,"date":"2016-03-06T21:56:31","date_gmt":"2016-03-06T21:56:31","guid":{"rendered":"http:\/\/www.garysieling.com\/blog\/?p=3238"},"modified":"2016-03-06T21:56:31","modified_gmt":"2016-03-06T21:56:31","slug":"rethinkdb-in-list-example","status":"publish","type":"post","link":"https:\/\/www.garysieling.com\/blog\/rethinkdb-in-list-example\/","title":{"rendered":"RethinkDB: IN List example"},"content":{"rendered":"

RethinkDB has an interesting syntax for doing IN lists, where the IN list comes before the column:<\/p>\n

r.db('test')\n .table('users')\n .filter( \n    (doc) => \n      r.expr(['test', 'sieling'])\n       .contains(doc('last_name')\n ) \n)<\/pre>\n\n\n\n\n\n\n\n
<\/td>\n\n
\n
first_name<\/div>\n<\/div>\n<\/td>\n
\n
\n
id<\/div>\n<\/div>\n<\/td>\n
\n
\n
last_name<\/div>\n<\/div>\n<\/td>\n
\n
\n
user_name<\/div>\n<\/div>\n<\/td>\n<\/tr>\n
\n
1<\/div>\n<\/td>\n
\n
\n
gary<\/div>\n<\/div>\n<\/td>\n
\n
\n
903e0943-8ffe-41ca-a22f-7b1a964b399d<\/div>\n<\/div>\n<\/td>\n
\n
\n
sieling<\/div>\n<\/div>\n<\/td>\n
\n
\n
gsieling<\/div>\n<\/div>\n<\/td>\n<\/tr>\n
\n
2<\/div>\n<\/td>\n
\n
\n
gary<\/div>\n<\/div>\n<\/td>\n
\n
\n
479e9ce1-e0bb-46b3-a65f-554ac237460a<\/div>\n<\/div>\n<\/td>\n
\n
\n
sieling<\/div>\n<\/div>\n<\/td>\n
\n
\n
gsieling<\/div>\n<\/div>\n<\/td>\n<\/tr>\n
\n
3<\/div>\n<\/td>\n
\n
\n
test<\/div>\n<\/div>\n<\/td>\n
\n
\n
1b223750-799d-402a-b378-74c993a9c10c<\/div>\n<\/div>\n<\/td>\n
\n
\n
test<\/div>\n<\/div>\n<\/td>\n
\n
\n
test<\/div>\n<\/div>\n<\/td>\n<\/tr>\n
\n
4<\/div>\n<\/td>\n
\n
\n
gary<\/div>\n<\/div>\n<\/td>\n
\n
\n
947a3ce6-d419-4d31-bd1e-874c721a9e6c<\/div>\n<\/div>\n<\/td>\n
\n
\n
sieling<\/div>\n<\/div>\n<\/td>\n
\n
\n
gsieling<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
One nice thing about this is that there doesn’t seem to be a length limit – in Oracle, IN lists are arbitrarily capped at 1,000 entries. <\/p>\n
In testing this, I did find that at some point the RethinkDB UI gets harder to use and may crash the browser. But it seems to retain it’s memory of what you had in your query, so it recovers much more easily than older tools<\/p>\n","protected":false},"excerpt":{"rendered":"
RethinkDB has an interesting syntax for doing IN lists, where the IN list comes before the column: r.db(‘test’) .table(‘users’) .filter( (doc) => r.expr([‘test’, ‘sieling’]) .contains(doc(‘last_name’) ) ) first_name id last_name user_name 1 gary 903e0943-8ffe-41ca-a22f-7b1a964b399d sieling gsieling 2 gary 479e9ce1-e0bb-46b3-a65f-554ac237460a sieling gsieling 3 test 1b223750-799d-402a-b378-74c993a9c10c test test 4 gary 947a3ce6-d419-4d31-bd1e-874c721a9e6c sieling gsieling One nice thing about … <\/p>\n
Continue reading “RethinkDB: IN List example”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[4],"tags":[160,462,466,523],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t