DebugQueries - Revision history

Leonie: /* Item overlaps */ fix link

2025-04-22T12:07:21Z

Item overlaps: fix link

← Older revision		Revision as of 12:07, 22 April 2025
Line 492:		Line 492:
	Queries that check for overlaps between courses.		Queries that check for overlaps between courses.
	== Item overlaps ==		== Item overlaps ==
	'''Returns the number of items [[~~Proprerty~~:P14\|included]] in a [[Item:Q427\|Session]] of a course, and the number of items that are [[Proprerty:P14\|included]] in [[Item:Q427\|Sessions]] of both courses.		'''Returns the number of items [[Property:P14\|included]] in a [[Item:Q427\|Session]] of a course, and the number of items that are [[Proprerty:P14\|included]] in [[Item:Q427\|Sessions]] of both courses.

	{{SPARQL2\|query=		{{SPARQL2\|query=

Leonie: /* Only Categories */ spelling

2025-03-11T09:03:19Z

Only Categories: spelling

← Older revision		Revision as of 09:03, 11 March 2025
Line 327:		Line 327:

	=== Only Categories ===		=== Only Categories ===
	'''Returns all items, that are part of a course, but are only [[Property:P14\|included]] in a category.''' This means, that the items being returned are part of category, that a course includes, but aren't included in a session of that course.		'''Returns all items, that are part of a course, but are only [[Property:P14\|included]] in a category.''' This means, that the items being returned are part of a category, that a course includes, but aren't included in a session of that course.

	{{SPARQL2\|query=		{{SPARQL2\|query=

Leonie: /* Only Categories */ add further explanation

2025-03-11T09:02:52Z

Only Categories: add further explanation

← Older revision		Revision as of 09:02, 11 March 2025
Line 327:		Line 327:

	=== Only Categories ===		=== Only Categories ===
	'''Returns all items, that are part of a course, but are only [[Property:P14\|included]] in a category.'''		'''Returns all items, that are part of a course, but are only [[Property:P14\|included]] in a category.''' This means, that the items being returned are part of category, that a course includes, but aren't included in a session of that course.

	{{SPARQL2\|query=		{{SPARQL2\|query=

Leonie: /* Sessions */ add check query

2025-03-11T08:59:31Z

Sessions: add check query

@@ Line 388: / Line 388: @@
 == Sessions ==
 '''Returns all [[Item:Q427|Sessions]], all Items that they include and the [[Item:Q170|Course]] that includes them.''' Excludes all items that are resources.
 {{SPARQL2|query=
 #defaultView:Graph
@@ Line 405: / Line 406: @@
 === Not in Sessions ===
 '''Returns all items that are not (yet) part of a [[Item:Q427|Session]].'''
 {{#widget:SPARQLquery|code=
 #defaultView:Table
@@ Line 416: / Line 418: @@
    service wikibase:label { bd:serviceParam wikibase:language "en" }
+}
 }}

Leonie: /* Courses */ add general section of courses

2025-03-11T08:55:36Z

Courses: add general section of courses

@@ Line 420: / Line 420: @@
 ----
-= Course Overlaps =
+= Courses =
 Queries that check for overlaps between courses.
 == Item overlaps ==

Leonie: /* Course Overlaps */ add section on course overlaps with queries

2025-03-11T08:50:50Z

Course Overlaps: add section on course overlaps with queries

← Older revision		Revision as of 08:50, 11 March 2025
Line 419:		Line 419:

	----		----

			= Course Overlaps =
			Queries that check for overlaps between courses.
			== Item overlaps ==
			'''Returns the number of items [[Proprerty:P14\|included]] in a [[Item:Q427\|Session]] of a course, and the number of items that are [[Proprerty:P14\|included]] in [[Item:Q427\|Sessions]] of both courses.

			{{SPARQL2\|query=
			#defaultView:Table
			#title:Overlaps of two courses
			PREFIX wd: <https://graphit.ur.de/entity/>
			PREFIX wdt: <https://graphit.ur.de/prop/direct/>
			SELECT DISTINCT
			?course1 ?course1Label ?course2 ?course2Label ?items1 ?items2 ?overlapItems
			WHERE {
			# List of courses to compare
			VALUES ?course1 {wd:Q932 wd:1330 wd:Q1022}
			VALUES ?course2 {wd:Q932 wd:Q1330 wd:Q1022}

			# count number of items in course1
			{ SELECT ?course1 ?course1Label (COUNT(DISTINCT ?item) as ?items1) WHERE {
			?course1 wdt:P14 ?session.
			?session wdt:P3 wd:Q427; wdt:P14 ?item.
			} GROUP BY ?course1 ?course1Label
			}

			# count number of items in course2
			{ SELECT ?course2 ?course2Label (COUNT(DISTINCT ?item) as ?items2) WHERE {
			?course2 wdt:P14 ?session.
			?session wdt:P3 wd:Q427; wdt:P14 ?item.
			} GROUP BY ?course2 ?course2Label
			}

			# overlapped items
			OPTIONAL {
			{ SELECT ?course1 ?course1Label ?course2 ?course2Label (COUNT(DISTINCT ?item) as ?overlapItems) WHERE {
			?course1 wdt:P14 ?session1.
			?session1 wdt:P3 wd:Q427; wdt:P14 ?item.
			?course2 wdt:P14 ?session2.
			?session2 wdt:P3 wd:Q427; wdt:P14 ?item.
			} GROUP BY ?course1 ?course1Label ?course2 ?course2Label }
			}
			BIND(IF (BOUND(?overlapItems), ?overlapItems, 0) as ?overlapItems)

			SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
			}
			}}

			== List of overlap items==
			'''Returns a list of all items [[Property:P14\|included]] two courses.''' This means, that an item listed here is part of at least one session of each course.

			{{SPARQL2\|query=
			#defaultView:Table
			#title:Get all items included in sessions of both courses
			PREFIX wdt: <https://graphit.ur.de/prop/direct/>
			PREFIX wd: <https://graphit.ur.de/entity/>
			select distinct
			?item ?itemLabel
			?session1 ?session1Label ?session2 ?session2Label
			where {
			# bind the courses
			BIND(wd:Q932 as ?course1)
			BIND(wd:Q1330 as ?course2)

			?course1 wdt:P14 ?session1.
			?session1 wdt:P3 wd:Q427; wdt:P14 ?item.
			?course2 wdt:P14 ?session2.
			?session2 wdt:P3 wd:Q427; wdt:P14 ?item.

			service wikibase:label { bd:serviceParam wikibase:language "en".}
			} ORDER BY ?itemLabel
			}}

			== Dependency Overlaps ==
			'''Returns a list of the overlaps between dependencies of two courses.''' <span style="color: green">''?dependency1''</span> are all dependencies of items included in sessions of <span style="color: green">''?course1''</span>, that are only discussed in sessions of <span style="color: green">''?course2''</span> aka ''d(c1 → c2)''. Vice versa for <span style="color: green">''?dependency2''</span>.

			{{SPARQL2\|query=
			#defaultView:Table
			#title:Dependency overlaps of two courses
			PREFIX wd: <https://graphit.ur.de/entity/>
			PREFIX wdt: <https://graphit.ur.de/prop/direct/>
			SELECT DISTINCT
			?dependency1 ?dependency1Label # dependencies of course1 only "included" in course2
			?dependency2 ?dependency2Label # dependencies of course2 only "included" in course1
			WHERE {
			# List of courses to compare
			BIND(wd:Q932 as ?course1) # CGBV
			BIND(wd:Q1330 as ?course2) # MMT

			{ # get dependencies of course1 only in course2
			?course1 wdt:P14 ?session1.
			?session1 wdt:P3 wd:Q427; wdt:P14 ?item1.
			?item1 wdt:P1 ?dependency1.
			?course2 wdt:P14 ?session2.
			?session2 wdt:P3 wd:Q427; wdt:P14 ?dependency1.
			FILTER NOT EXISTS {
			?dependency1 ^wdt:P14 ?session.
			?session wdt:P3 wd:Q427.
			?session ^wdt:P14 ?course1.
			}
			}
			UNION
			{ # get dependencies of course2 only in course1
			?course2 wdt:P14 ?session2.
			?session2 wdt:P3 wd:Q427; wdt:P14 ?item2.
			?item2 wdt:P1 ?dependency2.
			?course1 wdt:P14 ?session1.
			?session1 wdt:P3 wd:Q427; wdt:P14 ?dependency2.
			FILTER NOT EXISTS {
			?dependency2 ^wdt:P14 ?session.
			?session wdt:P3 wd:Q427.
			?session ^wdt:P14 ?course2.
			} }
			SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
			} ORDER BY ?dependency2Label
			}}

	= Miscellaneous =		= Miscellaneous =

Leonie: /* = */ fix syntax

2025-03-11T08:24:57Z

=: fix syntax

← Older revision		Revision as of 08:24, 11 March 2025
Line 385:		Line 385:
	}		}
	}}		}}

	~~===~~

	== Sessions ==		== Sessions ==

