DebugQueries: Difference between revisions
m (→Sessions) |
(→Sessions: addes edge labels) |
||
| Line 245: | Line 245: | ||
{{#widget:SPARQLquery|code= | {{#widget:SPARQLquery|code= | ||
#defaultView:Graph | #defaultView:Graph | ||
# via: https://phabricator.wikimedia.org/T168715 | |||
PREFIX wdt: <https://graphit.ur.de/prop/direct/> | PREFIX wdt: <https://graphit.ur.de/prop/direct/> | ||
PREFIX wd: <https://graphit.ur.de/entity/> | PREFIX wd: <https://graphit.ur.de/entity/> | ||
select distinct ?item ?itemLabel ?session ?sessionLabel ?course ?courseLabel | select distinct ?item ?itemLabel ?session ?sessionLabel ?course ?courseLabel ?edgeLabel | ||
where { | where { | ||
| Line 253: | Line 254: | ||
MINUS {?item wdt:P20 ?url.} | MINUS {?item wdt:P20 ?url.} | ||
MINUS {?session wdt:P3 wd:Q162.} | MINUS {?session wdt:P3 wd:Q162.} | ||
?property a wikibase:Property; | |||
wikibase:directClaim wdt:P14. | |||
service wikibase:label { bd:serviceParam wikibase:language "en" } | service wikibase:label { bd:serviceParam wikibase:language "en". | ||
?item rdfs:label ?itemLabel. | |||
?session rdfs:label ?sessionLabel. | |||
?property rdfs:label ?edgeLabel.} | |||
} | } | ||
}} | }} | ||
Revision as of 07:57, 26 August 2023
This page contains several SPARQL-Queries to help debug the graph.
Useful Queries
A List of accessible queries, that are useful to understand the structure of the graph and identify problems, such as missing links. They can be changed as needed.
Backlinks
A query that finds all backlinks to a specific item.
Items used: Polygons (Q108)
#defaultView:Graph
PREFIX wdt: <https://graphit.ur.de/prop/direct/>
PREFIX wd: <https://graphit.ur.de/entity/>
select distinct ?subject ?subjectLabel ?item ?itemLabel { # ?property ?propertyLabel
values (?item) {(wd:Q108)}
?subject ?predicate ?item .
?property wikibase:directClaim ?predicate
service wikibase:label { bd:serviceParam wikibase:language "en" }
}
Missing Properties
Resources
No Resources
Returns all Items, that don't have any resource that they link to.
Unlinked Resources
Returns all resources, that have not been linked to any item yet.
Instance-less Resources
Returns all Resources that have no Property instance of.
No Subclass
Returns all Items, that don't have a property subclass.
No Dependencies
Returns all Items, that don't link any other items as dependency.
These items don't have a property depends on. This could mean, that they are a goal.
No Links
Returns all Graph-items, that don't link to any other items and are not linked to in return. Does not return items used to structure the graph, such as Essential
No Description
Returns all items without a description.
No Instance
Returns all items that have and their Property instance of. Shows which items are not, e.g. Applications.
Access to Items
Queries that find items with specific proterties for an easier overview.
Quizzes
Returns all Items that are Quizzes.
Resources
Returns all Resources.
Labels
Returns the items with the longest Labels (50). Doesn't return Resources.
Here it could be useful to find shorter alias for the items, for easier viewing in a visualisation.
Orphans
Returns all items that have no Properties. Excludes all Property-Items, such as depends on
Sessions
Returns all Sessions, all Items that they include and the Course that includes them. Excludes all items that are resources.
Miscellaneous
Circle Dependency
Returns items that link back towards each other, creating a circle dependency.