sorting of a text column shows Thalasso/Contact/2005/Individuels Thalasso/Contact/2006/Courriel Thalasso/Contact/2006 Thalasso/Contact/2006/Spontané halasso/Contact/2007/Attente the 3d line should be listed before the 2d Reproducible: Always
Created attachment 74161 [details] essailiens.kexi Thanks for the request, Robert. If I understand correctly from the example, you need to sort the data by column #3, and then by column #4. Kexi currently offers sorting by one column in the table view, so as soon as you click the #4 column, previous sorting is lost. In contrast to (ediable) tables, (noneditable) queries offer properly sort the data: you can set sorting for column #3 and #4 in one query (in Design view in Sorting column or in SQL view using ORDER BY clause). To have similar capability in tables, we will have to add "Complex sorting" dialog to specify list of sorting. Example in LibreOffice Calc: http://help.libreoffice.org/Calc/Sort_Criteria, screenshot: http://pandaproject.net/images/libre-sort-data.png
No, it’s not related te complex sorting. I join a one table database which displays the erroneous sorting. Opning the table seems good, because it has been imported in alpha order. But check when clicking the 2d field name Thanks for the information about queries, which indeed sort nice, and is useful for me. la 24/09/2012 23:18, Jarosław Staniek skribis (esperanto estas la unua internacia lingvo) > https://bugs.kde.org/show_bug.cgi?id=307334 > > Jarosław Staniek <staniek@kde.org> changed: > > What |Removed |Added > ---------------------------------------------------------------------------- > Status|UNCONFIRMED |NEEDSINFO > Resolution|--- |WAITINGFORINFO > > --- Comment #1 from Jarosław Staniek <staniek@kde.org> --- > Thanks for the request, Robert. > If I understand correctly from the example, you need to sort the data by column > #3, and then by column #4. Kexi currently offers sorting by one column in the > table view, so as soon as you click the #4 column, previous sorting is lost. In > contrast to (ediable) tables, (noneditable) queries offer properly sort the > data: you can set sorting for column #3 and #4 in one query (in Design view in > Sorting column or in SQL view using ORDER BY clause). > > To have similar capability in tables, we will have to add "Complex sorting" > dialog to specify list of sorting. Example in LibreOffice Calc: > http://help.libreoffice.org/Calc/Sort_Criteria, screenshot: > http://pandaproject.net/images/libre-sort-data.png >
Hi Robert, is it related to but #338808?
Dear Bug Submitter, This bug has been in NEEDSINFO status with no change for at least 15 days. Please provide the requested information as soon as possible and set the bug status as REPORTED. Due to regular bug tracker maintenance, if the bug is still in NEEDSINFO status with no change in 30 days, the bug will be closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging If you have already provided the requested information, please set the bug status as REPORTED so that the KDE team knows that the bug is ready to be confirmed. Thank you for helping us make KDE software even better for everyone!
Dear Bug Submitter, This bug has been in NEEDSINFO status with no change for at least 30 days. The bug is now closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging Thank you for helping us make KDE software even better for everyone!
Created attachment 157851 [details] Result in KEXI 3.2.0
See the result https://bugs.kde.org/attachment.cgi?id=157851 - it is OK in 3.2.0.