Courses/HCI 26SS - Revision history

IvanDR200: /* Timetable */

2026-05-12T13:15:57Z

Timetable

← Older revision		Revision as of 13:15, 12 May 2026
Line 177:		Line 177:
	</div>		</div>

	{{Note\|type=info\|text=[https://~~tinyurl~~.~~com~~/~~2b734b8r~~ Query], die anzeigt, wie viele Items jede Session enthält}}		{{Note\|type=info\|text=[https://query.graphit.ur.de/embed.html#%23defaultView%3ATable%0A%23title%3ANumber%20of%20Items%20in%20Sessions%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%0A%0ASELECT%20DISTINCT%20%3Fsession%20%3FsessionLabel%20%3Fitems%20%20%0AWHERE%20%7B%0A%20%20wd%3AQ2943%20wdt%3AP14%20%3Fsession.%0A%20%20%3Fsession%20wdt%3AP3%20wd%3AQ427.%0A%20%20%3Fsession%20wdt%3AP19%20%3Fdate%0A%20%20%0A%0A%20OPTIONAL%20%0A%20%7B%20%7B%20SELECT%20%3Fsession%20%3FsessionLabel%20%28COUNT%28DISTINCT%20%3Fitem%29%20as%20%3Fitems%29%20WHERE%20%7B%0A%20%20%20%20%20%20%3Fsession%20wdt%3AP14%20%3Fitem.%0A%20%20%20%20%7D%20GROUP%20BY%20%3Fsession%20%3FsessionLabel%0A%20%20%7D%20%7D%0A%20%20%0A%20%20BIND%28IF%28BOUND%28%3Fitems%29%2C%20%3Fitems%2C%200%29%20as%20%3Fitems%29.%0A%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%20ORDER%20BY%20ASC%28%3Fdate%29%20 Query], die anzeigt, wie viele Items jede Session enthält}}

IvanDR200: /* Timetable */

2026-05-12T13:12:51Z

Timetable

← Older revision		Revision as of 13:12, 12 May 2026
Line 161:		Line 161:
	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 ?Datum ?~~Session~~ ?~~SessionLabel~~ # ?Inhalte ?InhalteLabel		select distinct ?Datum ?Lab ?LabLabel # ?Inhalte ?InhalteLabel
	where {		where {
	wd:Q2943 wdt:P14 ?~~Session~~.		wd:Q2943 wdt:P14 ?Lab.
	?~~Session~~ wdt:P3 wd:~~Q427~~.		?Lab wdt:P3 wd:Q2939.
	?~~Session~~ wdt:P19 ?Datum.		?Lab wdt:P19 ?Datum.
	# OPTIONAL {?Session wdt:P14 ?Inhalte.}		# OPTIONAL {?Session wdt:P14 ?Inhalte.}

	~~# Get the amount of eng alias found for an item~~
	~~{SELECT ?Session (COUNT(?alias) AS ?aliasCount) WHERE {~~
	~~?Session skos:altLabel ?alias.~~
	~~FILTER (LANG(?alias) = "en").~~
	~~} GROUP BY ?Session~~
	}

	~~# re-get the alias as ?SessionLabel (for the links)~~
	~~?Session skos:altLabel ?SessionLabel.~~
	~~FILTER (LANG(?SessionLabel) = "de").~~
	~~FILTER (contains(str(?SessionLabel), "Ü:")). # nur Übungen~~

	~~# Filter out all descriptive alias (aka. don't use a "[Course] - 01a"-type label)~~
	~~OPTIONAL {~~
	~~?Session skos:altLabel ?alt.~~
	~~FILTER (!regex(?alt, "MMT", "i"))~~
	~~FILTER (LANG(?alt) = "en") # Ensure the alias is in English~~
	~~} # and save them in a different var~~

	~~# Default to the normal alias, but use the descriptiv one if it exists~~
	~~BIND(IF (?aliasCount > 1, ?alt, ?alias) as ?SessionLabel)~~

	service wikibase:label { bd:serviceParam wikibase:language "en".}		service wikibase:label { bd:serviceParam wikibase:language "en".}
	} ~~ORDER BY DESC(?SessionLabel)~~		}
	LIMIT 50		LIMIT 50
	\| height=35em		\| height=35em

IvanDR200: /* Timetable */

2026-05-12T12:34:10Z

Timetable

← Older revision		Revision as of 12:34, 12 May 2026
Line 140:		Line 140:
	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 ?Datum ?Lecture ?~~SessionLabel~~ # ?Inhalte ?InhalteLabel		select distinct ?Datum ?Lecture ?LectureLabel # ?Inhalte ?InhalteLabel
	where {		where {
	wd:Q2943 wdt:P14 ?Lecture.		wd:Q2943 wdt:P14 ?Lecture.

IvanDR200: /* Timetable */

2026-05-12T12:33:52Z

Timetable

← Older revision		Revision as of 12:33, 12 May 2026
Line 119:		Line 119:
	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 ?Datum ?Lecture ?~~SessionLabel~~ # ?Inhalte ?InhalteLabel		select distinct ?Datum ?Lecture ?LectureLabel # ?Inhalte ?InhalteLabel
	where {		where {
	wd:Q2943 wdt:P14 ?Lecture.		wd:Q2943 wdt:P14 ?Lecture.

IvanDR200: /* Timetable */

2026-05-12T12:30:33Z

Timetable

← Older revision		Revision as of 12:30, 12 May 2026
Line 140:		Line 140:
	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 ?Datum ?~~Session~~ ?SessionLabel # ?Inhalte ?InhalteLabel		select distinct ?Datum ?Lecture ?SessionLabel # ?Inhalte ?InhalteLabel
	where {		where {
	wd:Q2943 wdt:P14 ?~~Session~~.		wd:Q2943 wdt:P14 ?Lecture.
	?~~Session~~ wdt:P3 wd:~~Q427~~.		?Lecture wdt:P3 wd:Q421.
	?~~Session~~ wdt:P19 ?Datum.		?Lecture wdt:P19 ?Datum.
	# OPTIONAL {?Session wdt:P14 ?Inhalte.}		# OPTIONAL {?Session wdt:P14 ?Inhalte.}

	~~# Get the amount of eng alias found for an item~~
	~~{SELECT ?Session (COUNT(?alias) AS ?aliasCount) WHERE {~~
	~~?Session skos:altLabel ?alias.~~
	~~FILTER (LANG(?alias) = "en").~~
	~~} GROUP BY ?Session~~
	}

	~~# re-get the alias as ?SessionLabel (for the links)~~
	~~?Session skos:altLabel ?SessionLabel.~~
	~~FILTER (LANG(?SessionLabel) = "de").~~
	~~FILTER (!contains(str(?SessionLabel), "Ü:")). # nur VL~~

	~~# Filter out all descriptive alias (aka. don't use a "[Course] - 01a"-type label)~~
	~~OPTIONAL {~~
	~~?Session skos:altLabel ?alt.~~
	~~FILTER (!regex(?alt, "MMT", "i"))~~
	~~FILTER (LANG(?alt) = "en") # Ensure the alias is in English~~
	~~} # and save them in a different var~~

	~~# Default to the normal alias, but use the descriptiv one if it exists~~
	~~BIND(IF (?aliasCount > 1, ?alt, ?alias) as ?SessionLabel)~~

	service wikibase:label { bd:serviceParam wikibase:language "en".}		service wikibase:label { bd:serviceParam wikibase:language "en".}
	} ~~ORDER BY DESC(?SessionLabel)~~		}
	LIMIT 50		LIMIT 50
	\|height=35em		\|height=35em

IvanDR200: /* Timetable */

2026-05-12T12:27:33Z

Timetable

← Older revision		Revision as of 12:27, 12 May 2026
Line 119:		Line 119:
	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 ?Datum ?~~Session~~ ?SessionLabel # ?Inhalte ?InhalteLabel		select distinct ?Datum ?Lecture ?SessionLabel # ?Inhalte ?InhalteLabel
	where {		where {
	wd:Q2943 wdt:P14 ?~~Session~~.		wd:Q2943 wdt:P14 ?Lecture.
	?~~Session~~ wdt:P3 wd:~~Q427~~.		?Lecture wdt:P3 wd:Q421.
	?~~Session~~ wdt:P19 ?Datum.		?Lecture wdt:P19 ?Datum.
	# OPTIONAL {?Session wdt:P14 ?Inhalte.}		# OPTIONAL {?Session wdt:P14 ?Inhalte.}

IvanDR200 at 12:24, 12 May 2026

2026-05-12T12:24:03Z

← Older revision		Revision as of 12:24, 12 May 2026
Line 142:		Line 142:
	select distinct ?Datum ?Session ?SessionLabel # ?Inhalte ?InhalteLabel		select distinct ?Datum ?Session ?SessionLabel # ?Inhalte ?InhalteLabel
	where {		where {
	wd:~~Q1986~~ wdt:P14 ?Session.		wd:Q2943 wdt:P14 ?Session.
	?Session wdt:P3 wd:Q427.		?Session wdt:P3 wd:Q427.
	?Session wdt:P19 ?Datum.		?Session wdt:P19 ?Datum.
Line 185:		Line 185:
	select distinct ?Datum ?Session ?SessionLabel # ?Inhalte ?InhalteLabel		select distinct ?Datum ?Session ?SessionLabel # ?Inhalte ?InhalteLabel
	where {		where {
	wd:~~Q1986~~ wdt:P14 ?Session.		wd:Q2943 wdt:P14 ?Session.
	?Session wdt:P3 wd:Q427.		?Session wdt:P3 wd:Q427.
	?Session wdt:P19 ?Datum.		?Session wdt:P19 ?Datum.

IvanDR200: /* Timetable */

2026-05-12T12:22:07Z

Timetable

Show changes

IvanDR200: /* Timetable */

2026-05-12T12:01:55Z

Timetable

@@ Line 135: / Line 135: @@
 }}
 </div>
 {{Note|type=info|text=[https://tinyurl.com/2b734b8r Query], die anzeigt, wie viele Items jede Session enthält}}

IvanDR200 at 12:00, 12 May 2026

2026-05-12T12:00:47Z

@@ Line 126: / Line 126: @@
    # OPTIONAL {?Session wdt:P14 ?Inhalte.}
-  # Get the amount of eng alias found for an item
    service wikibase:label { bd:serviceParam wikibase:language "en".}
-} ORDER BY DESC(?SessionLabel)
 LIMIT 50
 | height=64em