Error in n1ql query

SQL++
1

I ran this query

UPDATE default AS response
USE KEYS "Test-Doc"
SET
r.progressBlockersRequirements="test “123"” FOR r in response.responses WHEN r.questionId=“123” END

and I got the error

[
{
“code”: 3000,
“msg”: “syntax error - at 123”,
“query_from_user”: "UPDATE default AS response \nUSE KEYS “Test-Doc” \nSET \nr.progressBlockersRequirements=“test “123"” FOR r in response.responses WHEN r.questionId=“123” END”
}
]

Can we replace "test “123"” with single quotes like this "test ‘123’ " in couchbase itself or is there another way to handle this ?

2

Hi!

Have you tried to escape the double quote using \ " (without a space between them) ?

Example:
select * from test where name = "\"MainEntity\""