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