Template:Userpage - Revision history

RaphaelWimmer: add link to editor

2024-12-01T22:44:53Z

add link to editor

← Older revision		Revision as of 22:44, 1 December 2024
Line 3:		Line 3:
	The user's node (''Item'') in the graph is [[Item:{{{2}}}]]		The user's node (''Item'') in the graph is [[Item:{{{2}}}]]

			If this is your first time here, you might want to select topics that are of interest to you - or which you already know - in our [https://test.graphit.ur.de/app/src/pages/selectionTools/ visual graph editor]

	{{#widget:SPARQLquery\|code=		{{#widget:SPARQLquery\|code=

Leonie: update queries

2024-11-27T12:56:28Z

update queries

← Older revision		Revision as of 12:56, 27 November 2024
Line 6:		Line 6:
	{{#widget:SPARQLquery\|code=		{{#widget:SPARQLquery\|code=
	#defaultView:Graph		#defaultView:Graph
			PREFIX wdt: <https://graphit.ur.de/prop/direct/>
			PREFIX wd: <https://graphit.ur.de/entity/>

			SELECT ?student ?studentLabel ?item ?itemLabel ?edgeLabel ?rgb1 ?shape1 WHERE {
			BIND (wd:{{{2\|Q157}}} as ?student)
			?student ?prop ?item.
			# ?edge ?dummy ?prop ; rdf:type wikibase:Property.
			MINUS {?student wdt:P3 ?item}. # remove self-reference

			# Color Coding:
			bind (if(?prop = wdt:P25, "e8fcff", # participates in (blue) f3fdff
			if(?prop = wdt:P12, "e3ffd9", # has completed (green)
			if(?prop = wdt:P23, "ffeec2", # interested in (orange)
			"FFFFFF" ))) as ?rgb1).
			bind("ellipse" as ?shape1).

			SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
			} LIMIT 100
			\|caption=An Overview of (all) linked items for {{{1\|Max Mustermann}}}
			}}


			{\| class="wikitable"
			! '''Interested Items''' !! '''Completed Items'''
			\|-
			<!-- Linke Spalte -->
			\| style="width: 50%" \| {{#widget:SPARQLquery\|code=
			#defaultView:Table
	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		SELECT DISTINCT
	~~?student ?studentLabel ?shape~~		?interest ?interestLabel
	?interest ?interestLabel ~~?rgb1~~
	~~?complete ?completeLabel ?rgb2~~
	WHERE {		WHERE {
	BIND (wd:{{{2\|Q157}}} as ?student).		BIND (wd:{{{2\|Q157}}} as ?student).
			?student wdt:P23 ?interest.
	~~OPTIONAL {~~?student wdt:P23 ?interest.}		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	~~OPTIONAL~~ {~~?student wdt~~:~~P12 ?complete~~.}		}
			\|height=30vh
	~~BIND (~~"~~box~~" ~~as ?shape)~~.		}}
	~~BIND ("ffeec2" as ?rgb1)~~.		<!-- Rechte Spalte -->
	~~BIND ("e3ffd9" as ?rgb2)~~.		\| style="width: 50%" \| {{#widget:SPARQLquery\|code=
			#defaultView:Table
			PREFIX wdt: <https://graphit.ur.de/prop/direct/>
			PREFIX wd: <https://graphit.ur.de/entity/>

			SELECT DISTINCT
			?complete ?completeLabel
			WHERE {
			BIND (wd:{{{2\|Q157}}} as ?student).
			?student wdt:P12 ?complete.
	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	} \|~~caption~~=~~An overview of all linked items for {{{1\|Max Mustermann}}}~~		}
			\|height=30vh
	}}		}}
	~~This query shows:~~		\|}
	* The <span style="background-color:#e3ffd9">items</span> that you have [[Property:P12\|~~completed]].~~
	* The <span style="background-color:#ffeec2">items</span> that you are [[Property:P23\|interested in]].


	<noinclude>		<noinclude>
			Autmatically included in a somebodies Userpage via a sign-in script
	* param 1 == Username		* param 1 == Username
	* param 2 == QID		* param 2 == QID
	</noinclude>		</noinclude>

Leonie: fix query (optional) + add legend

2024-11-27T12:44:27Z

fix query (optional) + add legend

← Older revision		Revision as of 12:44, 27 November 2024
Line 16:		Line 16:
	BIND (wd:{{{2\|Q157}}} as ?student).		BIND (wd:{{{2\|Q157}}} as ?student).

	?student wdt:P23 ?interest.		OPTIONAL {?student wdt:P23 ?interest.}
	?student wdt:P12 ?complete.		OPTIONAL {?student wdt:P12 ?complete.}

	BIND ("box" as ?shape).		BIND ("box" as ?shape).
Line 26:		Line 26:
	} \|caption=An overview of all linked items for {{{1\|Max Mustermann}}}		} \|caption=An overview of all linked items for {{{1\|Max Mustermann}}}
	}}		}}
			This query shows:
			* The <span style="background-color:#e3ffd9">items</span> that you have [[Property:P12\|completed]].
			* The <span style="background-color:#ffeec2">items</span> that you are [[Property:P23\|interested in]].

