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 |
||
(45 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 = | ||
|return-page = | |return-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 | |||
}} | }} | ||
Line 48: | Line 49: | ||
The column "city" is the actual subject of the query, whose link is still retrieved using a template, but without an additional query. | 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]] | ||
Line 56: | Line 58: | ||
|template?country=Link to country | |template?country=Link to country | ||
|template?city=Link to city | |template?city=Link to city | ||
|pagetitle= | |pagetitle= | ||
|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 08:07, 13 September 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 |
Shifang | shifang | China | 420000 |
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.
country | city | population |
---|---|---|
United Kingdom | London | 8982000 |
United States | New York | 8468000 |
Prague | 4000000 | |
Spain | Madrid | 3223000 |
Greece | Athens | 3155000 |
See also
- Demo VisualData 1.0
- New task
- Page upload
- CRUD
- Result formats
- Dependent values
- Geolocation
- Queries
- Query cities (join queries)
- Dynamic catalogue
- Datatable cards
- Nested schemas
- Carousel
- Table mode
- Lua
- Official docs
support & questions: support at topway.it