How to do Order by using SUBSTR in Couchbase Lite iOS 2.6.3?

[vsr1]

Orderby on more than one property

Hi I have a query like this: static readonly IOrdering orderByDate = Ordering.Property("date").Descending() : QueryBuilder.Select( SelectResult.All()) .From(dbSource) .Where(_condition) .OrderBy(orderByDate) If the date attribute is the same then I want creation order to be next order by criteria - similarly to this N1QL query: select `key`,catchkeys,date,created from data where type = "FishingTrip" and userke…