Courses/CGBV SS24/Graph: Difference between revisions
(→Resources: update with second query) |
m (→All Categories: fix typo) |
||
Line 28: | Line 28: | ||
== All Categories == | == All Categories == | ||
Returns a graph with all '''included in''' the course. | Returns a graph with all categories '''included in''' the course. | ||
See the query '''[https://tinyurl.com/yorv5zu2 here]''' | See the query '''[https://tinyurl.com/yorv5zu2 here]''' | ||
Revision as of 07:16, 3 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.
All Categories
Returns a graph with all categories included in the course. See the query here
Items
Resources
All Resources
Returns a table with all resources that are linked to from inside the course.
Items used: CGBV 24SS (Q932)
Properties used: includes (P14), resource (P21), url (P20), instance of (P3)
#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)
Items without Resources
Returns a table with all items in the CGBV 24SS course, that don't link to a resource.