I'm trying to sort a shapefile by one of its attributes using "Execute SQL", in the QGIS Graphical Modeler.
Using a vector as input is working fine, but when I use a layer generated by an algorithm I have this error message : "virtual: Cannot find layer OUTPUT_shp20180419141642572".
Can someone help me with this ?
To sum-up : here is my problem
-
1As per the help center it is OK to try and reproduce software problems in a Q&A here, but if you think this is a bug then be sure to submit it to the QGIS development team. Please post a link to the bug report here.underdark– underdark2018年04月19日 20:28:21 +00:00Commented Apr 19, 2018 at 20:28
-
1@underdark here is the ticket: issues.qgis.org/issues/16129#change-95647 It is set as fixed, but the problem still exist in QGIS 3.4.1 and the nightly build versionPieterB– PieterB2018年11月26日 13:16:02 +00:00Commented Nov 26, 2018 at 13:16
-
1What if you change "input1" in your SQL to the id of the Mean algorithm? So I mean, maybe you should not use the same SQL codes.pnz1337– pnz13372018年12月02日 23:13:06 +00:00Commented Dec 2, 2018 at 23:13
-
@pnz it's a bug in the algorithm. See the ticket mensioned abovePieterB– PieterB2018年12月05日 14:33:05 +00:00Commented Dec 5, 2018 at 14:33
1 Answer 1
This is a known issue: Bug report #16129 Processing : execute sql alg does not work with input2 ... inputN parameters
-
Is there a substitute tool that works in Graphical modeller?Selma– Selma2023年09月28日 06:45:12 +00:00Commented Sep 28, 2023 at 6:45