Courses/CGBV SS24/Graph: Difference between revisions

Revision as of 09:32, 2 May 2024

Contains queries about the graph of the "CGBV SS24" course to help debug and structure it.

All Sessions

Returns a graph containing all sessions included in the course, as well as all included topics.
Warning: touch(): Utime failed: Permission denied in /var/www/html/extensions/Widgets/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php on line 178

All existing CGBV SS24 sessions with included topics

All Categories

Returns a graph with all included in the course. See the query here

Items

Resources

Returns a table with all resources that are linked to from inside the course.

@@ Line 2: / Line 2: @@
 == All Sessions ==
-Returns a graph containing all sessions [Property:P14 included in] the course, as well as all '''included''' topics.
+Returns a graph containing all sessions '''included in''' the course, as well as all '''included''' topics.
 {{#widget:SPARQLquery|code=
 #defaultView:Graph
@@ Line 25: / Line 25: @@
 }
 |caption=All existing CGBV SS24 sessions with included topics
+}}
+== All Categories ==
+Returns a graph with all '''included in''' the course.
+See the query '''[https://tinyurl.com/yorv5zu2 here]'''
+== Items ==
+=== Resources ===
+Returns a table with all resources that are linked to from inside the course.
+{{#widget:SPARQLquery|code=
+#defaultView:Table
+PREFIX wdt: <https://graphit.ur.de/prop/direct/>
+PREFIX wd: <https://graphit.ur.de/entity/>
+SELECT DISTINCT ?item ?itemLabel ?resource ?resourceLabel ?alias ?url ?type ?typeLabel # ?resLabelLength
+WHERE {
+  wd:Q932 wdt:P14/wdt:P14 ?item.
+  ?item wdt:P21 ?resource.
+  OPTIONAL {?resource wdt:P20 ?link.
+            BIND("true" as ?url) }
+  OPTIONAL {?resource wdt:P3 ?type.}
+  OPTIONAL {?resource skos:altLabel ?alias.}
+  service wikibase:label { bd:serviceParam wikibase:language "en" }
+} ORDER BY ASC(?resourceLabel)
 }}