Uploaded image for project: 'Kuali Rice Development'
  1. Kuali Rice Development
  2. KULRICE-7226

Sorting in rich table not working with specified sorting fields

    Details

    • Type: Task
    • Status: Closed
    • Priority: 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
    • 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>

        Attachments

          Issue Links

            Activity

            Hide
            kunadawa 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
            kunadawa 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
            kunadawa Eric Njogu (Inactive) added a comment -

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

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

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: