phpmyadmin/phpmyadmin

Order by DESC as default on first click on column

Open

#18,130 opened on 2023年2月20日

GitHub で見る
 (13 comments) (0 reactions) (0 assignees)PHP (6,886 stars) (3,454 forks)batch import
EnhancementUIaffects/5.2affects/6.0confirmed/5.2confirmed/6.0good first issue

説明

Is your feature request related to a problem? Please describe.

The order by made by clicking on a column's name is by default on ASC. Everytime i check a table's content, the table is displayed by default on the ids ASC. Clicking on column id will order them by ASC (1, 2,3), i have to click another time (and send another request) to have them ordered by DESC (1000, 999, 998).

Describe the solution you'd like

I'd like the initial state to stay the same, but a click on the primary key used to sort the table initially (most of the times id) should do the opposite of the default state.

Additional context

  • phpMyAdmin version: 5.2

コントリビューターガイド

技術スタック
phpjavascriptsql
領域
frontenddatabase
Issue 種別
feature
難度新しい貢献者にとっての実装難度です。1 は非常に小さな変更、5 は専門的な作業です。
2
推定時間経験ある貢献者が調査、実装、テスト、pull request 準備にかけるおおよその時間範囲です。
1-3 hours
活動状況Issue が今どれだけ取り組みやすいかを示します。新しい、活発、古い、ブロック中、またはメンテナー入力待ちなどです。
stale
明確さ期待される変更、受け入れ条件、次の手順がどれだけ明確かを示します。
clear
前提条件
Basic PHPJavaScript familiaritySQL sorting concepts
初心者向け度初回貢献者にどれだけ取り組みやすいかを 1-100 で推定したスコアです。
70
調査方針
The issue is about changing the default sort order from ASC to DESC on first click for the primary key column in phpMyAdmin's table display. Look at the frontend sorting logic, likely in JavaScript files under 'js/' such as 'sql.js' or 'sorting.js', and the backend SQL query construction in PHP files. Check the initial sort state and the click handler that toggles order. Review any existing tests or comments for guidance. The solution should modify the behavior so that the first click on the primary key column sorts descending instead of ascending.