I have query like below with some named parameters. I am using Couchbase Lite 3.0.2 version, ASP .Net Core 6
This is what I have tried.
SELECT item.Name FROM _ WHERE docType = ‘Test’ AND ANY item IN Pipes SATISFIES item.Name = ‘Test’ END
But this is not working.
Maybe there’s no matching data?
You can try changing the equality predicates to 1=1 so that any data it is returned.
The N1QL Cheat Sheet might be helpful. https://docs.couchbase.com/files/Couchbase-N1QL-CheatSheet.pdf