Blank canvas after applying filter/query builder

[qgib]

Author Name: David Pierce (David Pierce)
Original Redmine Issue: 20074
Affected QGIS version: 3.3(master)
Redmine category:vectors

---

I imported a lines vector layer from OSM. I then used query builder to apply a filter, e.g. "highway" = 'primary'. After pressing 'Test', the Query Result said it found 227 rows. Going back to the layer, all features had disappeared - nothing showing at all for that layer, other layers were unchanged. I tried this same approach using different filed and filters and it had the same result. I tried this same approach on the OSM polygon vector layer and it also did the same thing - everything in that layer disappears when the filter is turned on, even though the query result is saying that it found x rows.

---

• Untitled.png (Ivan Ivanov)
• applying filter and blank canvas.gif (Saber Razmjooei)

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

Try with 3.3 - there's been some related fixes.

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Ivan Ivanov (@suricactus)

---

I can confirm it happens on the current latest Debian and Windows version with .osm files, 3.2.3. I found a workaround if you import it into geopackage, it works fine. I haven't tested if you use shapefile etc.

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

You need to test on 3.3, not 3.2

[qgib]

Author Name: Ivan Ivanov (@suricactus)

---

I just confirmed the problem exists on 3.2.3 with the previous note.
I installed the weekly x64 build (9ccb1b5) and can confirm the issue still exists. Steps to reproduce:

1. get any .osm file and import a layer from it
2. apply any filter e.g. 1 = 1
3. press Test button, it shows an alert box with features count. However, the features from the .osm layer disappear from the map. The same happens if you press OK.

I think there is a related issue, if you clear the filter expression and press the Test button, you see a message with an untouched placeholder:

The where clause returned %n row(s).

Both issues are on .osm layers only. Check the attachment for more info of the latter issue.

---

• 13494 was configured as Untitled.png

---

• Untitled.png (Ivan Ivanov)

[qgib]

Author Name: Saber Razmjooei (@saberraz)

---

Hmmm...it appears to be working in 3.3 but as soon as I move the map, all features disappear.

---

• status_id was changed from Feedback to Closed

[qgib]

Author Name: Saber Razmjooei (@saberraz)

---

• status_id was changed from Closed to Open

[qgib]

Author Name: Saber Razmjooei (@saberraz)

---

The problem is even worse. The whole canvas goes blank for me.

---

• version was changed from 3.2.3 to 3.3(master)
• operating_system was changed from Windows 10 to
• subject was changed from All features on a layer disappear after applying filter/query builder to Blank canvas after applying filter/query builder
• 13495 was configured as applying filter and blank canvas.gif

---

• applying filter and blank canvas.gif (Saber Razmjooei)

[qgib]

Author Name: Saber Razmjooei (@saberraz)

---

• priority_id was changed from Normal to High

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Saber Razmjooei wrote:

The problem is even worse. The whole canvas goes blank for me.

here is not even necessary to apply a filter, just zoom in enough... and all goes blank. Zoom out and features will not be back.

[qgib]

Author Name: Martin Dobias (@wonder-sk)

---

Can you check again with the most recent master? The fix from Even for OSM file two days ago may have fixed it (#27920)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Ivan Ivanov (@suricactus)

---

I can confirm the problem is fixed in QGIS 3.4.1 on Ubuntu 18.10.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• status_id was changed from Feedback to Closed
• resolution was changed from to fixed/implemented