Leonie: fix query

2024-11-27T12:41:15Z

fix query

← Older revision		Revision as of 12:41, 27 November 2024
Line 9:		Line 9:
	PREFIX wd: <https://graphit.ur.de/entity/>		PREFIX wd: <https://graphit.ur.de/entity/>

	SELECT ?~~item1~~ ?~~image~~ ?~~item1Label~~ ?~~item2~~ ?~~image2~~ ?~~item2Label~~ ?~~edgeLabel~~ ?~~rgb1~~ ?~~shape1~~ WHERE {		SELECT DISTINCT
	~~?item1 rdfs:label~~ wd:{{{2\|Q157}}}.		?student ?studentLabel ?shape
			?interest ?interestLabel ?rgb1
			?complete ?completeLabel ?rgb2
			WHERE {
			BIND (wd:{{{2\|Q157}}} as ?student).

	?~~item1~~ ?~~prop ?item2~~.		?student wdt:P23 ?interest.
	#?~~edge ?dummy~~ ?~~prop ; rdf:type wikibase:Property~~.		?student wdt:P12 ?complete.

	~~MINUS {~~?~~item wdt:P3~~ ?~~item2}~~.		BIND ("box" as ?shape).
			BIND ("ffeec2" as ?rgb1).
			BIND ("e3ffd9" as ?rgb2).

	~~# Color Coding:~~
	~~bind (if(?prop = wdt:P25, "e8fcff", # participates in (blue) f3fdff~~
	~~if(?prop = wdt:P12, "e3ffd9", # has completed (green)~~
	~~if(?prop = wdt:P23, "ffeec2", # interested in (orange)~~
	~~"FFFFFF" ))) as ?rgb1).~~
	~~bind("ellipse" as ?shape1).~~

	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }		SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
	} \|caption=An overview of all linked items for {{{1\|Max Mustermann}}}		} \|caption=An overview of all linked items for {{{1\|Max Mustermann}}}

Leonie: add user graph (test)

2024-11-27T12:36:06Z

add user graph (test)

← Older revision		Revision as of 12:36, 27 November 2024
Line 2:		Line 2:

	The user's node (''Item'') in the graph is [[Item:{{{2}}}]]		The user's node (''Item'') in the graph is [[Item:{{{2}}}]]


			{{#widget:SPARQLquery\|code=
			#defaultView:Graph
			PREFIX wdt: <https://graphit.ur.de/prop/direct/>
			PREFIX wd: <https://graphit.ur.de/entity/>

			SELECT ?item1 ?image ?item1Label ?item2 ?image2 ?item2Label ?edgeLabel ?rgb1 ?shape1 WHERE {
			?item1 rdfs:label wd:{{{2\|Q157}}}.

			?item1 ?prop ?item2.
			#?edge ?dummy ?prop ; rdf:type wikibase:Property.

			MINUS {?item wdt:P3 ?item2}.

			# Color Coding:
			bind (if(?prop = wdt:P25, "e8fcff", # participates in (blue) f3fdff
			if(?prop = wdt:P12, "e3ffd9", # has completed (green)
			if(?prop = wdt:P23, "ffeec2", # interested in (orange)
			"FFFFFF" ))) as ?rgb1).
			bind("ellipse" as ?shape1).

			SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
			} \|caption=An overview of all linked items for {{{1\|Max Mustermann}}}
			}}


			<noinclude>
			* param 1 == Username
			* param 2 == QID
			</noinclude>

RaphaelWimmer at 07:47, 27 November 2024

2024-11-27T07:47:57Z

← Older revision		Revision as of 07:47, 27 November 2024
Line 1:		Line 1:
	This is the user page for //{{{1}}}//.		This is the user page for ''{{{1}}}''.

	~~User item:~~ [[Item:{{{2}}}]]		The user's node (''Item'') in the graph is [[Item:{{{2}}}]]

RaphaelWimmer at 07:45, 27 November 2024

2024-11-27T07:45:01Z

← Older revision		Revision as of 07:45, 27 November 2024
Line 1:		Line 1:
	This is the user page for //{{1}}//.		This is the user page for //{{{1}}}//.

	User item: [[Item:{{2}}]]		User item: [[Item:{{{2}}}]]

RaphaelWimmer: initial template

2024-11-27T07:44:09Z

initial template

New page

This is the user page for //{{1}}//.

User item: [[Item:{{2}}]]