Ticket #6084 (closed defect: worksforme)

Opened 9 months ago

Last modified 3 months ago

Grid sorting fails when column contains null or missing data

Reported by: guest Owned by: toonetown
Priority: normal Milestone: 1.2
Component: DojoX Grid Version: 1.0
Severity: normal Keywords:
Cc: yatessc@…

Description (last modified by toonetown) (diff)

If a model contains null data for a field for some rows, or the field is completely missing for some rows, sorting on a column based on that field in a dojox.Grid fails.

The Grid is re-ordered, but the rows with empty/missing values are not necessarily gathered at the beginning or end of the table, and the rows with valid data in that column are not sorted correctly either. Repeated sorts can produce different results.

Found using a dojox.grid.data.Objects model in Dojo 1.0.2 on IE6. the nulls in my actaul application come from the JSON data source (and originally from an Oracle database.

Empty strings do sort correctly, as do strings containing a single   charcter, so my workaround is obviously to ensure that nulls are converted to proper strings before assigning the model.

Simon Yates

Attachments

gridSort.html (2.2 kB) - added by guest 9 months ago.
Simple example demonstrating sorting problems with nulls in columns

Change History

Changed 9 months ago by guest

Simple example demonstrating sorting problems with nulls in columns

Changed 8 months ago by bill

  • milestone set to 1.2

Changed 3 months ago by BryanForbes

  • owner changed from sorvell to BryanForbes

Changed 3 months ago by toonetown

  • status changed from new to assigned
  • owner changed from BryanForbes to toonetown
  • description modified (diff)

Changed 3 months ago by toonetown

  • status changed from assigned to closed
  • resolution set to worksforme

No longer an issue with the DataGrid?. Reopen with an updated test case if you see further issues.

Note: See TracTickets for help on using tickets.