A tip for troubleshoot a report in Tririga that is not returning data as expected
Note: This tip can be used with reports from the System Reports tab in My Reports or Report Manager.
You can follow the steps below to troubleshoot Tririga reports and see if the SQL returns data:
- In the Tririga application, choose either Tools, and from there choose Report Manager; or simply click on My Reports. From here you will see the following tabs: My Reports, Community, System Reports, and Administration.
- Choose the System Reports tab and search for the report that you are needing to troubleshoot by clicking on the report title. The report will open in a new window.
- Once the report is open in the new window you will see multiple tabs across the top, one of these will be labeled, Advanced. Click on the Advanced tab and on the top right you will see some buttons for Run Report, Save, etc. Under these buttons you will see links that you can click, one of these is labeled, Export Sql.
- Click the Export Sql link and a pop-up window will come up with options to open or save file. You can do either of these, if you save the file make note of where you save it and what you name it as you will have to find it for the next step. Once you have the SQL for the report that you are troubleshooting, you can log out of the Tririga Application if you wish.
- Now you will log in to the Tririga Administrator Console to test the SQL that you captured against the Tririga database. Once logged into the Admin Console, choose Database Query Tool from the list of managed objects on the left of the screen.
- Now, copy the SQL you saved or opened and click in the SQL Query section of the screen and then right-click and choose Paste.
- Once the query is pasted into the SQL Query section of the window, click the Run Query link at the top of the window. If the SQL returns data it will be visible just below the Rows to Return.
If the report SQL does not return data, then that explains why the report is not returning data, there is no data for the report to display. Add data and test the report again, the report should return data if the SQL does.
If the SQL returns data but the report does not display data, this is likely a report problem. To troubleshoot this, refer to information available online or contact support.