There can be more than one point in the array of lat/lon pairs.
So starting by testing with N1QL on the server I have ended up with a query that can find lakes inside a “box”:
select d.*,p.* from data d unnest points p where d.type="Lake" and
p.lat between 55.5 and 55.6 and p.lon between 11.0 and 11.5
… I still need to do some work to calculate distances from the point where the user is and sort the result based on that.
However, I have not been able to “translate” the above query to CB Lite… - I seem not to be able to do unnest in the mobile world. So can anyone help me to create the proper CB Lite syntax to perform the same search?
Ok, I searched a little “wider” and following a couple of articles I ended up finding a way to do it
Beware that there are some syntax errors in this. Use ArrayExpression instead of Expression as you can find out from this excellent article:
The final code looks like this snippet:
var _expType = Expression.Property(TYPE).EqualTo(Expression.String(typeof(Lake).Name))
var _points = ArrayExpression.Variable("points");
var _lat = ArrayExpression.Variable("points.lat");
var _lon = ArrayExpression.Variable("points.lon");
var expGeo = ArrayExpression.Any(_points).In(Expression.Property("points"))
var _condition = _expType.And(expGeo);
using (var query = QueryBuilder.Select(
var result = query?.Execute()?.AllResults();
Obviously, I just need to fit in the real position params in the above example