[COMPASS-3145] Dates in Aggregation builder displayed incosistently Created: 21/Sep/18  Updated: 29/Oct/23  Resolved: 27/Sep/18

Status: Closed
Project: Compass
Component/s: Aggregation pipeline
Affects Version/s: None
Fix Version/s: 1.16.0, 1.17.0

Type: Bug Priority: Major - P3
Reporter: Scott Stokes (Inactive) Assignee: Durran Jordan
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Mac OSX


Attachments: PNG File image-2018-09-21-13-54-14-814.png    
Sprint: Iteration Naan

 Description   

In aggregation builder, a date displayed in the "original" document sample is displayed differently than in the results of a stage.  It appears, dates displayed in the stage results panel are adjusted by the users TZ where the date in the "original" document is not.

Both should be displayed consistently.  Ideally, I believe there should be an option to toggle whether to display dates according to the current TZ or the "raw" date in the document.

The mongo shell displays consistently, BTW, according to the user's TZ setting.

Please see attached screen shot.  There is only 1 document in the collection being shown



 Comments   
Comment by Githook User [ 27/Sep/18 ]

Author:

{'name': 'Durran Jordan', 'email': 'durran@gmail.com', 'username': 'durran'}

Message: COMPASS-3145: Fix timezones in stage preview
Branch: 1.16-releases
https://github.com/10gen/compass/commit/752afc05aa16101bc46a3ae316ae699271030f88

Comment by Githook User [ 27/Sep/18 ]

Author:

{'name': 'Durran Jordan', 'email': 'durran@gmail.com', 'username': 'durran'}

Message: COMPASS-3145: Fix timezones in stage preview
Branch: master
https://github.com/10gen/compass/commit/747386395efde7e9b9e465316be6e090ff4c2a38

Comment by Githook User [ 27/Sep/18 ]

Author:

{'name': 'Durran Jordan', 'email': 'durran@gmail.com', 'username': 'durran'}

Message: COMPASS-3145: Fix timezones in stage preview
Branch: COMPASS-3145
https://github.com/10gen/compass/commit/902de0699cd00afd4ef15834306736f4f53b4445

Comment by Durran Jordan [ 27/Sep/18 ]

Will backport to 1.16 beta series.

Generated at Wed Feb 07 22:32:17 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.