Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-7226

Sorting in rich table not working with specified sorting fields

    Details

    • Type: Task Task
    • Status: Closed Closed
    • Priority: Critical Critical
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: 2.2.0-m1, 2.2
    • Component/s: Development
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • Similar issues:
      KULRICE-5337Sorting on data tables not working
      KULRICE-6471Table sorting is broke again!
      KULRICE-9884Column sort on some columns doesn't work
      KULRICE-12043Sorting for Light Table with Basic Inputs does not consider updated values of fields
      KULRICE-4724Client side table sorting, paging
      KULRICE-13171Action list sorting functionality not working
      KULRICE-12027Table indices in Chrome are not sorted correctly
      KULRICE-9779Investigate sort behaviors/issues and fix on datatables
      KULRICE-8262Sort not working when sub-collections are present
      KULRICE-124002.4.0 CDT: Sorting not working on add line in collection
    • Rice Module:
      KRAD
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required

      Description

      When fields are specified for the initial sort in datatables, they are not getting picked up correctly. See following thread:

      I'm not sure, but we probably did upgrade to 2.0 from the time it was working to the time I noticed it was not working. The problem is that the sort is not sorting by the designated fields, both Date fields. Sort disabling works fine, and if allowed, clicking on the sort-header arrow does sort the rows correctly.

      ~~~~~~~~~~~~~~~~~~~~~~~
      Bob Hurt 206.543.9155
      ~~~~ Student IS ~~~~~~~

      ----Original Message----
      From: Jerry Neal jkneal@indiana.edu
      Sent: Saturday, April 28, 2012 1:53 PM
      To: Bob Hurt; rice.usergroup.krad@kuali.org
      Subject: RE: [kuali] richTable sorting is no longer working for date fields

      Hi Bob,

      Did you update the version of Rice you are using recently? Just wondering what might have changed the behavior. So is the problem you are seeing the sort is still being allowed even though you disabled it?

      Thanks,
      Jerry

      ----Original Message----
      From: Bob Hurt bobhurt@uw.edu
      Sent: Thursday, April 19, 2012 2:10 PM
      To: 'rice.usergroup.krad@kuali.org'
      Subject: [kuali] richTable sorting is no longer working for date fields

      We have a Uif-TableCollectionSection with 4 items, in order, String, Date, Date, Boolean. If we let the richTable render normally so it can be sortable, it will sort correctly by date when the 2nd & 3rd header fields are clicked. However, we do not want the rows to be sortable and instead want them sorted always by the two Date fields. The collection therefore has layoutManager.richTable.componentOptions set to disable sorting and sort in the right order (and some other things). At one point a few weeks ago (maybe longer) it was working, but recently we've noticed it is not. Here is the componentOptions markup being used for the collection:

      <property name="layoutManager.richTable.componentOptions">
      <map merge="true">
      <entry key="bFilter" value="false"/>
      <entry key="bInfo" value="false"/>
      <entry key="bLengthChange" value="false"/>
      <entry key="bPaginate" value="false"/>
      <entry key="aaSorting" value="[[1,'asc'],[2,'asc']]"/>
      <entry key="aoColumns"
      value="[

      {'bSortable':false, 'sWidth':'40%'}

      ,

      {'bSortable':false, 'sType':'kuali_date', 'sTitle':'Start Date', 'sWidth':'20%'}

      ,

      {'bSortable':false, 'sType':'kuali_date', 'sTitle':'End Date', 'sWidth':'20%'}

      ,

      {'bSortable':false, 'sTitle':'Instructional', 'sWidth':'20%'}

      ]"/>
      </map>
      </property>

        Issue Links

          Activity

          Hide
          Eric Njogu (Inactive) added a comment -

          Sorting in all columns in the code snippet appear to be disabled using "'bSortable':false". Contacted Bob for clarification about this.

          Show
          Eric Njogu (Inactive) added a comment - Sorting in all columns in the code snippet appear to be disabled using "'bSortable':false". Contacted Bob for clarification about this.
          Hide
          Eric Njogu (Inactive) added a comment -

          Issue can be resolved by adding configuration "sSortDataType" : "dom-text" to the date column.

          Show
          Eric Njogu (Inactive) added a comment - Issue can be resolved by adding configuration "sSortDataType" : "dom-text" to the date column.

            People

            • Assignee:
              Eric Njogu (Inactive)
              Reporter:
              Jerry Neal (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Structure Helper Panel