Generating reports using SPARQL

1 PREFIX sh: <http://www.w3.org/ns/shacl#>
2 SELECT DISTINCT ?msg ?test WHERE {
3   ?x a sh:ValidationResult .
4   ?x sh:resultMessage ?msg .
5   ?x sh:sourceConstraint ?test .
6 }

 1 PREFIX sh: <http://www.w3.org/ns/shacl#>
 2 PREFIX s: <http://example.com/Quantcast/shapes#>
 3 SELECT DISTINCT ?gdpr ?result ?msg WHERE {
 4   ?test s:linkToGDPR ?gdpr .
 5   BIND(NOT EXISTS {
 6     ?x sh:sourceConstraint ?test .
 7     } as ?result )
 8   OPTIONAL {
 9     ?x sh:sourceConstraint ?test .
10     ?x sh:resultMessage ?msg .
11     }
12 } ORDER BY ?gdpr

 1 PREFIX c: <http://example.com/Quantcast/shapes#>
 2 PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
 3 PREFIX sh: <http://www.w3.org/ns/shacl#>
 4 PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
 5 SELECT DISTINCT ?name ?test ?gdpr ?result ?node ?msg
 6 WHERE {
 7   ?x a c:Constraint .
 8   ?x sh:name ?name .
 9   BIND(IF(EXISTS{
10     ?x a c:AutomaticallyCheckedConstraint}, 
11     "Automatic"^^xsd:string, "Manual"^^xsd:string)
12     as ?test)
13   OPTIONAL { ?x c:linkToGDPR ?gdpr }
14   BIND(IF(EXISTS{
15     ?y sh:sourceConstraint ?x},
16     "FAIL"^^xsd:string, "PASS"^^xsd:string)
17     as ?result)
18   OPTIONAL {
19     FILTER EXISTS { ?y sh:sourceConstraint ?x }
20     ?y sh:focusNode ?node .
21     ?y sh:resultMessage ?msg .
22   }
23 } ORDER BY ?name