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?
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)
HTH.
[edit]
You can also use:
meta().id = 'mykey\n'
if it is simply a trailing newline.
[/edit]
select * from my_bucket where meta().id = 'a\nb'
using \n works anywhere in the string in query
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.