Dashboard: How to get doc by id that contains newline

I think there is a bug at couchbase dashboard.
For example we added a doc with a \n character in doc id but we can not get this doc by filtering on (I could not tried with n1ql)

How can I filter get by newline char? Is there a bug on dashboard?

In the N1QL WHERE field (to the right of the “Document ID” field) try:

meta().id LIKE 'mykey%'

(with an empty “Document ID” field)


You can also use:

meta().id = 'mykey\n'

if it is simply a trailing newline.

1 Like

select * from my_bucket where meta().id = 'a\nb'

using \n works anywhere in the string in query