QGIS – Sorting by Attributes Does Not Work in GPKG Files

geopackageqgissorting

Since I updated from QGIS 3.16 to 3.22 I have the following problem in attribute tables: in gpkg files the sorting option (alphabetical) does not work – sometimes!

I tried it with projects in qgz- or qgs-format. It happens with point-layers and with polygon layers.

Mostly the problem occurs in gpkg layers, seldom also in shapefiles. The problem only happens in string fields, not in integer/real fields. What is the problem, is it a bug?

Now I added a screenshot. In my OS ubuntu 20.04 up to QGIS 3.16 I sorted by single click, everytime it worked, when I clicked single on the top of a field in the attribute table. Now for example in this table a single click (or double click) works for the field "name_lat", but not for the field "name_d", neither with "jahr". All three fields are string fields. With fid it works.

Now I tried another way: there is a possibility for sorting, but more complicated. When I click on the top of the attribute table, choose context menu, choose sorting. Then I can choose the field for sorting the attribute table. So it works, but it is really complicated. Up to QGIS 3.16 it worked just by one click on the field name that is relevant for me.

Look here https://github.com/qgis/QGIS/issues/47613

Best Answer

The bug is fixed in QGIS 3.22.5.

Related Solutions

qgis – Getting Field Names with QGIS Expressions in Same Order as in Attribute Table

A simple custom function will do that :

from qgis.core import *
from qgis.gui import *

@qgsfunction(args='auto', group='GIS SE', referenced_columns=[])
def ordered_fields(feature, parent):
    return feature.fields().names()

To use : ordered_fields()

QGIS Custom Widgets – Sorting Drop-Down Lists in Value Relation Widget

Due to the fact that I am poorly versed in German - I created a separate data set in English, which should be understandable to all readers of the site.

In order to sort the data in the QGIS drop-down list according to a manually defined order, you need to have the following fields in the tables.

Table 1:

table1_sort - manual sorting of rows.
table1_type - groups.

Table 2:

table2_sort - manual sorting of rows.
table2_type - groups.
table2_objects - objects.
table2_sort - The field that contains the same values as the table1_sort field.

New data will be entered in Table 3. It should contain the following fields:

types - groups.
objects - objects.

Now go to Table 3 field paramaters and set the Widget type to Value Relation.

Now select the types field and set the following parameters for it:

Layer -> Table 1
Key column -> table1_sort
Value column -> table1_type

Now select the objects field and set the following parameters for it:

Layer -> Table 2
Key column -> table2_sort
Value column -> table2_objects
Filter expression -> current_value('types') = "table1_sort"

Now you may try to enter your data with the Drop-down list (with manual sorting):

<== (click to watch)

Best Answer

Related Solutions

qgis – Getting Field Names with QGIS Expressions in Same Order as in Attribute Table

QGIS Custom Widgets – Sorting Drop-Down Lists in Value Relation Widget

Related Question