There are a couple ways to mimic the SQL “CASE WHEN” in RethinkDB.<\/p>\n
If the rows don’t have values in some columns, in SQL you’d default these with “CASE WHEN attr IS NULL … ELSE END”. To fix these, you can use map \/ merge: <\/p>\n
\nr.db('test').table('users')\n .map(\n (doc) => { return r.expr(\n {\n first_name: '',\n last_name: ''\n }\n ).merge(doc) }\n )\n<\/pre>\nIf you want to key off different values, you can use the ‘branch’ function, like so:<\/p>\n
\nr.db('test')\n .table('users')\n .map( \n (doc) => {\n return {\n first_name: \n r.branch(\n doc('first_name').eq('test'), \n 1, \n 2) \n }\n }\n )\n<\/pre>\n","protected":false},"excerpt":{"rendered":"There are a couple ways to mimic the SQL “CASE WHEN” in RethinkDB. If the rows don’t have values in some columns, in SQL you’d default these with “CASE WHEN attr IS NULL … ELSE END”. To fix these, you can use map \/ merge: r.db(‘test’).table(‘users’) .map( (doc) => { return r.expr( { first_name: ”, … <\/p>\n