SandboxQuery - Versionsgeschichte

Rkr: /* References */

2014-08-19T07:59:51Z

References

← Nächstältere Version		Version vom 19. August 2014, 08:01 Uhr
Zeile 209:		Zeile 209:
	\|order=ASC,ASC		\|order=ASC,ASC
	}}		}}

			== Conclusion ==
			Never use a property as sort value, which is not set on all pages you want to return. When using a form make those fields mandatory you want to sort by later.

	== References ==		== References ==
	<references />		<references />

Rkr am 19. August 2014 um 07:53 Uhr

2014-08-19T07:53:49Z

← Nächstältere Version		Version vom 19. August 2014, 07:55 Uhr
Zeile 2:		Zeile 2:

	== Query all pages in category ==		== Query all pages in category ==
	This query finds all pages in the category, even if one of the pages does not contain a property from the columns.		This query finds all pages in the category, even if one of the pages does not contain a property from the given columns.

	<pre><nowiki>		<pre><nowiki>
Zeile 56:		Zeile 56:
	But the main goal is to explicitly '''sort by property B'''. All pages in the category shall be found in the same way as before, even pages having property B not set.		But the main goal is to explicitly '''sort by property B'''. All pages in the category shall be found in the same way as before, even pages having property B not set.

	~~Since~~ page [[SandboxB]] does not contain the property B, it is not in the result.		But since page [[SandboxB]] does not contain the property B, it is not in the result.

	~~Would you expect this?~~
	<pre><nowiki>		<pre><nowiki>
	{{#ask: [[Category:Testing]]		{{#ask: [[Category:Testing]]
Zeile 84:		Zeile 83:

	== Set property within the ask condition ==		== Set property within the ask condition ==
	~~According to <ref name="doc">http://semantic-mediawiki.org/wiki/Help:Selecting_pages#Sorting_results</ref>, adding~~ the property to the ask condition~~, which we are sorting by, should~~ return ~~all~~ pages~~. But it doesn't.~~		Setting the property B within the ask condition even just return pages with this property set:

	<pre><nowiki>		<pre><nowiki>
Zeile 110:		Zeile 109:
	}}		}}

	Well, just removing the sort ~~could or should return all pages, but it doesn't~~:		Well, just removing the sort does not change the result set:

	<pre><nowiki>		<pre><nowiki>

Rkr: /* Set property within the ask condition */

2014-08-19T07:18:27Z

Set property within the ask condition

← Nächstältere Version		Version vom 19. August 2014, 07:20 Uhr
Zeile 110:		Zeile 110:
	}}		}}

	Well, just removing the sort ~~will obviously work as before~~:		Well, just removing the sort could or should return all pages, but it doesn't:

	<pre><nowiki>		<pre><nowiki>
Zeile 120:		Zeile 120:
	\|format=table		\|format=table
	\|mainlabel=Page		\|mainlabel=Page
	~~\|order=ASC~~
	}}		}}
	</nowiki></pre>		</nowiki></pre>
Zeile 131:		Zeile 130:
	\|format=table		\|format=table
	\|mainlabel=Page		\|mainlabel=Page
	~~\|order=ASC~~
	}}		}}

Rkr: /* Set property within the ask condition */

2014-08-19T07:16:09Z

Set property within the ask condition

← Nächstältere Version		Version vom 19. August 2014, 07:18 Uhr
Zeile 110:		Zeile 110:
	}}		}}

			Well, just removing the sort will obviously work as before:

			<pre><nowiki>
			{{#ask: [[Category:Testing]][[Has property B::+]]
			\|?Has property A=Property A
			\|?Has property B=Property B
			\|offset=0
			\|limit=30
			\|format=table
			\|mainlabel=Page
			\|order=ASC
			}}
			</nowiki></pre>

			{{#ask: [[Category:Testing]][[Has property B::+]]
			\|?Has property A=Property A
			\|?Has property B=Property B
			\|offset=0
			\|limit=30
			\|format=table
			\|mainlabel=Page
			\|order=ASC
			}}

			== Some variations ==
	Another try:		Another try:

Rkr: /* Set property within the ask condition */

2014-08-19T07:01:10Z

