I am using ASP .Net Core 6 and Couchbase Mobile Lite 3.0.2
I have a query like below using SUBSTR and whenrunning I am getting the error like “N1QL syntax error near character 14.'” Does Couchbase Lite supports SUBSTR ?
var q = “SELECT SUBSTR(TallyNumber, 0, 2) as Tally FROM MakeUpJobLocalCouchbaseLite WHERE docType=‘Tally’”;
var query = db.CreateQuery(q);
query.Execute().AllResults()