PATCH: improve sorting in the Data Editor

From: "J(dot)F(dot) Oster" <jinfroster(at)mail(dot)ru>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: PATCH: improve sorting in the Data Editor
Date: 2015-08-02 10:19:06
Message-ID: 1572621907.20150802131906@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hello,

Here is a small improvement about sorting in the Data editor.

Problem:
If a table has a PK or OIDs, it gets sorted by PK/OID by default.
When a user wants to sort by any other column, he has first to click
"Remove sort" in the context menu, and only then click "Sort
ascending"(descending) on column of his choice.

If he doesn't remove the default sort, he will get no effect and
probably be puzzled for the first time until guesses that he makes
ORDER BY column_pk, column_of_choice
which is totally useless.
The need to "Remove sort" each time is annoying.

Solution:
When a user chooses to sort by some column, we must discard the
default sort order.

Please see the attached patch.
Thanks.

--
Best regards,
J.F.

Attachment Content-Type Size
150802_autoOrderBy.patch application/octet-stream 2.3 KB

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Ashesh Vashi 2015-08-03 05:19:36 Re: PATCH: improve sorting in the Data Editor
Previous Message Ashesh Vashi 2015-07-30 10:47:43 pgAdmin 4 commit: Adding the module.js route for each in the NodeView c