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

Sequence column sorts like string instead of number

    Details

    • Type: Bug Fix Bug Fix
    • Status: Closed Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.5
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • Similar issues:
      KULRICE-10034Sort on auto-sequence column is not numeric
      KULRICE-9783Support ability to explicitly set the sort type (string,number,currency) within a collection
      KULRICE-6534Rename KREW_STYLE_T table to KRCR_STYLE_T, change it's id column to a string, and change StyleContract.getStyleId to StyleContract.getId() returning a String instead of a Long
      KULRICE-3926Override SequenceStyleGenerator to handle Strings
      KULRICE-3972need to be able to sort by column header like on lookups when editing large roles and groups
      KULRICE-5197Need to be able to sort by column header like on lookups when editing large roles and groups
      KULRICE-8330Add configuration options for datatype on grouping columns
      KULRICE-9884Column sort on some columns doesn't work
      KULRICE-7400now that document id is a string it is not sorting as a number
      KULRICE-5512"Sort" UI problems
    • Rice Module:
      KRAD
    • KRAD Feature Area:
      UIF Component
    • Sprint:
      2.5.0-m2 Sprint 3, 2.5.0-m3 Sprint 1
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required

      Description

      When the auto-sequence is used for tables the initial sort displays out of order because it is being sorted like a string instead of a number. For example record 20 displayed right after record 1 (see screenshot)

        Issue Links

          Activity

          Jerry Neal (Inactive) made changes -
          Field Original Value New Value
          Link This issue cloned to KULRICE-7208 [ KULRICE-7208 ]
          Jerry Neal (Inactive) made changes -
          KRAD Feature Area UIF Component [ 14304 ]
          Fix Version/s 2.3 [ 16595 ]
          Fix Version/s 2.3.0-m4 [ 16759 ]
          Fix Version/s 2.3-backlog [ 16596 ]
          Description When the auto-sequence is used for tables the initial sort displays out of order because it is being sorted like a string instead of a number. For example record 20 displayed right after record 1 (see screenshot)
          Priority Major [ 3 ] Critical [ 2 ]
          Jerry Neal (Inactive) made changes -
          Attachment screenshot-1.jpg [ 67487 ]
          Jessica Coltrin (Inactive) made changes -
          Fix Version/s 2.3.0-m2 [ 16757 ]
          Fix Version/s 2.3.0-m4 [ 16759 ]
          Jessica Coltrin (Inactive) made changes -
          Fix Version/s 2.3.0-m3 [ 16758 ]
          Fix Version/s 2.3.0-m2 [ 16757 ]
          Jessica Coltrin (Inactive) made changes -
          Fix Version/s 2.3.0-m3 [ 16758 ]
          Jessica Coltrin (Inactive) made changes -
          Fix Version/s 2.4 [ 16913 ]
          Fix Version/s 2.3 [ 16595 ]
          Shem Patterson (Inactive) made changes -
          Workflow custom [ 198134 ] Copy of custom for rice [ 207935 ]
          Shem Patterson (Inactive) made changes -
          Workflow Copy of custom for rice [ 207935 ] custom [ 217683 ]
          Shem Patterson (Inactive) made changes -
          Workflow custom [ 217683 ] Rice Workflow [ 227431 ]
          Claus Niesen made changes -
          Fix Version/s 2.5 [ 17044 ]
          Fix Version/s 2.4 [ 16913 ]
          Claus Niesen made changes -
          Component/s KNS Equivalency [ 13684 ]
          Claus Niesen made changes -
          Original Estimate 3 days [ 86400 ]
          Claus Niesen made changes -
          Remaining Estimate 3 days [ 86400 ]
          Claus Niesen made changes -
          Sprint 2.5 KNS Equiv - m6 [ 252 ]
          Claus Niesen made changes -
          Rank Ranked higher
          Claus Niesen made changes -
          Sprint 2.5 KNS Equiv - m6 [ 252 ]
          Claus Niesen made changes -
          Rank Ranked lower
          Claus Niesen made changes -
          Sprint 2.5 KNS Equiv - m7 [ 254 ]
          Claus Niesen made changes -
          Rank Ranked higher
          Claus Niesen made changes -
          Sprint 2.5 KNS Equiv - m7 [ 254 ] 2.5 KNS Equiv - m5 [ 251 ]
          Claus Niesen made changes -
          Sprint 2.5 KNS Equiv - m4 [ 251 ] 2.5 KNS Equiv - m5 [ 252 ]
          Claus Niesen made changes -
          Sprint 2.5 KNS Equiv - m5 [ 252 ]
          Corey Pedersen (Inactive) made changes -
          Assignee Corey Pedersen [ cpedersen ]
          Corey Pedersen (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Corey Pedersen (Inactive) made changes -
          Sprint 2.5.0-m2 Sprint 3 [ 284 ]
          Corey Pedersen (Inactive) made changes -
          Rank Ranked higher
          Jessica Coltrin (Inactive) made changes -
          Sprint 2.5.0-m2 Sprint 3 [ 284 ] 2.5.0-m2 Sprint 3, 2.5.0-m3 Sprint 1 [ 284, 286 ]
          Jessica Coltrin (Inactive) made changes -
          Rank Ranked higher
          Corey Pedersen (Inactive) made changes -
          Link This issue is duplicated by KULRICE-10034 [ KULRICE-10034 ]
          Corey Pedersen (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          Corey Pedersen (Inactive) made changes -
          Remaining Estimate 3 days [ 86400 ] 0 minutes [ 0 ]
          Time Spent 4 days [ 115200 ]
          Worklog Id 95655 [ 95655 ]
          Corey Pedersen (Inactive) made changes -
          Link This issue is fixed by KULRICE-9783 [ KULRICE-9783 ]
          Corey Pedersen (Inactive) made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Matt Sargent made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

            People

            • Assignee:
              Corey Pedersen (Inactive)
              Reporter:
              Jerry Neal (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 3 days Original Estimate - 3 days
                3d
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 4 days
                4d

                  Agile

                    Structure Helper Panel