IMPORTANT! The information on this page is unverified and unsupported. Always double-check the accuracy of the solutions provided. Evaluate and test the impact on any environments!
Description
After creating a report on certain fixed IDs through the Reports tab, for example:
SELECT status AS 'Status', COUNT(1) AS COUNT WHERE project.id IN (3) AND tracker.id IN (3402) GROUP BY 'Status'
the Chart widget displays that report in a static way.
Even when exporting wiki pages to a project template and importing them under a different project, the widget still refers to the same static data from the source project and tracker, instead of the new ones.
Is there a way to create a report dynamically, so that, in a Chart widget, it refers to Current Project context where the report is shown?
Observed on
- Codebeamer - 22.10-LTS (GINA)
Solution
- Create the report by selecting Current Project as project:
![[!S1.png#42baf363dd6c6a29fd781cfeed63b988!]](/cb/displayDocument/S1.png?doc_id=27679839&version=1&history=false¬ification=false)
Note that this choice limits the setup of other options on the report. For example, it is not possible to choose a certain tracker:
![[!S12.png#09b45cf9f9c490574636cb098ef0d869!]](/cb/displayDocument/S12.png?doc_id=27679841&version=1&history=false¬ification=false)
As a solution, consider creating a fully dynamic report by selecting, for example, a Tracker Type instead of a specific tracker name or ID:
![[!S13.png#a4eae05ad0a9aec899ec032cb4f79468!]](/cb/displayDocument/S13.png?doc_id=27679843&version=1&history=false¬ification=false)
- When ready, Save the report. Do not click on
because you get prompted to choose an actual project.
- Select the dynamic report in a Chart widget, so that it is able to pick the Current project context, and show relevant data.
For any other Support options, questions, or inputs, visit: https://intland.com/technical-support/