Set property within the ask condition

← Nächstältere Version		Version vom 19. August 2014, 07:03 Uhr
Zeile 84:		Zeile 84:

	== Set property within the ask condition ==		== Set property within the ask condition ==
	According to <ref name="doc">http://semantic-mediawiki.org/wiki/Help:Selecting_pages#Sorting_results</ref>, adding the property to the ask condition which we are sorting by should return all pages. But it doesn't.		According to <ref name="doc">http://semantic-mediawiki.org/wiki/Help:Selecting_pages#Sorting_results</ref>, adding the property to the ask condition, which we are sorting by, should return all pages. But it doesn't.

	<pre><nowiki>		<pre><nowiki>

Rkr am 19. August 2014 um 06:59 Uhr

2014-08-19T06:59:51Z

← Nächstältere Version		Version vom 19. August 2014, 07:01 Uhr
Zeile 1:		Zeile 1:
	This sample page with semantic queries shows if and how a sort parameter affects the output ~~from a~~ inline query. If you sort by a "wrong" property, than the result set is changed. See <ref>https://bugzilla.wikimedia.org/show_bug.cgi?id=22583</ref>.		This sample page with semantic queries shows if and how a sort parameter affects the output of an inline query. If you sort by a "wrong" property, than the result set is changed. See <ref>https://bugzilla.wikimedia.org/show_bug.cgi?id=22583</ref> and <ref name="doc">http://semantic-mediawiki.org/wiki/Help:Selecting_pages#Sorting_results</ref>.

	== Query all pages in category ==		== Query all pages in category ==
Zeile 84:		Zeile 84:

	== Set property within the ask condition ==		== Set property within the ask condition ==
	According to http://semantic-mediawiki.org/wiki/Help:Selecting_pages#Sorting_results, adding the property to the ask condition which we are sorting by should return all pages. But it doesn't.		According to <ref name="doc">http://semantic-mediawiki.org/wiki/Help:Selecting_pages#Sorting_results</ref>, adding the property to the ask condition which we are sorting by should return all pages. But it doesn't.

	<pre><nowiki>		<pre><nowiki>

Rkr am 19. August 2014 um 06:57 Uhr

2014-08-19T06:57:10Z

← Nächstältere Version		Version vom 19. August 2014, 06:59 Uhr
Zeile 1:		Zeile 1:
			This sample page with semantic queries shows if and how a sort parameter affects the output from a inline query. If you sort by a "wrong" property, than the result set is changed. See <ref>https://bugzilla.wikimedia.org/show_bug.cgi?id=22583</ref>.

	== Query all pages in category ==		== Query all pages in category ==
	This query finds all pages in the category, even if one of the pages does not contain a property from the columns.		This query finds all pages in the category, even if one of the pages does not contain a property from the columns.
Zeile 185:		Zeile 187:
	\|order=ASC,ASC		\|order=ASC,ASC
	}}		}}

			== References ==
			<references />

Rkr am 19. August 2014 um 06:51 Uhr

2014-08-19T06:51:47Z

← Nächstältere Version		Version vom 19. August 2014, 06:53 Uhr
Zeile 24:		Zeile 24:
	}}		}}

	== Query all pages in category ~~sort~~ by property A ==		== Query all pages in category sorted by property A ==
	This query returns all pages in the category sorted by property A. Since page [[SandboxA]], [[SandboxB]] and [[SandboxC]] do contain the property A, all of them are returned.		This query returns all pages in the category sorted by property A. Since page [[SandboxA]], [[SandboxB]] and [[SandboxC]] do contain the property A, all of them are returned.

Zeile 51:		Zeile 51:
	}}		}}

	== Query all pages in category ~~sort~~ by property B ==		== Query all pages in category sorted by property B ==
	But the main goal is to explicitly '''sort by property B'''. All pages in the category shall be found in the same way as before, even pages having property B not set.		But the main goal is to explicitly '''sort by property B'''. All pages in the category shall be found in the same way as before, even pages having property B not set.

Rkr: /* Set property within the ask condition */

2014-08-19T06:44:45Z

Set property within the ask condition

@@ Zeile 157: / Zeile 157: @@
 |mainlabel=Page
 |sort=Has property B,Has property A
 |order=ASC,ASC
 }}

Rkr am 19. August 2014 um 06:43 Uhr

2014-08-19T06:43:33Z

← Nächstältere Version		Version vom 19. August 2014, 06:45 Uhr
Zeile 8:		Zeile 8:
	\|offset=0		\|offset=0
	\|limit=30		\|limit=30
	~~\|order=desc~~
	\|format=table		\|format=table
			\|mainlabel=Page
			\|order=ASC
	}}		}}
	</nowiki></pre>		</nowiki></pre>
Zeile 18:		Zeile 19:
	\|offset=0		\|offset=0
	\|limit=30		\|limit=30
	~~\|order=desc~~
	\|format=table		\|format=table
			\|mainlabel=Page
			\|order=ASC
	}}		}}

Zeile 31:		Zeile 33:
	\|offset=0		\|offset=0
	\|limit=30		\|limit=30
	~~\|order=desc~~
	\|format=table		\|format=table
			\|mainlabel=Page
	\|sort=Has property A		\|sort=Has property A
			\|order=ASC
	}}		}}
	</nowiki></pre>		</nowiki></pre>
Zeile 42:		Zeile 45:
	\|offset=0		\|offset=0
	\|limit=30		\|limit=30
	~~\|order=desc~~
	\|format=table		\|format=table
			\|mainlabel=Page
	\|sort=Has property A		\|sort=Has property A
			\|order=ASC
	}}		}}

Zeile 59:		Zeile 63:
	\|offset=0		\|offset=0
	\|limit=30		\|limit=30
	~~\|order=desc~~
	\|format=table		\|format=table
			\|mainlabel=Page
	\|sort=Has property B		\|sort=Has property B
			\|order=ASC
	}}		}}
	</nowiki></pre>		</nowiki></pre>
Zeile 70:		Zeile 75:
	\|offset=0		\|offset=0
	\|limit=30		\|limit=30
	~~\|order=desc~~
	\|format=table		\|format=table
			\|mainlabel=Page
	\|sort=Has property B		\|sort=Has property B
			\|order=ASC
	}}		}}

Zeile 84:		Zeile 90:
	\|offset=0		\|offset=0
	\|limit=30		\|limit=30
	~~\|order=desc~~
	\|format=table		\|format=table
			\|mainlabel=Page
	\|sort=Has property B		\|sort=Has property B
			\|order=ASC
	}}		}}
	</nowiki></pre>		</nowiki></pre>
Zeile 95:		Zeile 102:
	\|offset=0		\|offset=0
	\|limit=30		\|limit=30
	~~\|order=desc~~
	\|format=table		\|format=table
			\|mainlabel=Page
	\|sort=Has property B		\|sort=Has property B
			\|order=ASC
	}}		}}

Zeile 108:		Zeile 116:
	\|offset=0		\|offset=0
	\|limit=30		\|limit=30
	~~\|order=desc~~
	\|format=table		\|format=table
			\|mainlabel=Page
	\|sort=Has property B		\|sort=Has property B
			\|order=ASC
	}}		}}
	</nowiki></pre>		</nowiki></pre>
Zeile 119:		Zeile 128:
	\|offset=0		\|offset=0
	\|limit=30		\|limit=30
	~~\|order=desc~~
	\|format=table		\|format=table
			\|mainlabel=Page
	\|sort=Has property B		\|sort=Has property B
			\|order=ASC
			}}

			Another try:

			<pre><nowiki>
			{{#ask: [[Category:Testing]][[Has property B::+]]
			\|?Has property A=Property A
			\|?Has property B=Property B
			\|offset=0
			\|limit=30
			\|format=table
			\|mainlabel=Page
			\|sort=Has property B,Has property A
			\|order=ASC,ASC
			}}
			</nowiki></pre>

			{{#ask: [[Category:Testing]][[Has property B::+]]
			\|?Has property A=Property A
			\|?Has property B=Property B
			\|offset=0
			\|limit=30
			\|format=table
			\|mainlabel=Page
			\|sort=Has property B,Has property A
			\|order=ASC,ASC
	}}		}}