Timeline for How can I constrain this filtering even more?
Current License: CC BY-SA 3.0
19 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 19, 2017 at 16:52 | history | edited | whyzar |
added tag
|
|
| Dec 6, 2016 at 1:59 | comment | added | Kazuhito | Could it be "place" LIKE '%Mexico%' AND NOT "place" LIKE '%New Mexico%' OR "place" LIKE '%Canada%' ? | |
| Dec 6, 2016 at 1:08 | comment | added | nukenine | @Kazuhito Okay this works, however when I add Canada into the mix by using: "place" LIKE '%Mexico%' OR "place" LIKE '%Canada%' AND NOT "place" LIKE '%New Mexico%', now it includes New Mexico. | |
| Dec 5, 2016 at 11:32 | answer | added | Joseph | timeline score: 3 | |
| Dec 4, 2016 at 19:05 | comment | added | Vince | Please edit the question to specify the values you have in ASCII, so that they're legible on all devices. I recommend adding a "country" column, then encoding it, so yhat indexing is possible. Wildcard and NOT searches are very inefficient and compound search terms are even more so). | |
| Dec 4, 2016 at 16:44 | comment | added | Kazuhito | How about "place" LIKE '%Mexico%' AND NOT "place" LIKE '%New Mexico%' | |
| Dec 4, 2016 at 16:04 | comment | added | Ian Turton | Try %Mexico instead | |
| Dec 4, 2016 at 15:37 | history | edited | nukenine | CC BY-SA 3.0 |
Added Dataset
|
| Dec 4, 2016 at 15:24 | comment | added | nukenine | @Vince Here's the error I got back: Parser Error: syntax error, unexpected COLUMN_REF, expecting $end Eval Error: No root node! Parsing failed? | |
| Dec 4, 2016 at 15:23 | comment | added | nukenine | @Vince Did not work, could it be my QGIS version, 2.16? Also, the "place" column doesn't just contain one word locations like 'Mexico', instead it is like 'Baja California, Mexico' or 'B.C., Canada'. | |
| Dec 4, 2016 at 15:13 | history | edited | Vince | CC BY-SA 3.0 |
removed help/appreciation/thanks
|
| Dec 4, 2016 at 15:11 | comment | added | Vince |
Wildcards are evil -- Only use them when you know you can control the outcome. The proper SQL syntax here is WHERE "place" NOT IN ('Canada', 'Mexico')
|
|
| Dec 4, 2016 at 14:58 | answer | added | whyzar | timeline score: 2 | |
| Dec 4, 2016 at 14:52 | comment | added | nukenine | @whyzar posted it | |
| Dec 4, 2016 at 14:51 | history | edited | nukenine | CC BY-SA 3.0 |
Added Attribute Table
|
| Dec 4, 2016 at 14:43 | comment | added | whyzar | Post a screen shot of your attribute table. | |
| Dec 4, 2016 at 14:42 | history | edited | whyzar | CC BY-SA 3.0 |
improved formatting
|
| Dec 4, 2016 at 14:37 | review | First posts | |||
| Dec 4, 2016 at 14:40 | |||||
| Dec 4, 2016 at 14:35 | history | asked | nukenine | CC BY-SA 3.0 |