Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-70966

Search REST API uses the instance's timezone instead of the user's one

XMLWordPrintable

    • 0
    • 2

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      Issue Summary

      When using the /wiki/rest/api/content/search endpoint to search for pages based on modified/ created dates, the API is currently using the instance's timezone instead of the one defined on the user's profile.

      Steps to Reproduce

      1. Create a page and remember the exact time of creation
      2. Use the /wiki/rest/api/content/search endpoint to look for pages created/ modified at that time
        e.g. /wiki/rest/api/content/search?cql=(lastmodified > "2020-10-19 19:00")
      3. Change your profile's timezone
      4. Search again, changing the time to reflect the specific timezone chosen

      Expected Results

      The results should be based on the user's timezone (set individually on the user settings/ profile)

      Actual Results

      The search will be based on the instance's timezone (timezone for the user who created the instance).

      Workaround

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

            [CONFCLOUD-70966] Search REST API uses the instance's timezone instead of the user's one

            Samir made changes -
            Component/s Original: Search - CQL [ 72790 ]
            Component/s New: Search - CQL and Indexing [ 63799 ]
            Rebekkah Dorhout made changes -
            Labels Original: API NMI14 New: API
            Rebekkah Dorhout made changes -
            Workflow Original: JAC Bug Workflow v3 [ 4003818 ] New: JAC Suggestion Workflow 3 [ 4481995 ]
            Issue Type Original: Bug [ 1 ] New: Suggestion [ 10000 ]
            Priority Original: Low [ 4 ]
            Status Original: Short Term Backlog [ 12074 ] New: Gathering Interest [ 11772 ]

            Rebekkah Dorhout added a comment -

            Hi all,

            Thanks for your interest in this item. As per our development document the `lastModified` cql field search results will be relative to the configured time zone (which is by default the Confluence server's time zone) and changing that would be a feature request. So we're converting this to a Feature request so that it can be reviewed and prioritized accordingly (and so that your votes will carry over and you can continue to track our progress).

            Thank you,

            Rebekkah 

            Rebekkah Dorhout added a comment - Hi all, Thanks for your interest in this item. As per our development document the `lastModified` cql field search results will be relative to the configured time zone (which is by default the Confluence server's time zone) and changing that would be a feature request. So we're converting this to a Feature request so that it can be reviewed and prioritized accordingly (and so that your votes will carry over and you can continue to track our progress). Thank you, Rebekkah 
            nmcginley made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 853202 ]
            SET Analytics Bot made changes -
            UIS Original: 1 New: 0
            Laura Mehrkens made changes -
            Component/s Original: Ecosystem - API Framework [ 46317 ]
            Component/s New: Search - CQL [ 72790 ]
            SET Analytics Bot made changes -
            UIS Original: 0 New: 1
            SET Analytics Bot made changes -
            UIS Original: 1 New: 0
            SET Analytics Bot made changes -
            UIS Original: 0 New: 1

              Unassigned Unassigned
              gtworkowski Guilherme T (Inactive)
              Votes:
              4 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated: