Vote #81784
未完了Support nulls first/last option for sorting order of custom queries
ステータス:
New
優先度:
通常
担当者:
-
カテゴリ:
-
対象バージョン:
-
開始日:
2022/05/09
期日:
進捗率:
0%
予定工数:
Redmineorg_URL:
category_id:
0
version_id:
0
issue_org_id:
36438
author_id:
399232
assigned_to_id:
0
comments:
0
status_id:
1
tracker_id:
3
plus1:
0
affected_version:
closed_on:
affected_version_id:
説明
A lot of RDBMS has support for placement of null values at the start or end using options nulls first/last.
Atached patch adds two more order options to the saved query:
- Ascending nulls last.
- Descending nulls first.
!ksnip_20220117-150142.png!
And the result of issues sorted by @due date ascending nulls last@:
!ksnip_20220117-150213.png!
Patch probably broken when using MySql since it doesn't have a straightforward syntax for order predicate but it's fine using SQLite3 or Postgres.
表示するデータがありません