Project

General

Profile

Actions

Patch #36438

open

Support nulls first/last option for sorting order of custom queries

Added by Dmitry Makurin almost 3 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:

Description

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.

order options

And the result of issues sorted by due date ascending nulls last:

sported issues

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.


Files

ksnip_20220117-150142.png (41.7 KB) ksnip_20220117-150142.png order options Dmitry Makurin , 2022-01-17 13:04
ksnip_20220117-150213.png (106 KB) ksnip_20220117-150213.png sported issues Dmitry Makurin , 2022-01-17 13:04
0001-nulls-last-first-option-for-sorting-order.patch (4.67 KB) 0001-nulls-last-first-option-for-sorting-order.patch Dmitry Makurin , 2022-01-17 13:29

No data to display

Actions

Also available in: Atom PDF