Bug report #9071
Filter queries ignore ""
|Affected QGIS version:||2.0.1||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||wontfix|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||17717|
When you define a filter and add a field it's inserted with encapsulated as "fieldname". This causes the user to think that "" is the marker for strings. But if you query like "fieldname"="value", you just get a useless stringname error warning in the logs. You need then to find out, that instead the query has to be formed like "fiedname"='value' that is inconsistent.
So please also support "" or make it easier for the user to understand how to form a valid query.
#5 Updated by Jürgen Fischer over 6 years ago
noone noone wrote:
If you do that please explain people what you expect them todo. Maybe ad"ing an grayed out explame as default for the syntax box, that disappears if the user sets the focus to the edit box.
'' quotes string values and "" quotes identifiers (ie. fieldname; optionally - fieldnames w/o whitespaces and other special characters in them don't require quoting).