Dashboard: How to get doc by id that contains newline

Couchbase Server
1

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)
image

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

2

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

meta().id LIKE 'mykey%'

(with an empty “Document ID” field)

HTH.

[edit]
You can also use:

meta().id = 'mykey\n'

if it is simply a trailing newline.
[/edit]

1 Like
3

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

using \n works anywhere in the string in query