Query cities: Difference between revisions
Jump to navigation
Jump to search
No edit summary Tag: 2017 source edit |
No edit summary Tag: 2017 source edit |
||
(47 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{#visualdataform: City | {{#visualdataform: City | ||
|title = Add City | |title = Add City | ||
|action = create | |action = create | ||
|edit-page = | |edit-page = | ||
Line 12: | Line 12: | ||
|edit-categories = false | |edit-categories = false | ||
|edit-content-model = false | |edit-content-model = false | ||
|target- | |target-slot = jsondata | ||
|default-categories = | |default-categories = | ||
|default-content-model = wikitext | |default-content-model = wikitext | ||
|layout-align = top | |layout-align = top | ||
|popup-help = | |popup-help = false | ||
|submit-button-text = | |submit-button-text = | ||
|layout = tabs | |layout = tabs | ||
Line 23: | Line 23: | ||
}} | }} | ||
All | All cities: | ||
{{#visualdataquery: [[city::+]] | {{#visualdataquery: [[city::+]] | ||
Line 31: | Line 31: | ||
|?population | |?population | ||
|format=table | |format=table | ||
|limit= | |order=population desc | ||
|limit=20 | |||
}} | }} | ||
<pre> | <pre> | ||
[[city::+]][[population::> 3000000]] | [[city::+]][[population::> 3000000]] | ||
</pre> | </pre> | ||
<!-- | |||
|?capital | |||
|template?capital=capital | |||
--> | |||
The following table uses (in the first column) the printout template [[Template:Link to country]] to perform a join with the "Country article" schema. | |||
The column "city" is the actual subject of the query, whose link is still retrieved using a template, but without an additional query. | |||
{{#visualdataquery: [[city::+]][[population::> 3000000]] | {{#visualdataquery: [[city::+]][[population::> 3000000]] | ||
|schema=City | |schema=City | ||
|?country | |||
|?city | |?city | ||
|?population | |?population | ||
|template?country=Link to country | |template?country=Link to country | ||
|template?city=Link to city | |||
|pagetitle=false | |||
|order=population desc | |||
|format=table | |format=table | ||
|limit=100 | |limit=100 | ||
}} | }} | ||
== See also == | |||
{{Demo VisualData footer}} | |||
jsondata | |||
---|---|---|---|
Line 1: | Line 1: | ||
{} | { | ||
"categories": [ | |||
"A" | |||
] | |||
} |
Latest revision as of 19:36, 28 April 2024
form is loading...
All cities:
page title | city | country | population |
---|---|---|---|
London | London | United Kingdom | 8982000 |
New York | New York | United States | 8468000 |
Prague | Prague | Czech Republic | 4000000 |
Madrid | Madrid | Spain | 3223000 |
Athens | Athens | Greece | 3155000 |
Rome | Rome | Italy | 2873000 |
Regensburg | Regensburg | Germany | 150000 |
[[city::+]][[population::> 3000000]]
The following table uses (in the first column) the printout template Template:Link to country to perform a join with the "Country article" schema.
The column "city" is the actual subject of the query, whose link is still retrieved using a template, but without an additional query.
false | country | city | population |
---|---|---|---|
London | 8982000 | ||
New York | 8468000 | ||
Prague | 4000000 | ||
Madrid | 3223000 | ||
Athens | 3155000 |