Space Analytics - "Last modified" Column Not Sorting Correctly

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Low
    • Component/s: Analytics (BE)
    • None
    • 1
    • Severity 3 - Minor

      Issue Summary

      • In Space Analytics "Last modified" column view does not sort correctly in descending order. Despite the modification dates appearing correct in the database, the sorting behavior is inconsistent, affecting the display of pages based on their modification times.

      Steps to Reproduce

      1. Access the provided Space link.
      2. Select the Analytics tab.
      3. Go to the Pages tab.
      4. Sort the list by "Last Modified" in descending order.

      Expected Results

      • Pages should be sorted in descending order based on their last modification date.

      Actual Results

      • "Last modified" column in the Space Analytics view does not sort correctly in descending order. Despite the modification dates appearing correct in the database, the sorting behaviour is inconsistent, affecting the display of pages based on their modification times.

      Investigation Method:

      • By utilizing developer tools to generate a HAR file, it was discovered that the API request made to Analytics is not getting the response in correct descending order:

       

      https://domain.atlassian.net/gateway/api/ex/confluence/xxxxxxxxxxxxxxxx/analytics/v2/space/contentViews?spaceId=xxxxx&fromDate=2025-04-28T14%3A00%3A00.000Z&toDate=2025-07-31T00%3A34%3A58.694Z&timezone=Australia%2FNSW&content=page%2Cblogpost&limit=100&sortBy=lastModificationDate&sortOrder=DESC

      { "contentId": "1392446118", "createdAt": "2025-07-30T07:13:06.658Z", "type": "page", "lastModificationDate": "2025-07-30T08:58:14.868Z", "webui": "/spaces/xxx/pages/1392446118/xxxxxxx", "totalViewed": 4, "lastViewedAt": "2025-07-30T08:58:21.061Z", "uniqueUsersViewed": 1, "totalComments": 0, "title": "xxxxxxxxxx" }

      { "contentId": "1372654652", "createdAt": "2025-07-04T03:48:05.020Z", "type": "page", "lastModificationDate": "2025-07-30T10:32:40.575Z", "webui": "/spaces/xxx/pages/1372654652/xxxxxxx", "totalViewed": 52, "lastViewedAt": "2025-07-30T10:10:46.549Z", "uniqueUsersViewed": 17, "totalComments": 0, "title": "xxxxxxxxx" }

      { "contentId": "1392229537", "createdAt": "2025-07-30T08:24:09.785Z", "type": "page", "lastModificationDate": "2025-07-30T08:46:36.520Z", "webui": "/spaces/xxx/pages/1392229537/xxxxxxx", "totalViewed": 2, "lastViewedAt": "2025-07-30T08:46:42.500Z", "uniqueUsersViewed": 1, "totalComments": 0, "title": "xxxxxxxxxx" }

      Workaround

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

              Assignee:
              Unassigned
              Reporter:
              Shahid Qureshi (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: