[QGIS-trac] [Quantum GIS] #1936: SpatiaLite: support subset string

[Quantum GIS]

#1936: SpatiaLite: support subset string
------------------------------------------------+---------------------------
   Reporter:  mwalker                           |              Owner:  nobody
       Type:  enhancement                       |             Status:  new   
   Priority:  major: does not work as expected  |          Milestone:        
  Component:  Data Provider                     |            Version:  HEAD  
   Keywords:  spatialite subset sql             |   Platform_version:        
   Platform:  All                               |           Must_fix:  No    
Status_info:  0                                 |  
------------------------------------------------+---------------------------
 This patch adds support for subset strings (SQL where clause) in
 SpatiaLite layers to limit the dataset.

 e.g. {{{setSubsetString("a > 2 AND b = 0")}}}

 As the QueryBuilder only works for PostgreSQL at the moment, the subset
 filter on a SpatiaLite layer can be set using a plugin
 ({{{layer.setSubsetString("...")}}}) or by appending {{{sql=...}}} to
 {{{<datasource>}}} in the project file.

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