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.
|
3 answers
>>> 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.
Comments
Robert Huet
commented Jun 21 '17, 2:56 p.m.
So far, I'm thinking this is the only workable solution with the RPE Web UI. I created a JRS query with a query of "SELECT SYSDATE from DUAL". So I use this query as my parent query, but I don't use it in the template other than to pass on the credentials to the dynamic query. This seems to work.
|
The better solution would be to hide the data source from being configured within the template itself.
Comments
Robert Huet
commented Jun 21 '17, 2:54 p.m.
Under "configuration required", I set the property to "credentials", because I still need to pass the credentials from the launcher even though I don't need to supply a URI. However, when I go to run from the RPE Web UI, I still cannot run the report without selecting a Connection. And If I create a connection, I'm forced to provide a URI.
|
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.
Comments
Subramanya Prasad Pilar
commented Jun 21 '17, 6:11 a.m.
You can consider this solution if you do not wish to make any changes to RPE template.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.