How to run report in RPE 2.1.1 that only has a dynamic query?
Using the RPE Launcher, I can leave the URI blank and run a report template that only has a dynamic query. However, the RPE remote services require a Connection and a URI in order to run, even if the template only references a dynamic query.
The reason I want to use the dynamic query is that the driving query returns work items that have been modified in the past week. If I pass in the modified date as part of the RTC REST xpath query, then it has to be updated every time it is run.
Any suggestions? I realize that I could use a JRS data source, but I need the real-time data, and I also need the work item history records with comments.
Thanks,
Robert
3 answers
The better solution would be to hide the data source from being configured within the template itself.
- Open template in studio editor
- In outline view, select the data source
- In properties view, set "configuration need" to hidden.
- Save
If you switch to Launcher perspective, you should not see this data source for configuration.
Comments
Unlike RPE Launcher, Document Builder does not allow document generation if URI is not specified (i.e., associated with a connection) for (any of) the datasources.
If you want to leave the URL blank in Document Builder, you can click "Edit Advanced Configuration" for the report and check "Hide" option for the datasource for which you do not want to specify the URI.
Comments
>>> The reason I want to use the dynamic query is that the driving query returns work items that have been modified in the past week. If I pass in the modified date as part of the RTC REST xpath query, then it has to be updated every time it is run.
You should be able to achieve it through javascript to calculate modified data as current date minus one week. The number one (week) could be a runtime variable for you to set it to different value like 2 or 3.
>>> Any suggestions? I realize that I could use a JRS data source, but I need the real-time data, and I also need the work item history records with comments.
You could generate document for JRS report using RPE or with in JRS (6.0.4 and above). See
https://www.youtube.com/watch?v=lvqqPGvd408
https://www.youtube.com/watch?v=Mj9ktFzoRXQ
Comments