Queries

               
{{#visualdataquery:[[name::Afghanistan]] [[states/name::Badakhshan]]
|schema=Country 
|?states/cities/name
|?states/cities/latitude
|?states/cities/longitude
|format=datatable 
}} 

page title	Name	Latitude	Longitude
Data:Countries/Afghanistan	Ashkāsham	36.68333	71.53333
Data:Countries/Afghanistan	Fayzabad	37.11664	70.58002
Data:Countries/Afghanistan	Jurm	36.86477	70.83421
Data:Countries/Afghanistan	Khandūd	36.95127	72.318
Data:Countries/Afghanistan	Rāghistān	37.66079	70.67346
Data:Countries/Afghanistan	Wākhān	37.0571	73.34928

{{#visualdataquery:[[name::Afghanistan]]   [[states/name::Badakhshan]] [[states/cities/name::A~]][[states/cities/latitude::36.68333000]] [[states/cities/restaurants/name::bbb]]      
|schema=Country   
|?states/cities/name
|?states/cities/latitude
|format=datatable 
}} 

page title	Name	Latitude
Data:Countries/Afghanistan	Ashkāsham	36.68333

{{#visualdataquery:[[name::Afghanistan]]   [[states/name::Badakhshan]] [[states/cities/name::A~]][[states/cities/restaurants/name::bbb]]      
|schema=Country   
|?states/cities/name
|?states/cities/latitude
|?states/cities/longitude
|format=json 
|hierarchical-conditions=true 
|pagetitle-name=article 
}} 

title "Data:Countries/Afghanistan" pageid 710 data states cities name "Ashkāsham" latitude 36.68333 longitude 71.53333 name "Fayzabad" latitude 37.11664 longitude 70.58002 name "Jurm" latitude 36.86477 longitude 70.83421 name "Khandūd" latitude 36.95127 longitude 72.318 name "Rāghistān" latitude 37.66079 longitude 70.67346 name "Wākhān" latitude 37.0571 longitude 73.34928

{{#visualdataquery:[[name::Afghanistan]]
|schema=Country 
|?states/name
|?states/state_code
|format=table 
}}

page title	Name	State code
Data:Countries/Afghanistan	Badakhshan	BDS
Data:Countries/Afghanistan	Badghis	BDG
Data:Countries/Afghanistan	Baghlan	BGL
Data:Countries/Afghanistan	Balkh	BAL
Data:Countries/Afghanistan	Bamyan	BAM
Data:Countries/Afghanistan	Daykundi	DAY
Data:Countries/Afghanistan	Farah	FRA
Data:Countries/Afghanistan	Faryab	FYB
Data:Countries/Afghanistan	Ghazni	GHA
Data:Countries/Afghanistan	Ghōr	GHO
Data:Countries/Afghanistan	Helmand	HEL
Data:Countries/Afghanistan	Herat	HER
Data:Countries/Afghanistan	Jowzjan	JOW
Data:Countries/Afghanistan	Kabul	KAB
Data:Countries/Afghanistan	Kandahar	KAN
Data:Countries/Afghanistan	Kapisa	KAP
Data:Countries/Afghanistan	Khost	KHO
Data:Countries/Afghanistan	Kunar	KNR
Data:Countries/Afghanistan	Kunduz Province	KDZ
Data:Countries/Afghanistan	Laghman	LAG
Data:Countries/Afghanistan	Logar	LOG
Data:Countries/Afghanistan	Nangarhar	NAN
Data:Countries/Afghanistan	Nimruz	NIM
Data:Countries/Afghanistan	Nuristan	NUR
Data:Countries/Afghanistan	Paktia	PIA
Data:Countries/Afghanistan	Paktika	PKA
Data:Countries/Afghanistan	Panjshir	PAN
Data:Countries/Afghanistan	Parwan	PAR
Data:Countries/Afghanistan	Samangan	SAM
Data:Countries/Afghanistan	Sar-e Pol	SAR
Data:Countries/Afghanistan	Takhar	TAK
Data:Countries/Afghanistan	Urozgan	URU
Data:Countries/Afghanistan	Zabul	ZAB

 
{{#visualdataquery:
[[name::Canada]][[states/name::Q~]]
|schema=Country
|?states/name=State name
|?states/cities/name=City name
|?states/cities/latitude 
|limit=50
|format=datatable 
}}

