[QGIS-trac] [Quantum GIS] #3858: Not possible to define subset of layer using field from joined table

[Quantum GIS]

#3858: Not possible to define subset of layer using field from joined table
------------------------------------------------+---------------------------
   Reporter:  bnotter                           |              Owner:               
       Type:  bug                               |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.7.0
  Component:  Vectors                           |            Version:  Trunk        
   Keywords:  table join, subset                |   Platform_version:  Ubuntu 10.10 
   Platform:  Linux                             |           Must_fix:  No           
Status_info:  0                                 |  
------------------------------------------------+---------------------------
 If a table is dynamically joined to a vector layer (as possible from QGIS
 1.7), it is not possible to define a subset of the layer to be displayed
 (as done in Layer Properties - General) based on a field of the joined
 table.

 If an SQL-Where-Clause is entered that refers to a field of the joined
 table (in this case "MAINCROP", when clicking OK, an error message
 appears:

 "OGR[3] error 1: SQL: Failed to identify field:MAINCROP"

 It would be good if this were made possible, as joining tables dynamically
 makes less sense if for some purposes, the joined datasets still have to
 be permanently saved into a new dataset.

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/3858>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS supporting GDAL/OGR, PostGIS, and GRASS formats, and Web Services