Bug report #7989

QGIS Nightly (June 2-3) Filter Vector, sql query

Added by Katie Urey over 9 years ago. Updated over 8 years ago.

Affected QGIS version:master Regression?:No
Operating System:Windows XP Easy fix?:No
Pull Request or Patch supplied:No Resolution:worksforme
Crashes QGIS or corrupts data:No Copied to github as #:16841


The query results from a vector filter seem to toggle between viewing the original data set and then the subset from the first query. I am using this to tweak the positions of labels. (seems awkward..)


Let me try again.

0) build a filtered layer, copy this layer to a new layer. (maybe the problem starts here)

1) build a query layer by selecting some points in dataset, say
"UA-ID" = 'OT-11' OR "UA-ID" = 'OT-14'

2) later alter this query to be:
"UA-ID" = 'OT-11' OR "UA-ID" = 'OT-14' OR "UA-ID" = 'OT-13'

3) test the query
The test returns "the where clause found 2 rows"

4) clear the query

5) test the query
The test returns "the where clause found 3 rows", even though the query box is now empty.

And, now, whilst trying to reproduce this problem I seem to have loaded garbage into the point shape file. It appears that label placement settings are displaying the wrong attribute/field. The file does not seem to be corrupted

AttributesFilterLabel.PNG - screen shot of attribute table (64.5 KB) Katie Urey, 2013-06-03 12:49 PM

Related issues

Duplicates QGIS Application - Feature request #3337: Query Builder's data sampler doesn't use original dataset Closed 2012-06-30


#1 Updated by Antonio Locandro over 8 years ago

Is this still an issue? This ticket refers to an old version

#2 Updated by Giovanni Manghi over 8 years ago

  • Status changed from Open to Feedback

#3 Updated by Giovanni Manghi over 8 years ago

  • Resolution set to worksforme
  • Status changed from Feedback to Closed

closing for lack of feedback.

Also available in: Atom PDF