Loading...
 
Skip to main content

Trackers: Add 2nd, 3rd sort option

  • Tracker item actions
Trackers
Items
Status
Open
Subject
Trackers: Add 2nd, 3rd sort option
Version
21.x
25.x
Category
  • Feature request
Feature
Trackers
Resolution status
New
Submitted by
hman
Lastmod by
hman
Rating
(0)
Description

When you create trackers with lots of entries (like cataloging newspaper articles) you will soon find that Tiki's sorting options are far (!) too limited. There is just one sorting option. A second is implied, but undocumented (either it's creation date or it is ID, could not find out).

It would be a significant improvement (and VERY easy to create in SQL) if a second and third sort option could be integrated just like the first one: Select field, select order.

These should be hierarchical, so all elements should first be sorted by option 1, and within all results sorting should be by option 2.

So for the newspaper archive example: First sort by category/department/column (alphabetically ascending), and within that by page number (numerically ascending), and on page number by title (alphabetically ascending). Just like Excel does.

These must be three separate options with both field and order selection, do not make it a multiselect, because you might want to have differing sort orders for separate fields...

Importance
7
Easy to solve?
10 easy
Priority
70
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
8150
Created
Friday 27 May, 2022 22:00:34 UTC
by hman
LastModif
Friday 27 May, 2022 22:08:28 UTC


Show PHP error messages