page title	Latitude	State name	City name
Data:Countries/Canada	48.10018	Quebec	Abitibi-Témiscamingue
Data:Countries/Canada	45.65007	Quebec	Acton Vale
Data:Countries/Canada	46.05007	Quebec	Adstock
Data:Countries/Canada	48.88324	Quebec	Albanel
Data:Countries/Canada	48.55009	Quebec	Alma
Data:Countries/Canada	48.56688	Quebec	Amos
Data:Countries/Canada	48.46382	Quebec	Amqui
Data:Countries/Canada	45.35008	Quebec	Ange-Gardien
Data:Countries/Canada	45.76678	Quebec	Asbestos
Data:Countries/Canada	49.21679	Quebec	Baie-Comeau
Data:Countries/Canada	45.41397	Quebec	Baie-D'Urfé
Data:Countries/Canada	47.44109	Quebec	Baie-Saint-Paul
Data:Countries/Canada	48.43349	Quebec	Barraute
Data:Countries/Canada	48.0503	Quebec	Bas-Saint-Laurent
Data:Countries/Canada	45.43341	Quebec	Beaconsfield
Data:Countries/Canada	46.21785	Quebec	Beauceville
Data:Countries/Canada	45.31341	Quebec	Beauharnois
Data:Countries/Canada	47.04428	Quebec	Beaupré
Data:Countries/Canada	46.34106	Quebec	Bécancour
Data:Countries/Canada	45.11678	Quebec	Bedford
Data:Countries/Canada	45.56839	Quebec	Beloeil
Data:Countries/Canada	46.08336	Quebec	Berthierville
Data:Countries/Canada	45.66678	Quebec	Blainville
Data:Countries/Canada	45.66678	Quebec	Bois-des-Filion
Data:Countries/Canada	45.61678	Quebec	Boisbriand
Data:Countries/Canada	48.04573	Quebec	Bonaventure
Data:Countries/Canada	45.59104	Quebec	Boucherville
Data:Countries/Canada	46.68037	Quebec	Breakeyville
Data:Countries/Canada	45.31678	Quebec	Bromont
Data:Countries/Canada	45.45008	Quebec	Brossard
Data:Countries/Canada	45.68342	Quebec	Brownsburg-Chatham
Data:Countries/Canada	45.58563	Quebec	Buckingham
Data:Countries/Canada	47.68065	Quebec	Cabano
Data:Countries/Canada	47.91657	Quebec	Cacouna
Data:Countries/Canada	45.38338	Quebec	Candiac
Data:Countries/Canada	45.5668	Quebec	Cantley
Data:Countries/Canada	49.10009	Quebec	Cap-Chat
Data:Countries/Canada	46.67159	Quebec	Cap-Santé
Data:Countries/Canada	47.376	Quebec	Capitale-Nationale
Data:Countries/Canada	45.45008	Quebec	Carignan
Data:Countries/Canada	48.09838	Quebec	Carleton
Data:Countries/Canada	48.10749	Quebec	Carleton-sur-Mer
Data:Countries/Canada	46.01985	Quebec	Centre-du-Québec
Data:Countries/Canada	45.45008	Quebec	Chambly
Data:Countries/Canada	48.43339	Quebec	Chambord
Data:Countries/Canada	48.34935	Quebec	Chandler
Data:Countries/Canada	49.78344	Quebec	Chapais
Data:Countries/Canada	45.71678	Quebec	Charlemagne
Data:Countries/Canada	46.96031	Quebec	Château-Richer
Data:Countries/Canada	45.38338	Quebec	Châteauguay

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

Download the latest version!