SPARQL for ERM/DNG Artifact Count
I have tried the SPARQL query in the following article to get an artifact count and it does not work (gives 1/0 as result). Does this work for version 7.0.2?
<o:p> </o:p>
It doesn't look like the query needs to change based on environment. So, I'm not sure why it is not working.
Any help would be appreciated.
2 answers
HI Brad
If you have Lifecycle Query Engine configured you should be able to query there, or may be able to use Report Builder to generate the query and execute a report for you.
Comments
NOTE that SPARQL for DOORS Next 6.x is different from LQE SPARQL, i.e. the DN queries in your 6.x article won't work as LQE queries - best to use Report Builder to query from LQE.
Hi Ian,
Also, I can't select a project area that is Configuration Enabled for use with the Data Warehouse. So, not sure if in a GC how I would use a SQL query.
You can only do configuration scoped reporting using the Lifecycle Query Engine scoped to a configuration data source. You cannot use Data Warehouse for this purpose.
DOORS Next provides a TRS (Tracked Resource Set - see https://oslc-op.github.io/oslc-specs/notes/trs-primer/trs-primer.html) that LQE consumes and indexes. Report Builder generates SPARQL that is executed on LQE SPARQL endpoints.
I said "so SPARQL queries no longer return useful results in 7.x." - This refers specifically to SPARQL queries to DOORS Next.
LQE still uses Jena for indexing, and yes Report Builder for a LQE or LQE with configurations data source still creates SPARQL although you normally don't need to worry about this - modifying the SPARQL is possible but then you have to manually maintain that SPARQL Query.
Data Warehouse isn't configuraiton aware. Yes it uses SQL which is normally generated automatically by Report Builder.
Basically, the easiest way to get data out of LQE is to use Report Builder to create the report from a LQE/LQE with configurations data source. RB reports can count results.