Because the place available for a Open Social Widget is limited we will elaborate today a basic website with SPARQL Queries and the results are displayed as Tables, Maps, Tree, Line, Charts, Graphs, List …what ever you want. The focus is on learning SPARQL with RELM/LQE.
The real beauty is the interactivity you can have with “D3ForceGraph”…but try it yourself.
All you need is…love(Beatles)…no…we need the following files and structure. 🙂
Extract the ZIP File to <CLM server>/tomcat/webapps/extensions at your CLM Server.
After that step, start your favorit Webbrowser and use the URL: https://clmserver:9443/extensions/querySparql/query.html
You should see the following picture:
The results as D3ForceGraph:
Here is a short overview what kind of graphic is possible with the SPARQL results:
The HTML is really small, the main part is the SPARQL Query:
<!DOCTYPE HTML>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="UTF-8"/>
<link rel="stylesheet" href="css/querySparql.css" type="text/css" media="screen" />
<script type="text/javascript" src="lib/jquery-1.10.1.js"></script>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript" src="lib/sgvizler.js"></script>
<script type="text/javascript">
$(document).ready(function () {
sgvizler.defaultEndpointURL ("https://ssejtsserver:9443/lqe/sparql");
sgvizler.defaultQuery(
"PREFIX dcterms: <http://purl.org/dc/terms/> \n"+
"PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> \n"+
"PREFIX oslc: <http://open-services.net/ns/core#> \n"+
"PREFIX oslc_cm: <http://open-services.net/ns/cm#> \n"+
"PREFIX oslc_qm: <http://open-services.net/ns/qm#> \n"+
"SELECT ?cm_shortTitle ?cm_title ?cm_uri ?status ?qm_title ?qm_uri \n"+
"WHERE {\n" +
"?cm_uri \n"+
" oslc:shortTitle ?cm_shortTitle ; \n"+
" dcterms:title ?cm_title ; \n"+
" dcterms:modified ?modified ; \n"+
" oslc_cm:status ?status ; \n"+
" oslc_cm:testedByTestCase ?qm_uri . \n"+
"?qm_uri \n"+
" dcterms:title ?qm_title . \n"+
"} \n"+
" ORDER BY ASC(?cm_shortTitle)" );
sgvizler.formDraw();});
</script>
</head>
<body>
</body>
</html>
Steve Blog 
#1 by Todd Dunnavant on 14/07/2017 - 20:18
Hi, Stefan, you’ve done some truly excellent work with OSLC, SPARQL, and the CM capabilities of the CE tools. Thanks for all your contributions!