Details
-
Type:
Sub-task
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 4.3.0-b1
-
Component/s: Staff Interface
-
Labels:None
Description
The reports under Billing > Reports currently only support CSV format. We need to add a new JSON format. This affects all existing reports.
We need to do one of the following:
- Update all existing reports to allow output via JSON
- It may make sense to take the report data used for CSV and list out each row of data, where each key is the column header and each value is the column value, as a JSON object
- Update reports to set which formats they accept
- Reports may need to return an error if attempting to retrieve them for a given format
- The report page should be able to filter what reports are available by the selected format
TODO:
- Add 'JSON' as a format to the reports page
- Update the way reports are generated to support generating a JSON-formatted report
Issue Links
- blocks
-
CORE-2691
Create the Client Data Portability report
-
- Closed
-
Activity
Tyson Phillips (Inactive)
created issue -
Tyson Phillips (Inactive)
made changes -
| Field | Original Value | New Value |
|---|---|---|
| Component/s | Staff Interface [ 10000 ] |
Tyson Phillips (Inactive)
made changes -
| Description |
The reports under *Billing > Reports* currently only support CSV format. We need to add a new JSON format. This affects all existing reports.
We need to do one of the following: # Update all existing reports to allow output via JSON #* It may make sense to take the report data used for CSV and list out each row of data, where each key is the column header and each value is the column value, as a JSON object # Update reports to set which formats they accept #* Reports may need to return an error if attempting to retrieve them for a given format #* The report page should be able to filter what reports are available by the selected format TODO: # Add 'JSON' as a format to the reports page # Update the way reports are generated to support generating a JSON-formatted report |
The reports under *Billing > Reports* currently only support CSV format. We need to add a new JSON format. This affects all existing reports.
We need to do one of the following: # Update all existing reports to allow output via JSON #* It may make sense to take the report data used for CSV and list out each row of data, where each key is the column header and each value is the column value, as a JSON object # Update reports to set which formats they accept #* Reports may need to return an error if attempting to retrieve them for a given format #* The report page should be able to filter what reports are available by the selected format TODO: # Add 'JSON' as a format to the reports page # Update the way reports are generated to support generating a JSON-formatted report #* Results may need to be batched, in which case the JSON object should be appended to in a memory efficient way |
Tyson Phillips (Inactive)
made changes -
| Description |
The reports under *Billing > Reports* currently only support CSV format. We need to add a new JSON format. This affects all existing reports.
We need to do one of the following: # Update all existing reports to allow output via JSON #* It may make sense to take the report data used for CSV and list out each row of data, where each key is the column header and each value is the column value, as a JSON object # Update reports to set which formats they accept #* Reports may need to return an error if attempting to retrieve them for a given format #* The report page should be able to filter what reports are available by the selected format TODO: # Add 'JSON' as a format to the reports page # Update the way reports are generated to support generating a JSON-formatted report #* Results may need to be batched, in which case the JSON object should be appended to in a memory efficient way |
The reports under *Billing > Reports* currently only support CSV format. We need to add a new JSON format. This affects all existing reports.
We need to do one of the following: # Update all existing reports to allow output via JSON #* It may make sense to take the report data used for CSV and list out each row of data, where each key is the column header and each value is the column value, as a JSON object # Update reports to set which formats they accept #* Reports may need to return an error if attempting to retrieve them for a given format #* The report page should be able to filter what reports are available by the selected format TODO: # Add 'JSON' as a format to the reports page # Update the way reports are generated to support generating a JSON-formatted report |
Tyson Phillips (Inactive)
made changes -
Automated transition triggered when Jonathan Reissmueller created a branch in Stash -
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 2 hours, 56 minutes [ 10560 ] | |
| Worklog Id | 11114 [ 11114 ] |
| Time Spent | 2 hours, 56 minutes [ 10560 ] | 4 hours, 14 minutes [ 15240 ] |
| Worklog Id | 11114 [ 11114 ] |
| Time Spent | 4 hours, 14 minutes [ 15240 ] | 1 day, 48 minutes [ 31680 ] |
| Worklog Id | 11131 [ 11131 ] |
| Assignee | Jonathan Reissmueller [ jonathan ] |
| Time Spent | 1 day, 48 minutes [ 31680 ] | 1 day, 53 minutes [ 31980 ] |
| Worklog Id | 11131 [ 11131 ] |
Automated transition triggered when Jonathan Reissmueller created pull request #442 in Stash -
| Status | In Progress [ 3 ] | In Review [ 5 ] |
| Resolution | Fixed [ 1 ] |
| Time Spent | 1 day, 53 minutes [ 31980 ] | 1 day, 1 hour, 3 minutes [ 32580 ] |
| Worklog Id | 11131 [ 11131 ] |
| Time Spent | 1 day, 1 hour, 3 minutes [ 32580 ] | 1 day, 1 hour, 23 minutes [ 33780 ] |
| Worklog Id | 11131 [ 11131 ] |
| Time Spent | 1 day, 1 hour, 23 minutes [ 33780 ] | 1 day, 1 hour, 38 minutes [ 34680 ] |
| Worklog Id | 11159 [ 11159 ] |
| Time Spent | 1 day, 1 hour, 38 minutes [ 34680 ] | 1 day, 3 hours, 42 minutes [ 42120 ] |
| Worklog Id | 11160 [ 11160 ] |
| Time Spent | 1 day, 3 hours, 42 minutes [ 42120 ] | 1 day, 3 hours, 48 minutes [ 42480 ] |
| Worklog Id | 11166 [ 11166 ] |
| Time Spent | 1 day, 3 hours, 48 minutes [ 42480 ] | 1 day, 4 hours, 35 minutes [ 45300 ] |
| Worklog Id | 11169 [ 11169 ] |
| Time Spent | 1 day, 4 hours, 35 minutes [ 45300 ] | 1 day, 5 hours, 37 minutes [ 49020 ] |
| Worklog Id | 11174 [ 11174 ] |
| Time Spent | 1 day, 5 hours, 37 minutes [ 49020 ] | 1 day, 5 hours, 46 minutes [ 49560 ] |
| Worklog Id | 11178 [ 11178 ] |
| Time Spent | 1 day, 5 hours, 46 minutes [ 49560 ] | 2 days, 14 minutes [ 58440 ] |
| Worklog Id | 11182 [ 11182 ] |
Automated transition triggered when Tyson Phillips (Inactive) merged pull request #442 in Stash -
| Status | In Review [ 5 ] | Closed [ 6 ] |
