Enhance TopN plugin
Description
Release Notes
None
Activity
Show:
Pinned fields
Click on the next to a field label to start pinning.
Details
Details
Assignee

Reporter

Components
Fix versions
Priority
Created March 24, 2021 at 8:27 PM
Updated March 24, 2021 at 8:27 PM
The current TopN plugin allows selecting the top N rows based on a single field. It would be useful if it could select the top based on ordering multiple fields, with multiple directions. For example:
get the top 10 records ordered by year, month, day
get the top record ordered by age desc, name asc
In addition it looks like not all data types are supported in the plugin, it would be good to enhance it to support more types.
The ordering of null values is also ambiguous, would be good to have an option that specifies if nulls are the top value or bottom value (or maybe just ignored entirely?)