[QGIS-trac] Re: [Quantum GIS] #3030: Query Builder in Properties produces "Query Failed"

[Quantum GIS]

#3030: Query Builder in Properties produces "Query Failed"
-----------------------------------------------------+----------------------
        Reporter:  alobo                             |         Owner:  jef          
            Type:  bug                               |        Status:  closed       
        Priority:  major: does not work as expected  |     Milestone:  Version 1.6.0
       Component:  Vectors                           |       Version:  1.6.0        
      Resolution:  fixed                             |      Keywords:               
Platform_version:  ubuntu 9.10                       |      Platform:  All          
        Must_fix:  Yes                               |   Status_info:  0            
-----------------------------------------------------+----------------------
Changes (by qgisviti):

  * status:  reopened => closed
  * resolution:  => fixed


Comment:

 Replying to [comment:11 qgisviti]:
 > Replying to [comment:10 alobo]:
 > > Confirmed: renaming coords.x1 and coords.x2 to coordsx1 and coordsx2
 solves the problem.
 > > Has the problem been reported to OGR developers?
 > > Shouldn't QGIS have a warning for attributes names including "."
 meanwhile?
 > >
 > > Agus
 >
 > I still have problem with query builder in properties even if the name
 of columns doesn't have any dots. My field name is "NDVI" and when I use
 Qgis, I double click in the appropriate Fields, Operator and Value entries
 in qgis and it's written "NDVI">=0.06: the error "The subset string could
 not be set" is returned.
 >
 > It works well from Attribute Table/Advanced? Search
 >
 > So the problem may be more than dots in name of fields...

 Ok...I'm sorry. I just understand that it must be no field with dot in the
 shapefile for query works. So Jef was rigth, "Looks like the attributes
 with dots in the name are the actual problem for OGR". Just be careful to
 change all names of shp and not just the name of the field you do query
 on.

-- 
Ticket URL: <http://trac.osgeo.org/qgis/ticket/3030#comment:12>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats