Sandbox

⚠️ 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". }
}
}

Try it!

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". }
}

Try it!

Linked RunQuery

Try running the query :D

Follow https://graphit.ur.de/wiki/Special:RunQuery/Learning_Path?Learning_Path[quiz]=Q444&_run for preloaded query

Run query

Embedded RunQuery

Item:	Q149

Run query

Full Graph

Run this query to get the full graph

Run query

Personal Section

(Test for EIMI)

Du (Max Mustermann) hast 3 von 391 Lerninhalten geschafft. <progress value="3" max="391"> 3 </progress>

3 / 391 Lerninhalten

Items used: EIMI 25/26WS (Q2113), Session (Q427)

Properties used: includes (P14), instance of (P3), depends on (P1), has completed (P12)

#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

Try it!

Items used: EIMI 25/26WS (Q2113)

Properties used: includes (P14), depends on (P1), has completed (P12)

#defaultView:Graph
PREFIX wd: <https://graphit.ur.de/entity/>
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
SELECT distinct 
?topic ?topicLabel ?rgb1 ?shape1
?dCount 
?dependency ?dependencyLabel ?rgb2 ?shape2
WHERE {
  # size the items according to their indegrees and mark all "completed" items of a user green
  
  ?user rdfs:label "Leonie"@en.

  { wd:Q2113 wdt:P14/wdt:P14 ?topic. 
    OPTIONAL { 
      ?topic wdt:P1 ?dependency 
      BIND (IF(EXISTS{?user wdt:P12 ?dependency}, "008F0E", "ffffff") as ?rgb2)
    }
  } UNION {
    # get all dependencies not directly included ( for sizing they need to be in the same column as ?topic ()
    wd:Q2113 wdt:P14/wdt:P14 ?item.
    ?item wdt:P1 ?topic.
    FILTER NOT EXISTS {  wd:Q2113 wdt:P14/wdt:P14 ?topic. } 
  }
     
  OPTIONAL {
    SELECT ?topic ?topicLabel (COUNT(DISTINCT ?pre) as ?dCount) WHERE {
      ?pre wdt:P1 ?topic.
    } GROUP BY ?topic ?topicLabel
  } # number of items that -depend-on-> ?topic 
  BIND(IF(!BOUND(?dCount), 0, ?dCount) as ?dCount).
  
  BIND (IF(EXISTS{?user wdt:P12 ?topic}, "008F0E", "ffffff") as ?rgb1)
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!