Hi QGISers,

I struggled and failed to find a way to use QGIS expressions functions in
order to select features based on sorting on different fields. I played
with aggregates, arrays, maps but couldn't find how to control sort order
(and imbricate it). I finally generated virtual layers to do the work but
would really love to select and not extract.
The need in SQL is something like:

select somefields, afield, st_length(geometry) as longueur, geometry
from mylayer
where longueur < 10*order by afield desc, longueur asc*
limit 5

Any help would be more than welcome.
Thanks in advance

Kind regards,
Harrissou
_______________________________________________
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Reply via email to