Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to extract a json / xml with the requirements of a project in DNG?

Hello,


At my company we are developing some extensions in DOORS Next Generation for a set of projects, and we would like to know how to extract the requirements so we can create different charts and graphics based on the value of their attributes (id, status, etc..). We are hosting the extensions into an Azure server, so that it reads the ".xml" of each of extension and runs the corresponding ".js" files when it loads on the DNG widget.

Currently we are working with the Reportable API, but it is messy and slow whenever it loads the extension - this way extracts all the data from a given project and later we need to apply various filters to retrieve the useful data. Our problem is that we need to particularize this for every project, as each database may contain different attributes for each artifact.

We have looked deeply into the documentation and it seems to be a way of working with "RM" calls, but we have not found a solution to make that the extension recognizes the "RM.data." instructions, like the ones shown at the code of the example available at the following link (https://jazz.net/wiki/bin/view/Main/RMExtensionsSimpleExamples702).

We have also considered to retrieve data using OSLC queries as in this video (https://www.youtube.com/watch?v=YzrVo6YM0iQ) but we still need to apply various filters to retrieve data, and therefore difficult to handle with.

Is there any other solution that would retrieve the data (for example, via SQL query) with the required filters of the attributes already applied? We have also looked at the json format link available when accessing at the Report Builder (which is designed to be coupled to IBM Engineering Lifecyle Optimization - Publisher), but the problem is that it does not update the register/report if new artifacts are created inside the requirements module.

All answers or past experiences related to this topic would be of much help. Thanks in advance.

Pablo

0 votes



2 answers

Permanent link

 Hi Pablo,


Please have a look at https://jazz.net/wiki/bin/view/Main/RRCReportableRestAPI, which have example queries that you help retrieve artifacts that are in the view(also include views having filters)

0 votes


Permanent link

Pablo, you can find the ELM Landing page at https://jazz.net/wiki/bin/view/Deployment/CLMProductAPILanding. That has links to a number of DN API pages. You should also read about OSLC - see https://open-services.net/resources/oslc-primer/ and https://docs.oasis-open-projects.org/oslc-op/core/v3.0/os/oslc-core.html. You can use OSLC discovery to find an OSLC Query Capability that you can use to find resources of interest.

Most public REST APIs are focussed around RDF (see https://www.w3.org/RDF/) not JSON. So if you want data from APIs, especially those that relate to OSLC capabilities, you should use RDF. There are no public SQL capabilities. The database schema is private, undocumented, and unsupported, and for internal use only.

So your only options are to use Reportable REST or OSLC related APIs.

0 votes

Your answer

Register or log in to post 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,930
× 1,699

Question asked: Mar 15 '23, 9:42 a.m.

Question was seen: 1,577 times

Last updated: Mar 16 '23, 5:49 a.m.

Related questions
Confirmation Cancel Confirm