"Zoom to feature" does not work

[qgib]

Author Name: Lars Kellogg-Stedman (@larsks)
Original Redmine Issue: 19930
Affected QGIS version: 3.2.3
Redmine category:attribute_table
Assignee: Alessandro Pasotti

---

The "Zoom to Feature" action in the attribute table is not working as I would expect. If I:

• Create a SQL layer from a spatialite data source
• Select "Open attribute table..." for this layer
• Create a field filter
• Search for a particular value
• Right click on the result row and select "Zoom to feature"

...then QGIS reports "Zoom to feature id failed: Feature not found".

The feature exists (I'm looking at it in the attribute table). The feature has a unique id, and the corresponding column is identified as the unique id column.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Is this only true for SQL layers (with filters applied?)?

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Lars Kellogg-Stedman (@larsks)

---

It looks like this only happens with a SQL layer. It works fine with a shapefile layer.

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

I cannot reproduce on current master, I tried with a PG and a Spatialite layer without success, can you please share a small project and data to reproduce the issue?

---

• assigned_to_id was configured as Alessandro Pasotti

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Tested on master/linux and works as expected here (SL datasource).

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

Maybe this is for virtual layers?

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Nyall Dawson wrote:

Maybe this is for virtual layers?

tried them and seems ok here, nut let me try again.

[qgib]

Author Name: Lars Kellogg-Stedman (@larsks)

---

I'll grab the current master and see if the problem reproduces with my actual data.

[qgib]

Author Name: Lars Kellogg-Stedman (@larsks)

---

I see the same behavior in the latest nightly build (208571a). I've recorded a video of the behavior here in case I'm neglecting something in my description of the problem: https://youtu.be/Xk0vMaVsypY

Let me know if you would like more information.

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

Thanks for the video!

Since we don't know exactly where the problem is, it would be really helpful if you could share some data and a project to test with (plus the SQL query that you set in db-manager), this would make it easier to replicate your scenario.

[qgib]

Author Name: Lars Kellogg-Stedman (@larsks)

---

Here's a sample project and data that reproduces the problem:

https://github.com/larsks/qgis-bug-19930

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• status_id was changed from Feedback to Open

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

The table has no primary key, so there is no way to retrieve it from the iterator, I'll try to find a solution but it's not trivial.

Btw, the filter step in attr table is not necessary: zoom to feature does not work even on unfiltered features.

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

#8052

---

• pull_request_patch_supplied was changed from 0 to 1
• status_id was changed from Open to In Progress

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

b395488

---

• status_id was changed from In Progress to Closed
• resolution was changed from to fixed/implemented