Opened 15 years ago
Closed 15 years ago
#1936 closed enhancement (fixed)
SpatiaLite: support subset string
| Reported by: | mwalker | Owned by: | nobody |
|---|---|---|---|
| Priority: | major: does not work as expected | Milestone: | |
| Component: | Data Provider | Version: | Trunk |
| Keywords: | spatialite subset sql | Cc: | a.furieri@…, pka |
| Must Fix for Release: | No | Platform: | All |
| Platform Version: | Awaiting user input: | no |
Description
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.
Attachments (1)
Change History (4)
by , 15 years ago
| Attachment: | enh1936_qgsspatialiteprovider_subsetString.diff added |
|---|
comment:1 by , 15 years ago
| Cc: | added |
|---|
comment:2 by , 15 years ago
| Cc: | added |
|---|
Note:
See TracTickets
for help on using tickets.
support for subset strings in SpatiaLite layers