In QGIS, most likely from the SELECT FEATURES BY VALUE...(F3) or SELECT FEATURES BY EXPRESSION...(CTRL-F3), what is the simplest most flexible way to put in multiple values and have QGIS show that selection on the canvas?
I have list of comma separated values which are the values of features I want to select from a spatial dataset.
1, 2, 3, 4, 5. Because it might be a series of 50 values, I want to quickly paste that into an expression, without adding single quotes or the like.
I'm thinking array_to_string is part of the story, but not seeing any example of how that goes together. Unnest doesn't seem to be a supported function. My test below.
Or possibly in the DBManager as SQL, however I think my colleagues will not adopt that as readily.