Opened 10 years ago

Closed 5 years ago

#108 closed Enhancement (Fixed)

Sort Order for Query/Module/Dimension file

Reported by: Lois Haggard Owned by: Lois Haggard
Priority: *High Milestone:
Component: View-App Version: Parking Lot
Severity: Major Effort Keywords: query output
Cc:

Description (last modified by Garth Braithwaite)

I would like to be able to control the default sort order on my query result tables. Currently, the table rows are sorted by the dimension value. The total row always comes out in the top row because the value for "total" is "." Now I would like to use -9 as a standard missing value, and my "missing values" row is coming out on the top of the table. I would like to control the placement of those table rows. I am thinking that a sort order element in the dimension file, that is used by the values.xslt file, would work.

Attachments (1)

SeriesSort.PNG (79.8 KB) - added by Lois Haggard 5 years ago.
BMI categories sorted by alpha label, not dimension value

Download all attachments as: .zip

Change History (17)

comment:1 Changed 9 years ago by Garth Braithwaite

Doable but not as trivial and efficient (slower times) as it would appear. The result table is based on the IBIS-Q resultant XML which does NOT have any dimension value title or sort order info. Custom code similar to the missing values java code would have to be written to insert the approp associated sort order element to the query result XML.

comment:2 Changed 9 years ago by Garth Braithwaite

Owner: changed from Garth to Java Developer

comment:3 Changed 9 years ago by (none)

Milestone Parking Lot deleted

comment:4 Changed 8 years ago by Garth Braithwaite

Milestone: Unassigned
Owner: changed from Java Developer to unassigned
Severity: Unknown
Version: 2.0Unknown

comment:5 Changed 8 years ago by Kim Neerings

This would be an optional function.

Garth says it would be easy for him to code, but it would be a little harder for adopters to implement.

NC voiced a low interest, would not implement. UT and NM need.

Last edited 8 years ago by Kim Neerings (previous) (diff)

comment:6 Changed 8 years ago by Kim Neerings

Milestone: Unassigned2.1 - Development
Priority: +Medium*High
Severity: UnknownMinor Effort
Version: Unknown2.1

comment:7 Changed 8 years ago by Kim Neerings

Milestone: 2.1 - Development2.1 - Testing

comment:8 Changed 8 years ago by Eleanor Howell

Keywords: query output added

comment:9 Changed 8 years ago by Garth Braithwaite

Description: modified (diff)
Milestone: 2.1 - TestingUnassigned
Owner: set to unassigned
Severity: Minor EffortModerate Effort
Version: 2.1Unknown

comment:10 Changed 8 years ago by Garth Braithwaite

Description: modified (diff)

comment:11 Changed 6 years ago by Garth Braithwaite

Description: modified (diff)
Owner: unassigned deleted
Severity: Moderate EffortMajor Effort

The SORT_ORDER element was added to the query result DIMENSION/VALUE xsd. For this to be implemented would require:

  1. adopters to create/populate all the dim value SORT_ORDER elements.
  2. Java model map processing step that looks up the DIMENSION VALUE/SORT_ORDER value and adds that SORT_ORDER to the IBIS-Q RECORD VALUE so that the XSLT can sort it (xslt code uses the result XML).
  3. Because the value list can be 1-3 dims can't simply do a sort by the VALUE/SORT_ORDER. The XSLT values and values 2d code would have to be reworked to use the <xsl:for-each-group and current-grouping-key().

The above solution goes away with the move to the Kendo grid - would need a different solution.

Last edited 6 years ago by Garth Braithwaite (previous) (diff)

comment:12 Changed 6 years ago by Garth Braithwaite

Owner: set to unassigned

comment:13 Changed 6 years ago by kathie

Milestone: Unassigned2.3 - Testing
Owner: changed from unassigned to Lois Haggard

comment:14 Changed 6 years ago by Lois Haggard

Milestone: 2.3 - Testing
Version: UnknownParking Lot

Changed 5 years ago by Lois Haggard

Attachment: SeriesSort.PNG added

BMI categories sorted by alpha label, not dimension value

comment:15 Changed 5 years ago by Lois Haggard

The sort order is working. If there is no sort order, IBIS will use the dimension value. And it sorts the values in the Kendo chart package, with one exception: It will not work with the series dimension. If we want the label to appear in the table, and on the graph, Kendo will sort those by the label. We could put the sort order or dimension value into the Kendo table and use that to sort the table, but then the labels for the graph would be those values. See the attached image for an example.

comment:16 Changed 5 years ago by Lois Haggard

Resolution: Fixed
Status: newclosed
Note: See TracTickets for help on using tickets.