Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-74697

Tables date label columns with empty cells cannot be sorted properly

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Low
    • 7.13.4, 7.14.2, 7.15.0
    • 7.13.1, 7.13.2, 7.13.3, 7.14.0, 7.14.1
    • Editor - Core
    • None

    Description

      Issue Summary

      Tables with Date Picker in it cannot be sorted properly

      Environment

      The issue has been tested and can be replicated in the browsers below:

      • Chrome
      • Firefox
      • Edge

      This issue is not observed in Confluence 7.13.0, but started since Confluence 7.13.1

      Confluence Version Sorting Column
      Confluence 7.13.0
      Confluence 7.13.1
      Confluence 7.13.2
      Confluence 7.14.0
      Confluence 7.14.1

      Steps to Reproduce

      1. Install Confluence 7.13.1
      2. Create a blank page and insert a 3x3 table with heading column
      3. Insert Date Picker in any table cell, but leave at least 1 blank cell (that doesn't have a Date Picker) in the column
      4. Publish the page
      5. In View Mode, try to sort the table by clicking on the heading columns

      Expected Results

      Data in the table can be sorted accordingly

      Actual Results

      Data in the table cannot be sorted or is sorted in an odd way. Sorting is broken

      The error below is thrown in the browser's console log each time when trying to sort the table:

      Uncaught TypeError: d is undefined
    b http://localhost:27131/c7131/s/e292fb6cae0aa35681dcf48f7ffc0a4a-CDN/-z2hkvb/8703/1nlnn84/47318a050e66485335704c72835d76a4/_/download/contextbatch/js/atl.confluence.plugins.pagetree-desktop,main,viewcontent,atl.general,page,atl.comments,-_super/batch.js?gatekeeper-ui-v2=true&healthcheck-resources=true&highlightactions=true&hostenabled=true&locale=en-US&user-logged-in=true:2105
    b http://localhost:27131/c7131/s/e292fb6cae0aa35681dcf48f7ffc0a4a-CDN/-z2hkvb/8703/1nlnn84/47318a050e66485335704c72835d76a4/_/download/contextbatch/js/atl.confluence.plugins.pagetree-desktop,main,viewcontent,atl.general,page,atl.comments,-_super/batch.js?gatekeeper-ui-v2=true&healthcheck-resources=true&highlightactions=true&hostenabled=true&locale=en-US&user-logged-in=true:2105
    m http://localhost:27131/c7131/s/e292fb6cae0aa35681dcf48f7ffc0a4a-CDN/-z2hkvb/8703/1nlnn84/47318a050e66485335704c72835d76a4/_/download/contextbatch/js/atl.confluence.plugins.pagetree-desktop,main,viewcontent,atl.general,page,atl.comments,-_super/batch.js?gatekeeper-ui-v2=true&healthcheck-resources=true&highlightactions=true&hostenabled=true&locale=en-US&user-logged-in=true:2105
    setTimeout handler*m http://localhost:27131/c7131/s/e292fb6cae0aa35681dcf48f7ffc0a4a-CDN/-z2hkvb/8703/1nlnn84/47318a050e66485335704c72835d76a4/_/download/contextbatch/js/atl.confluence.plugins.pagetree-desktop,main,viewcontent,atl.general,page,atl.comments,-_super/batch.js?gatekeeper-ui-v2=true&healthcheck-resources=true&highlightactions=true&hostenabled=true&locale=en-US&user-logged-in=true:2105
    bindEvents http://localhost:27131/c7131/s/e292fb6cae0aa35681dcf48f7ffc0a4a-CDN/-z2hkvb/8703/1nlnn84/47318a050e66485335704c72835d76a4/_/download/contextbatch/js/atl.confluence.plugins.pagetree-desktop,main,viewcontent,atl.general,page,atl.comments,-_super/batch.js?gatekeeper-ui-v2=true&healthcheck-resources=true&highlightactions=true&hostenabled=true&locale=en-US&user-logged-in=true:2105
    dispatch http://localhost:27131/c7131/s/bc47dcdd4f17b39cb15acfc224dfcd82-CDN/-z2hkvb/8703/1nlnn84/761bd8cc908b3c01ee4f06fcdc85e6db/_/download/contextbatch/js/_super/batch.js?locale=en-US:54
    handle http://localhost:27131/c7131/s/bc47dcdd4f17b39cb15acfc224dfcd82-CDN/-z2hkvb/8703/1nlnn84/761bd8cc908b3c01ee4f06fcdc85e6db/_/download/contextbatch/js/_super/batch.js?locale=en-US:54
batch.js:2105:8646

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-78013 Table won't sort by date if there are multiple columns with dates.

          • Low - Low priority issues
          • Closed
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-38083 Dates aren't sorted correctly in European time format (dd.mm.yyyy)

          • Low - Low priority issues
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-75343 Table Sort Operation is not working on a column that contains mixed Dates and Blanked values

          • Low - Low priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-78624 A table doesn't sort if the column with dates has an empty value in one row.

          • Low - Low priority issues
          • Closed

          Activity

            People

              zxu2@atlassian.com Zac Xu
              btan@atlassian.com Damien Tan
              Votes:
              3 Vote for this issue
              Watchers:
              21 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: