Sandbox: Difference between revisions
(→Personal Section: add completion timeline query for Q2113 (EIMI 25WS)) |
(→Personal Section: add query for progress graph) |
||
| Line 162: | Line 162: | ||
} | } | ||
|caption=Timeline of all your ({{#username:Max Mustermann}}) completed items for EIMI 25/26 WS | |caption=Timeline of all your ({{#username:Max Mustermann}}) completed items for EIMI 25/26 WS | ||
}} | |||
{{SPARQL|query= | |||
#defaultView:Graph | |||
PREFIX wd: <https://graphit.ur.de/entity/> | |||
PREFIX wdt: <https://graphit.ur.de/prop/direct/> | |||
SELECT distinct ?item ?itemLabel ?shape1 ?rgb1 | |||
?dependency ?dependencyLabel ?rgb2 ?shape2 | |||
WHERE { | |||
wd:Q2113 wdt:P14 ?session. | |||
?session wdt:P3 wd:Q427. | |||
?session wdt:P14 ?item. | |||
?user rdfs:label "{{#username:Max Mustermann}}"@en. | |||
OPTIONAL{ | |||
?item wdt:P1 ?dependency. | |||
?session wdt:P14 ?dependency. | |||
BIND (IF(EXISTS{?user wdt:P12 ?dependency}, "008F0E", "ffffff") as ?rgb2) | |||
BIND (IF(EXISTS{?user wdt:P12 ?dependency}, "dot", "ellipse") as ?shape2) | |||
} | |||
BIND (IF(EXISTS{?user wdt:P12 ?item}, "008F0E", "ffffff") as ?rgb1) | |||
BIND (IF(EXISTS{?user wdt:P12 ?item}, "dot", "ellipse") as ?shape1) | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} LIMIT 500 | |||
| caption=Alle Items des Kurses EIMI 25WS. Grün markierte Items, sind von dir "completed" | |||
}} | }} | ||
Revision as of 12:25, 28 October 2025
⚠️ A test text
External Data
Info for Q654:
- Name: neon
- Symbol: Ne
- Atomic number: 10
- Year discovered: 1898
- Discoverers: Morris Travers, William Ramsay,
via: https://discoursedb.org/wiki/Wikidata_querying_demo
Anzahl Items: 2640
Course Query
Items used: Wissenschaftliches Arbeiten 23/24WS (Q468), Session (Q427), Instrumente und Methoden (Q472), Was ist Wissenschaft (Q473), Ablauf Bachelorarbeit (Q474), Statistik (Q475), Wissenschaftliches Schreiben (Q476), Studiendesign und -durchführung (Q477), Literaturrecherche (Q478)
Properties used: includes (P14), instance of (P3), depends on (P1)
#defaultView:Graph
PREFIX wd: <https://graphit.ur.de/entity/>
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
SELECT distinct ?topic ?topicLabel ?rgb ?dependency ?dependencyLabel ?category ?categoryLabel
WHERE {
{
# get all categories of the course
BIND (wd:Q468 as ?course).
?course wdt:P14 ?category.
Minus {?category wdt:P3 wd:Q427}
{ SELECT ?category ?categoryLabel ?topic ?topicLabel WHERE {
{
?category wdt:P14 ?topic.
}
}
}
Union
# get all dependencies of the topics
{ SELECT ?topic ?topicLabel ?dependency ?dependencyLabel WHERE {
{
?topic wdt:P1 ?dependency.
}
}
}
?category wdt:P14 ?topic.
?topic wdt:P1 ?dependency.
bind (if(?category = wd:Q472, "e8fcff", # (blue) f3fdff
if(?category = wd:Q473, "e3ffd9", # (green)
if(?category = wd:Q474, "ffeec2", # (orange)
if(?category = wd:Q475, "DCCDE0", # (purple)
if(?category = wd:Q476, "F9DCDF", # (pink)
if(?category = wd:Q477, "E7DEDA", # (brown)
if(?category = wd:Q478, "ECEDFF", # (lavender)
"FFFFFF" ))))))) as ?rgb).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
}
Items used: Wissenschaftliches Arbeiten 23/24WS (Q468), Session (Q427), Instrumente und Methoden (Q472), Was ist Wissenschaft (Q473), Ablauf Bachelorarbeit (Q474), Statistik (Q475), Wissenschaftliches Schreiben (Q476), Studiendesign und -durchführung (Q477), Literaturrecherche (Q478)
Properties used: includes (P14), instance of (P3)
#defaultView:Graph
PREFIX wd: <https://graphit.ur.de/entity/>
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
SELECT distinct
?category ?categoryLabel ?topic ?topicLabel ?rgb
WHERE {
BIND (wd:Q468 as ?course).
?course wdt:P14 ?category.
Minus {?category wdt:P3 wd:Q427}
BIND (rdf:type as ?id)
?category wdt:P14 ?topic.
# Color coding
bind (if(?category = wd:Q472, "e8fcff", # (blue) f3fdff
if(?category = wd:Q473, "e3ffd9", # (green)
if(?category = wd:Q474, "ffeec2", # (orange)
if(?category = wd:Q475, "DCCDE0", # (purple)
if(?category = wd:Q476, "F9DCDF", # (pink)
if(?category = wd:Q477, "E7DEDA", # (brown)
if(?category = wd:Q478, "ECEDFF", # (lavender)
"FFFFFF" ))))))) as ?rgb).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Linked RunQuery
Follow https://graphit.ur.de/wiki/Special:RunQuery/Learning_Path?Learning_Path[quiz]=Q444&_run for preloaded query
Embedded RunQuery
Full Graph
Run this query to get the full graph
Personal Section
(Test for EIMI)
Du (Max Mustermann) hast 0 von 391 Lerninhalten geschafft.
<progress value="0" max="391"> 0 </progress>
Timeline of all your (Max Mustermann) completed items for EIMI 25/26 WS
#defaultView:Graph
PREFIX wd: <https://graphit.ur.de/entity/>
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
SELECT distinct ?item ?itemLabel ?shape1 ?rgb1
?dependency ?dependencyLabel ?rgb2 ?shape2
WHERE {
wd:Q2113 wdt:P14 ?session.
?session wdt:P3 wd:Q427.
?session wdt:P14 ?item.
?user rdfs:label "Max Mustermann"@en.
OPTIONAL{
?item wdt:P1 ?dependency.
?session wdt:P14 ?dependency.
BIND (IF(EXISTS{?user wdt:P12 ?dependency}, "008F0E", "ffffff") as ?rgb2)
BIND (IF(EXISTS{?user wdt:P12 ?dependency}, "dot", "ellipse") as ?shape2)
}
BIND (IF(EXISTS{?user wdt:P12 ?item}, "008F0E", "ffffff") as ?rgb1)
BIND (IF(EXISTS{?user wdt:P12 ?item}, "dot", "ellipse") as ?shape1)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} LIMIT 500
