DNG RPE Template to publish a view (filters + columns)?
Accepted answer
Yes. If you are using DNG 6.0.4 or later, you can execute external requests against module views and generate documents from RPE template that uses views data source schema.
You can add schema using https://server:port/rm/publish/views?metadata=schema and design the RPE template. You can also use printModuleBook.dta (shipped with DNG) to publish a view by configuring its "views" data source as follows (example URL from my DNG instance):
https://<myserver>:9443/rm/publish/views?moduleURI=_c5733113b7694e81b68d23bb6f43e8d0&viewURI=_8d5f8cPhEeejG9hgXvzkBg&projectURI=_iLyo8VcTEeeH6p0FXWH5Ig
Requests against DNG reporting service for "views" artifact format are supported under the following formats:
https://serverName:port/rm/publish/views?moduleURI=https://serverName:port/rm/resources/_YbK4wd6IEeaEaOW7hUvrNQ&viewURI=https://serverName:port/rm/views/_iRsR8d6IEeaEaOW7hUvrNQ&projectURI=serverName:port/rm/process/project-areas/_uxdv8N3FEeaRC8I0G_Qhlg
or
https://serverName:port/rm/publish/views?moduleURI=_YbK4wd6IEeaEaOW7hUvrNQ&viewURI=_iRsR8d6IEeaEaOW7hUvrNQ&projectURI=_uxdv8N3FEeaRC8I0G_Qhlg
Note: To be able to execute an external request against "views" artifact format, project area, module and view information is necessary and view and module must belong to the project area provided on the request. If one of these parameters (moduleURI, viewURI and projectURI) is missing or invalid, or module or view do not belong to the project area, then a bad request response will be provided.
2 other answers
OK so the DSX URI for the views datasource should be of the form
https://serverName:port/rm/publish/views?moduleURI=_YbK4wd6IEeaEaOW7hUvrNQ&viewURI=_iRsR8d6IEeaEaOW7hUvrNQ&projectURI=_uxdv8N3FEeaRC8I0G_Qhlg
with a view, module and project area URI all in agreement (i.e. the view must apply to the module and both must be in the project)
Here is the URI of my module
https://localhost:9443/rm/resources/_jvSfgSeqEeiIY4jSc2zQlg?oslc_config.context=https%3A%2F%2Flocalhost%3A9443%2Frm%2Fcm%2Fstream%2F_I3hlMCbhEeiejZ97BmNJiA
So I take the string _jvSfgSeqEeiIY4jSc2zQlg as the module ID (?)
Here is the URI of my view
https://localhost:9443/rm/web#action=com.ibm.rdm.web.pages.showArtifact&artifactURI=https%3A%2F%2Flocalhost%3A9443%2Frm%2Fresources%2F_jvSfgSeqEeiIY4jSc2zQlg&filterId=_hXYQMTzjEeialsG3CL8ZrQ&vvc.configuration=https%3A%2F%2Flocalhost%3A9443%2Frm%2Fcm%2Fstream%2F_I3hlMCbhEeiejZ97BmNJiA
So I take the string _hXYQMTzjEeialsG3CL8ZrQ (? from the filterId)
Then I just need the project URI
The project itself has the web browser URL:-
https://localhost:9443/rm/web#action=com.ibm.rdm.web.pages.showFoundationProjectDashboard&componentURI=https://localhost:9443/rm/rm-projects/_ILUmgCbhEeiejZ97BmNJiA/components/_I1u1cCbhEeiejZ97BmNJiA
Which I think gives a project URI of _ILUmgCbhEeiejZ97BmNJiA (?)
So I assemble my complete DSX URI as
https://localhost:9443/rm/publish/views?moduleURI=_jvSfgSeqEeiIY4jSc2zQlg&viewURI=_hXYQMTzjEeialsG3CL8ZrQ&projectURI=_ILUmgCbhEeiejZ97BmNJiA
But this gives
CRRPE1064I Error in engine
Auto: connection to https://localhost:9443/rm/publish/views?https://localhost:9443/rm/publish/views?moduleURI=_jvSfgSeqEeiIY4jSc2zQlg&viewURI=_hXYQMTzjEeialsG3CL8ZrQ&projectURI=_ILUmgCbhEeiejZ97BmNJiA failed. None of the known protocols succeeded.
Have I assembled my DSX URI incorrectly?
hi there,
I succeed to insert a view using the ModuleView_Custom Template established by IBM by configuring the DSX file with the URI for view, module and project Area.
Sean, i did like you said for the module and view URI but i took the URI from the itemId part of the URL of my project after clicking on Manage this project Area : https://rm.almfr-bas.group.intra/rm/admin?displayBanner=true#action=com.ibm.team.process.editProjectArea&itemId=_DE6H4EcCEeivodO_0Cn9HQ.
Nevertheless, i have a problem with my dta file. Using the dta file given by the template, all works perfectly but if i try to configure the view as a data schema in a new .dta with the same URI used in the DSX, nothing appears in the data source view. That why i ask for some help, how should i configure my URI in my DTA to be able to use the informations and construc my canevas ?