Using SUBSTR() function

Mobile
,
1

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

2

No, Couchbase Lite does not support this function. You can see what is supported here

3

@borrrden Thank you so much for the update.