-
Suggestion
-
Resolution: Unresolved
-
0
-
2
-
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
- Create a page and remember the exact time of creation
- 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") - Change your profile's timezone
- 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.
- is related to
-
CONFCLOUD-69670 Add the ability to retrieve a user's time zone from the REST API
- Closed
[CONFCLOUD-70966] Search REST API uses the instance's timezone instead of the user's one
Component/s | Original: Search - CQL [ 72790 ] | |
Component/s | New: Search - CQL and Indexing [ 63799 ] |
Labels | Original: API NMI14 | New: API |
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 ] |
Remote Link | New: This issue links to "Page (Confluence)" [ 853202 ] |
UIS | Original: 1 | New: 0 |
Component/s | Original: Ecosystem - API Framework [ 46317 ] | |
Component/s | New: Search - CQL [ 72790 ] |
UIS | Original: 0 | New: 1 |
UIS | Original: 1 | New: 0 |
UIS | Original: 0 | New: 1 |
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