Leonie: /* Categories */ add/update queries for checking items in categories

2025-03-11T08:24:22Z

Categories: add/update queries for checking items in categories

@@ Line 293: / Line 293: @@
 == Categories ==
 '''Returns all [[Item:Q169|Categories]] and their sub-items.'''
 {{SPARQL2|query=
 #defaultView:Graph
@@ Line 306: / Line 307: @@
 === No Categories ===
-'''Returns all items, that are are [[Property:P14|Included]] in a course, but not a category.'''
+'''Returns all items, that are are [[Property:P14|included]] in a course, but not a category.'''
 {{SPARQL2|query=
 #defaultView:Table
@@ Line 312: / Line 314: @@
 PREFIX wdt: <https://graphit.ur.de/prop/direct/>
 PREFIX wd: <https://graphit.ur.de/entity/>
-select distinct ?item ?itemLabel # ?category ?categoryLabel
+select distinct ?course ?courseLabel ?item ?itemLabel # ?category ?categoryLabel
+{
    ?course wdt:P3 wd:Q170.
    ?course wdt:P14/wdt:P14 ?item.
    FILTER NOT EXISTS { ?category wdt:P3 wd:Q169; wdt:P14 ?item }
    MINUS {?item wdt:P20 ?url} # remove ressources
    service wikibase:label { bd:serviceParam wikibase:language "en" }
 } LIMIT 100
 }}
 == Sessions ==

Leonie: /* Not in Sessions */ make subsection

2025-03-11T08:15:58Z

Not in Sessions: make subsection

← Older revision		Revision as of 08:15, 11 March 2025
Line 339:		Line 339:
	}}		}}

	== Not in Sessions ==		=== Not in Sessions ===
	'''Returns all items that are not (yet) part of a [[Item:Q427\|Session]].'''		'''Returns all items that are not (yet) part of a [[Item:Q427\|Session]].'''
	{{#widget:SPARQLquery\|code=		{{#widget:SPARQLquery\|code=

Leonie: /* Categories */ add query

2025-03-10T10:33:36Z

Categories: add query

@@ Line 303: / Line 303: @@
    service wikibase:label { bd:serviceParam wikibase:language "en" }
+}
 }}