Can't sort attribute table in composer when generating an atlas (working on 3.12.1, not 3.12.2)

[rbonnefoi]

Hi all,

I noticed what seems to be a bug in the last 3.12.2 version.

I tried to sort a displayed attribute table in the composer but the sorting feature was absolutely without effect on some columns.

Once back to 3.12.1 version, everything worked as expected.

The table is from a csv file without geometry. At first, I used a junction with a polygon gpkg layer. Trying to investigate the problem, I tried with the csv file alone as the problem could occur because of the junction, but the problem was still the same.

You'll find enclosed the csv file (encapsulated within a zip file, as the csv type is not allowed for attached files). If you want to try to replicate the problem, display the table in the composer and try to sort it along the "ryhtme annuel log" column.

Many thanks for the help.

Remi.
donneesPLH.zip

[gioman]

. If you want to try to replicate the problem, display the table in the composer and try to sort it along the "ryhtme annuel log" column.

@rbonnefoi depending on how you load the CSV its columns can be loaded all as text. So if you use the expression

to_int("ryhtme annuel log")

it will order as you expect. This is at least how it works here on master after having added the CSV in QGIS by dragging it in the program main windows.

This wasn't necessary in 3.12.1? of you load the CSV in the project?

[Nane231]

Hi,
I have the same problem with any attribute tables (with geometry) if I generate an atlas and filter the attribute table with the atlas feature. Without generating an atlas or without filtering for the atlas feature I can sort the attribute table and everything works fine, after filtering and sorting there are no more data shown in the table. It worked fine in QGIS 3.12.1, but not in 3.12.2

[rbonnefoi]

Thanks Giovanni for dealing with my problem, and thanks to Nane for the complement. It is indeed an important thing to mention I forgot : I was generating an atlas when I faced the problem. It is not a matter of data type, as I checked before it was numerical, and even forced it by to_int function. Le 14/05/2020 13:58:00, Nane231 <notifications@github.com> a écrit : Hi, I have the same problem with any attribute tables (with geometry) if I generate an atlas. Without generating an atlas I can sort the attribute tables and everything works fine, after sorting there are no more data shown in the table. It worked fine in QGIS 3.12.1, but not in 3.12.2 — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub [#36341 (comment)], or unsubscribe [https://github.com/notifications/unsubscribe-auth/ADCPQS65ZBT2J3NKB5T6XE3RRPMEPANCNFSM4M5WER4A].

[gioman]

: I was generating an atlas when I faced the problem

@rbonnefoi just a little detail :)

[gioman]

It is indeed an important thing to mention I forgot : I was generating an atlas when I faced the problem.

@rbonnefoi can you attach a sample project (but complete, with data and print composer/atlas configurations) we can use for tests? Thanks.

[Nane231]

I know I'm not rbonnefoi - I hope I'm not too invasive... But I did a sample project with the problem. Here it is:
test_sort.zip

[rbonnefoi]

Great, Thanks. Giovanni, tell me if you need my sample project also. Le 14/05/2020 16:44:21, Nane231 <notifications@github.com> a écrit : I know I'm not rbonnefoi - I hope I'm not too invsive... But I did a sample project. Here it is: test_sort.zip [https://github.com/qgis/QGIS/files/4629092/test_sort.zip] — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub [#36341 (comment)], or unsubscribe [https://github.com/notifications/unsubscribe-auth/ADCPQSYHDXD6VIVO445IE6LRRP7ULANCNFSM4M5WER4A].

[Nane231]

I noticed another problem wich is connected with "sorting attributes". If you want to sort (without atlas filter) a table in the composer with two fields, then it sorts first the second field and then the first field. Usually (till QGIS 3.12.1) it was the other way around. This problem is easy to solve, you only have to change the order of the sorting fields, but maybe this information helps to find a solution for the bug above? Here are screenshots to make clear what I wanted to describe:
sorting.pdf

[alexandreparente]

I have the same problem in 3.12.3 and 3.13

Test 1: QGIS version 3.12.3, filtering feature disabled

before sorting
(without filter)

after sorting
(without filter)

Everything worked as expected.

Test 2: QGIS version 3.12.3, filtering feature enabled

before sorting
(with filter)

after sorting
(with filter)

Result: The table does not show any feature.

System information

QGIS version 3.12.3-București
QGIS code revision 8234261
Compiled against Qt 5.12.8
Running against Qt 5.12.8
Compiled against GDAL/OGR 3.0.4
Running against GDAL/OGR 3.0.4
Compiled against GEOS 3.8.0-CAPI-1.13.1
Running against GEOS 3.8.0-CAPI-1.13.1
Compiled against SQLite 3.31.1
Running against SQLite 3.31.1
PostgreSQL Client Version12.2 (Ubuntu 12.2-4)
SpatiaLite Version 4.3.0a
QWT Version 6.1.4
QScintilla2 Version 2.11.2
Compiled against PROJ 6.3.1
Running against PROJ Rel. 6.3.1, February 10th, 2020
OS Version Ubuntu 20.04 LTS

Test 3: QGIS version 3.13, filtering feature enabled

before sorting

and after sorting (with filter)