Sorting a table in composer comboined with limit records does sort after limit (which does not make sense)

[qgib]

Author Name: Marco Lechner (Marco Lechner)
Original Redmine Issue: 18410
Affected QGIS version: 2.18.17
Redmine category:map_composer/printing

---

Hi,
what I have done:

• loading a buildings layer (from OSM data)
• creating a map composition to create an atlas iterating over buildings with "type"='hotel'
• in the map composition adding a attribute table for the buildings layer with an expression based additional colum caclculating the distance etween the hotel-record in the attribute table an the atlas-object
• setting the column as sort criteria for the attribute table
• setting feature filtering of the attribute table in map composer to a maximum rows of five (to only show the 5 nearest hotels around the atlas feature hotel)

Expecting to see only the five nearest hotels around atlas feature (after eliminating the hotel with distance 0 which is the atlas feature hotel
Instead I get the first five records in the table (which are always the same) sorted by the added column.

Expected behaviour is that the attribute table is sorted first and then limited. But QGIS seems to limit first (the unsorted table) and sort then. Which is ok for an almost static table, but does conflict with virtual fields (columns) that are depending on atlas feature!

Marco

[qgib]

Author Name: Marco Lechner (Marco Lechner)

---

• version was changed from 2.18.7 to 2.18.17

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Closing for lack of feedback.

---

• resolution was changed from to no timely feedback
• status_id was changed from Feedback to Closed