Change date format in CSV export for 'Account details' report
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Fix Released
|
Medium
|
Gold |
Bug Description
When you download the 'Account details' report as CSV file, the date for the last login is mentioned as 14 June 2021, 7:40. That makes it impossible to sort the column. The date in the export should be displayed as 2021-06-14, 7:40 instead so sorting is possible. However, when viewing the report online, the date format can stay for easier readability. It also looks like the sorting is done there correctly.
To replicate:
1. Add a few people to your site and log in as them. Masquerading won't help there.
2. Go to Admin menu -> Reports -> Accounts details report and activate the column 'Last login'.
3. View the report and see the login dates.
4. Download the CSV file.
Results:
- Expected: The date column in the CSV file can be sorted and shows the date as 2021-06-14, 7:40
- Actual result: The date column can't be sorted.
Changed in mahara: | |
status: | Confirmed → In Progress |
Changed in mahara: | |
status: | In Progress → Fix Committed |
Changed in mahara: | |
status: | Fix Committed → Fix Released |
Patch for "master" branch: https:/ /reviews. mahara. org/11595