Couchbase N1QL - inline Regex captured group replace?

Question

UPDATE SOME_BUCKET as doc USE KEYS ["USER_ACCESS::123456::SOME_ROLE", "MORE KEYS HERE...", etc]
loc.id = REGEXP_REPLACE(loc.id, "(.*) - (.*)", "$1-$2") FOR loc IN locations END
RETURNING doc

Setting the "loc.id" here just assigns it the string literal replacement value, "$1-$2" instead of the back references to the captured groups.

Couchbase Server runs GoLang regex syntax, which apparently might not support back references? What alternative is there?

user_6080536 · Answer

Update required SET, UNSET clause https://docs.couchbase.com/server/current/n1ql/n1ql-language-reference/update.html#update-for Check Example 3

UPDATE SOME_BUCKET as doc 
USE KEYS ["USER_ACCESS::123456::SOME_ROLE", "MORE KEYS HERE...", etc]
SET loc.id = REGEXP_REPLACE(loc.id, "(.*) - (.*)", "$1-$2") FOR loc IN locations END
RETURNING doc;

Couchbase N1QL - inline Regex captured group replace?

1 Answers