Describe the bug
When selecting the view details menu option for a report in the Active Reports view, the system navigates me to a page where I can view all details for the patient associated to the clinical event, however no data is rendered, and I only receive an error "error preparing view". The report I accessed is in the Confirm Report Data tab, but I have been able to reproduce this issue with a report in any of the tabs.

To Reproduce
Navigate to analytical portal --> Active Reports --> Reports
The Confirm Reports Data tab indicates there is at least 1 report available for viewing
Click on the Confirm Reports Data tab
Select the menu icon and then the View details menu option
The system navigates to the new view and the error is received
Expected behavior
The view should render with all patient details associated to the report displayed
Observed behavior: an error message is received and no data is displayed in the view.
Environment
v3.1.0-alpha-2
mysql 8.x
Describe the bug
When selecting the view details menu option for a report in the Active Reports view, the system navigates me to a page where I can view all details for the patient associated to the clinical event, however no data is rendered, and I only receive an error "error preparing view". The report I accessed is in the Confirm Report Data tab, but I have been able to reproduce this issue with a report in any of the tabs.
To Reproduce
Navigate to analytical portal --> Active Reports --> Reports
The Confirm Reports Data tab indicates there is at least 1 report available for viewing
Click on the Confirm Reports Data tab
Select the menu icon and then the View details menu option
The system navigates to the new view and the error is received
Expected behavior
The view should render with all patient details associated to the report displayed
Observed behavior: an error message is received and no data is displayed in the view.
Environment
v3.1.0-alpha-2
mysql 8.x