https://graphit.ur.de/w/index.php?action=history&feed=atom&title=CourseQueries CourseQueries - Revision history 2026-05-12T20:59:20Z Revision history for this page on the wiki MediaWiki 1.39.1 https://graphit.ur.de/w/index.php?title=CourseQueries&diff=5763&oldid=prev Leonie: created page and added queries 2023-12-06T13:43:05Z <p>created page and added queries</p> <p><b>New page</b></p><div>{{Note|text=This page currently only works for the Course [[Item:Q468|WissArb]] }}<br /> <br /> == Course Dependencies ==<br /> This query shows the dependencies between items. The colors correspond to different categories<br /> {{#widget:SPARQLquery|code=<br /> #defaultView:Graph<br /> PREFIX wd: &lt;https://graphit.ur.de/entity/&gt;<br /> PREFIX wdt: &lt;https://graphit.ur.de/prop/direct/&gt;<br /> SELECT distinct ?topic ?topicLabel ?rgb ?dependency ?dependencyLabel ?category ?categoryLabel<br /> WHERE {<br /> {<br /> # get all categories of the course<br /> BIND (wd:Q468 as ?course). <br /> ?course wdt:P14 ?category.<br /> Minus {?category wdt:P3 wd:Q427}<br /> { SELECT ?category ?categoryLabel ?topic ?topicLabel WHERE {<br /> {<br /> ?category wdt:P14 ?topic.<br /> }<br /> }<br /> }<br /> Union<br /> # get all dependencies of the topics<br /> { SELECT ?topic ?topicLabel ?dependency ?dependencyLabel WHERE {<br /> {<br /> ?topic wdt:P1 ?dependency. <br /> } <br /> }<br /> }<br /> ?category wdt:P14 ?topic.<br /> ?topic wdt:P1 ?dependency.<br /> <br /> bind (if(?category = wd:Q472, &quot;e8fcff&quot;, # (blue) f3fdff<br /> if(?category = wd:Q473, &quot;e3ffd9&quot;, # (green) <br /> if(?category = wd:Q474, &quot;ffeec2&quot;, # (orange)<br /> if(?category = wd:Q475, &quot;DCCDE0&quot;, # (purple) <br /> if(?category = wd:Q476, &quot;F9DCDF&quot;, # (pink)<br /> if(?category = wd:Q477, &quot;E7DEDA&quot;, # (brown) <br /> if(?category = wd:Q478, &quot;ECEDFF&quot;, # (lavender)<br /> &quot;FFFFFF&quot; ))))))) as ?rgb).<br /> <br /> SERVICE wikibase:label { bd:serviceParam wikibase:language &quot;[AUTO_LANGUAGE],en&quot;. }<br /> }<br /> }<br /> }}<br /> <br /> == Course Categories ==<br /> This query shows the different categories in the course and what items belong to them.<br /> {{#widget:SPARQLquery|code=<br /> #defaultView:Graph<br /> PREFIX wd: &lt;https://graphit.ur.de/entity/&gt;<br /> PREFIX wdt: &lt;https://graphit.ur.de/prop/direct/&gt;<br /> SELECT distinct <br /> ?category ?categoryLabel ?topic ?topicLabel ?rgb <br /> WHERE {<br /> BIND (wd:Q468 as ?course). <br /> ?course wdt:P14 ?category.<br /> Minus {?category wdt:P3 wd:Q427}<br /> BIND (rdf:type as ?id) <br /> ?category wdt:P14 ?topic.<br /> <br /> # Color coding <br /> bind (if(?category = wd:Q472, &quot;e8fcff&quot;, # (blue)<br /> if(?category = wd:Q473, &quot;e3ffd9&quot;, # (green) <br /> if(?category = wd:Q474, &quot;ffeec2&quot;, # (orange)<br /> if(?category = wd:Q475, &quot;DCCDE0&quot;, # (purple) <br /> if(?category = wd:Q476, &quot;F9DCDF&quot;, # (pink)<br /> if(?category = wd:Q477, &quot;E7DEDA&quot;, # (brown) <br /> if(?category = wd:Q478, &quot;ECEDFF&quot;, # (lavender)<br /> &quot;FFFFFF&quot; ))))))) as ?rgb).<br /> <br /> SERVICE wikibase:label { bd:serviceParam wikibase:language &quot;[AUTO_LANGUAGE],en&quot;. }<br /> }<br /> }}</div> Leonie