Sandbox: Difference between revisions

Revision as of 08:54, 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". }
}
}

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

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

Run query

Embedded RunQuery

Full Graph

Run this query to get the full graph

Personal Section

Test for EIMI

Du hast 0 von 391 geschafft.

@@ Line 126: / Line 126: @@
 Run this query to get the full graph
 {{Special:RunQuery/FullGraph}}
+== Personal Section ==
+Test for EIMI
+{{#get_web_data:url=http://query.graphit.ur.de/proxy/wdqs/bigdata/namespace/wdq/sparql?query=%23defaultView%3ATable%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fgraphit.ur.de%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fgraphit.ur.de%2Fprop%2Fdirect%2F%3E%0ASELECT%20DISTINCT%20%3Fcompletions%20%3Fitems%20WHERE%20%7B%0A%20%20%0A%20%20%7B%20SELECT%20(COUNT%20(DISTINCT%20%3Fcomplete)%20AS%20%3Fcompletions)%20WHERE%20%7B%0A%20%20%20%20%3Fuser%20rdfs%3Alabel%20%22%7B%7B%23username%3AMax%20Mustermann%7D%7D%22%40en.%0A%20%20%20%20wd%3AQ2113%20wdt%3AP14%2Fwdt%3AP14%20%3Fcomplete.%0A%20%20%20%20%3Fuser%20wdt%3AP12%20%3Fcomplete.%0A%20%20%7D%20%7D%0A%20%20%0A%20%20%7B%20SELECT%20(COUNT%20(DISTINCT%20%3Fitem)%20AS%20%3Fitems)%20WHERE%20%7B%0A%20%20%20%20wd%3AQ2113%20wdt%3AP14%2Fwdt%3AP14%20%3Fitem.%0A%20%20%7D%20%7D%0A%20%20%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D&format=json
+|format=json
+|use jsonpath
+|data=
+completions=$.results.bindings[0].completions.value,
+items=$.results.bindings[0].items.value,
+}}
+Du hast '''{{#external_value:completions}}''' von {{#external_value:items}} geschafft.