Template:MER-autoTable rfrsh - Revision history

Admin at 13:08, 3 January 2023

2023-01-03T13:08:25Z

Admin at 13:24, 31 July 2022

2022-07-31T13:24:27Z

Admin at 12:35, 28 July 2022

2022-07-28T12:35:54Z

Admin at 12:35, 28 July 2022

2022-07-28T12:35:15Z

Admin at 12:00, 3 July 2022

2022-07-03T12:00:54Z

Admin: Created page with "{| {{ #If:{{{relation|}}} | {{ #If:{{{type|}}} | {{#clear_external_data:}}{{#get_web_data:url=..."

2022-02-13T11:35:18Z

Created page with "<includeonly>{| {{ #If:{{{relation|}}} | {{ #If:{{{type|}}} | {{#clear_external_data:}}{{#get_web_data:url=..."

New page

<includeonly>{|
{{ #If:{{{relation|}}} |
{{ #If:{{{type|}}} |
{{#clear_external_data:}}{{#get_web_data:url=https://opengeofiction.net/api/0.6/relation/{{{relation}}}/full
|format=xml
|data=
{{{type}}}_id=/osm/{{{type}}}/@id
{{ #If:{{{column1tag|}}} |
,{{{column1tag}}}=/osm/{{{type}}}/tag[@k='{{{column1tag}}}']/@v {{ #If:{{{column2tag|}}} |
,{{{column2tag}}}=/osm/{{{type}}}/tag[@k='{{{column2tag}}}']/@v {{ #If:{{{column3tag|}}} |
,{{{column3tag}}}=/osm/{{{type}}}/tag[@k='{{{column3tag}}}']/@v {{ #If:{{{column4tag|}}} |
,{{{column4tag}}}=/osm/{{{type}}}/tag[@k='{{{column4tag}}}']/@v {{ #If:{{{column5tag|}}} |
,{{{column5tag}}}=/osm/{{{type}}}/tag[@k='{{{column5tag}}}']/@v {{ #If:{{{column6tag|}}} |
,{{{column6tag}}}=/osm/{{{type}}}/tag[@k='{{{column6tag}}}']/@v {{ #If:{{{column7tag|}}} |
,{{{column7tag}}}=/osm/{{{type}}}/tag[@k='{{{column7tag}}}']/@v {{ #If:{{{column8tag|}}} |
,{{{column8tag}}}=/osm/{{{type}}}/tag[@k='{{{column8tag}}}']/@v {{ #If:{{{column9tag|}}} |
,{{{column9tag}}}=/osm/{{{type}}}/tag[@k='{{{column9tag}}}']/@v }} }} }} }} }} }} }} }} }}
|use xpath
}} }} |
{{ #If:{{{search1|}}} |
{{#clear_external_data:}}{{#get_web_data:url=https://osm3s.opengeofiction.net/api/interpreter?data={{#if:{{{area|}}} | {{#ifeq:{{{area}}} | MER |
(area%5B%22admin_level%22=2%5D%5B%22name%22=%22Ӎєrɠąɲɣ%22%5D;)-%3E.bndarea;%0A | (area%5B%22admin_level%22%5D%5B%22name%22=%22{{#replace:{{{area}}}| |%20}}%22%5D;)-%3E.bndarea;%0A }} }}{{{type}}}{{#if:{{{area|}}} |
(area.bndarea) }}%5B%22{{lc: {{#replace:{{#titleparts:{{{search1}}}|1|1}}| |_}} }}%22{{#if: {{#titleparts:{{{search1}}}|2|2}} | %3D%22{{MER-opq-enablenames | {{{search1}}} }}%22 }}%5D{{#if:{{{search2|}}} | %5B%22{{lc: {{#replace:{{#titleparts:{{{search2}}}|1|1}}| |_}} }}%22{{#if: {{#titleparts:{{{search2}}}|2|2}} | %3D%22{{MER-opq-enablenames | {{{search2}}} }}%22 }}%5D }}{{#if:{{{search3|}}} | %5B%22{{lc: {{#replace:{{#titleparts:{{{search3}}}|1|1}}| |_}} }}%22{{#if: {{#titleparts:{{{search3}}}|2|2}} | %3D%22{{MER-opq-enablenames | {{{search3}}} }}%22 }}%5D }};out;
|format=xml
|data=
{{{type}}}_id=/osm/{{{type}}}/@id
{{ #If:{{{column1tag|}}} |
,{{{column1tag}}}=/osm/{{{type}}}/tag[@k='{{{column1tag}}}']/@v {{ #If:{{{column2tag|}}} |
,{{{column2tag}}}=/osm/{{{type}}}/tag[@k='{{{column2tag}}}']/@v {{ #If:{{{column3tag|}}} |
,{{{column3tag}}}=/osm/{{{type}}}/tag[@k='{{{column3tag}}}']/@v {{ #If:{{{column4tag|}}} |
,{{{column4tag}}}=/osm/{{{type}}}/tag[@k='{{{column4tag}}}']/@v {{ #If:{{{column5tag|}}} |
,{{{column5tag}}}=/osm/{{{type}}}/tag[@k='{{{column5tag}}}']/@v {{ #If:{{{column6tag|}}} |
,{{{column6tag}}}=/osm/{{{type}}}/tag[@k='{{{column6tag}}}']/@v {{ #If:{{{column7tag|}}} |
,{{{column7tag}}}=/osm/{{{type}}}/tag[@k='{{{column7tag}}}']/@v {{ #If:{{{column8tag|}}} |
,{{{column8tag}}}=/osm/{{{type}}}/tag[@k='{{{column8tag}}}']/@v {{ #If:{{{column9tag|}}} |
,{{{column9tag}}}=/osm/{{{type}}}/tag[@k='{{{column9tag}}}']/@v }} }} }} }} }} }} }} }} }}
|use xpath
}} }} }}{{ #If:{{{collapsible|}}} |
{{ #If:{{{collapsed|}}} |
{{{!}} class="wikitable sortable mw-collapsible mw-collapsed;" |
{{{!}} class="wikitable sortable mw-collapsible" }} |
{{{!}} class="wikitable sortable" }} style="text-align:left; width:{{{width|500}}}px;"
|-
! class="unsortable" style="background:#{{{bgcolor|CCCCFF}}};" {{ #If:{{{column9tag|}}} |
colspan="9" | {{ #If:{{{column8tag|}}} |
colspan="8" | {{ #If:{{{column7tag|}}} |
colspan="7" | {{ #If:{{{column6tag|}}} |
colspan="6" | {{ #If:{{{column5tag|}}} |
colspan="5" | {{ #If:{{{column4tag|}}} |
colspan="4" | {{ #If:{{{column3tag|}}} |
colspan="3" | {{ #If:{{{column2tag|}}} |
colspan="2" | {{ #If:{{{column1tag|}}} |
colspan="1" }} }} }} }} }} }} }} }} }} | {{{topic|Table}}}
! class="unsortable" style="background:#{{{bgcolor|CCCCFF}}}; text-align:right; width:50px;" | {{Refresh}}
|-
{{ #If:{{{column1tag|}}} |
{{ #If:{{{column1sort|}}}{{{column1width|}}} |
! {{ #If:{{{column1sort|}}} |
class="unsortable" }} {{ #If:{{{column1width|}}} |
style="width:{{{column1width}}}px;" }} {{!}} | ! }} {{{column1name}}}
{{ #If:{{{column2tag|}}} |
{{ #If:{{{column2sort|}}}{{{column2width|}}} |
! {{ #If:{{{column2sort|}}} |
class="unsortable" }} {{ #If:{{{column2width|}}} |
style="width:{{{column2width}}}px;" }} {{!}} | ! }} {{{column2name}}}
{{ #If:{{{column3tag|}}} |
{{ #If:{{{column3sort|}}}{{{column3width|}}} |
! {{ #If:{{{column3sort|}}} |
class="unsortable" }} {{ #If:{{{column3width|}}} |
style="width:{{{column3width}}}px;" }} {{!}} | ! }} {{{column3name}}}
{{ #If:{{{column4tag|}}} |
{{ #If:{{{column4sort|}}}{{{column4width|}}} |
! {{ #If:{{{column4sort|}}} |
class="unsortable" }} {{ #If:{{{column4width|}}} |
style="width:{{{column4width}}}px;" }} {{!}} | ! }} {{{column4name}}}
{{ #If:{{{column5tag|}}} |
{{ #If:{{{column5sort|}}}{{{column5width|}}} |
! {{ #If:{{{column5sort|}}} |
class="unsortable" }} {{ #If:{{{column5width|}}} |
style="width:{{{column5width}}}px;" }} {{!}} | ! }} {{{column5name}}}
{{ #If:{{{column6tag|}}} |
{{ #If:{{{column6sort|}}}{{{column6width|}}} |
! {{ #If:{{{column6sort|}}} |
class="unsortable" }} {{ #If:{{{column6width|}}} |
style="width:{{{column6width}}}px;" }} {{!}} | ! }} {{{column6name}}}
{{ #If:{{{column7tag|}}} |
{{ #If:{{{column7sort|}}}{{{column7width|}}} |
! {{ #If:{{{column7sort|}}} |
class="unsortable" }} {{ #If:{{{column7width|}}} |
style="width:{{{column7width}}}px;" }} {{!}} | ! }} {{{column7name}}}
{{ #If:{{{column8tag|}}} |
{{ #If:{{{column8sort|}}}{{{column8width|}}} |
! {{ #If:{{{column8sort|}}} |
class="unsortable" }} {{ #If:{{{column8width|}}} |
style="width:{{{column8width}}}px;" }} {{!}} | ! }} {{{column8name}}}
{{ #If:{{{column9tag|}}} |
{{ #If:{{{column9sort|}}}{{{column9width|}}} |
! {{ #If:{{{column9sort|}}} |
class="unsortable" }} {{ #If:{{{column9width|}}} |
style="width:{{{column9width}}}px;" }} {{!}} | ! }} {{{column9name}}} }} }} }} }} }} }} }} }} }}
! class="unsortable" | Map
|-
{{#for_external_table:<nowiki/>
{{ #If:{{{column1tag|}}} |
{{!}} {{ #If:{{{column1link|}}} |
[[{{{{{{column1tag|}}}}}}]] | {{{{{{column1tag|}}}}}}
}}
{{ #If:{{{column2tag|}}} |
{{!}} {{ #If:{{{column2link|}}} |
[[{{{{{{column2tag|}}}}}}]] | {{{{{{column2tag|}}}}}}
}}
{{ #If:{{{column3tag|}}} |
{{!}} {{ #If:{{{column3link|}}} |
[[{{{{{{column3tag|}}}}}}]] | {{{{{{column3tag|}}}}}}
}}
{{ #If:{{{column4tag|}}} |
{{!}} {{ #If:{{{column4link|}}} |
[[{{{{{{column4tag|}}}}}}]] | {{{{{{column4tag|}}}}}}
}}
{{ #If:{{{column5tag|}}} |
{{!}} {{ #If:{{{column5link|}}} |
[[{{{{{{column5tag|}}}}}}]] | {{{{{{column5tag|}}}}}}
}}
{{ #If:{{{column6tag|}}} |
{{!}} {{ #If:{{{column6link|}}} |
[[{{{{{{column6tag|}}}}}}]] | {{{{{{column6tag|}}}}}}
}}
{{ #If:{{{column7tag|}}} |
{{!}} {{ #If:{{{column7link|}}} |
[[{{{{{{column7tag|}}}}}}]] | {{{{{{column7tag|}}}}}}
}}
{{ #If:{{{column8tag|}}} |
{{!}} {{ #If:{{{column8link|}}} |
[[{{{{{{column8tag|}}}}}}]] | {{{{{{column8tag|}}}}}}
}}
{{ #If:{{{column9tag|}}} |
{{!}} {{ #If:{{{column9link|}}} |
[[{{{{{{column9tag|}}}}}}]] | {{{{{{column9tag|}}}}}}
}} }} }} }} }} }} }} }} }} }}
{{!}} [[File:OGFmapicon.png|18px|link=]] <span class="plainlinks">[https://opengeofiction.net/{{{type}}}/{{{{{{type}}}_id}}} map]</span>
{{!}}-
}} |}
{{#clear_external_data:}}
|}
</includeonly><noinclude>

=Usage=
<pre>{{MER-autoTable_rfrsh
| relation = ...relation number
| type = {node,way} ...only ways OR nodes are possible
| topic = ...topic of table
| width = ...total width of table
| column1sort = {no, } ...if 1st column is unsortable
| column1name = ...name of 1st column
| column1tag = ...name of 1st column tag to search for
| column2sort = {no, } ...if 2nd column is unsortable
| column2name = ...name of 2nd column
| column2tag = ...name of 2nd column tag to search for
| column3sort = {no, } ...if 3rd column is unsortable
| column3name = ...name of 3rd column
| column3tag = ...name of 3rd column tag to search for
| column4sort = {no, } ...if 4th column is unsortable
| column4name = ...name of 4th column
| column4tag = ...name of 4th column tag to search for
| column5sort = {no, } ...if 5th column is unsortable
| column5name = ...name of 5th column
| column5tag = ...name of 5th column tag to search for
| column6sort = {no, } ...if 6th column is unsortable
| column6name = ...name of 6th column
| column6tag = ...name of 6th column tag to search for
| column7sort = {no, } ...if 7th column is unsortable
| column7name = ...name of 7th column
| column7tag = ...name of 7th column tag to search for
| column8sort = {no, } ...if 8th column is unsortable
| column8name = ...name of 8th column
| column8tag = ...name of 8th column tag to search for
| column9sort = {no, } ...if 9th column is unsortable
| column9name = ...name of 9th column
| column9tag = ...name of 9th column tag to search for
}}</pre>

=Example: List of Gobeletplain Cafés=
<pre>{{MER-autoTable_rfrsh
| relation = 48497
| type = node
| topic = List of Gobeletplain Cafés
| width = 550
| column1name = Name
| column1tag = name
| column2name = City
| column2tag = is_in:city
| column3name = Country
| column3tag = is_in:country
| column4sort = no
| column4name = Note
| column4tag = ldata:note
}}</pre>

{{MER-autoTable_rfrsh
| relation = 48497
| type = node
| topic = List of Gobeletplain Cafés
| width = 550
| column1sort = no
| column1name = Name
| column1tag = name
| column1width =
| column1link = yes
| column2sort =
| column2name = City
| column2tag = is_in:city
| column3sort =
| column3name = Country
| column3tag = is_in:country
| column4sort = no
| column4name = Note
| column4tag = ldata:note
| column5sort =
| column5name =
| column5tag =
| column6sort =
| column6name =
| column6tag =
| column7sort =
| column7name =
| column7tag =
| column8sort =
| column8name =
| column8tag =
| column9sort =
| column9name =
| column9tag =
}}

=Tests=
{{MER-autoTable_rfrsh
| search1 = name/Gobeletplain
| type = node
| topic = List of Gobeletplain Cafés
| width = 550
| column1sort = no
| column1name = Name
| column1tag = name
| column1width =
| column1link = yes
| column2sort =
| column2name = City
| column2tag = is_in:city
| column3sort =
| column3name = Country
| column3tag = is_in:country
| column4sort = no
| column4name = Note
| column4tag = ldata:note
| column5sort =
| column5name =
| column5tag =
| column6sort =
| column6name =
| column6tag =
| column7sort =
| column7name =
| column7tag =
| column8sort =
| column8name =
| column8tag =
| column9sort =
| column9name =
| column9tag =
}}

[[Category:Templates Mergania]]
[[Category:Templates overpass query]]
[[Category:Templates User:MStr]]</noinclude>

@@ Line 306: / Line 306: @@
 [[Category:Autotable templates]]
-[[Category:Mergan Templates]]
+[[Category:Mergan templates]]
 [[Category:Overpass templates]]</noinclude>

@@ Line 305: / Line 305: @@
 }}
-[[Category:Templates autotable]]
+[[Category:Autotable templates]]
-[[Category:Templates Mergania]]
+[[Category:Mergan Templates]]
-[[Category:Templates overpass query]]
+[[Category:Overpass templates]]</noinclude>

@@ Line 21: / Line 21: @@
 {{#clear_external_data:}}{{#get_web_data:url=https://osm3s.opengeofiction.net/api/interpreter?data={{#if:{{{area|}}} | <!--
-########################### Mergany
+########################### Mergania
 -->{{#ifeq:{{{area}}} | MER |
@@ Line 177: / Line 177: @@
 }} |}
 {{#clear_external_data:}}
-|}
+|} [[Category:Site using autotable]]
 </includeonly><noinclude>

@@ Line 73: / Line 73: @@
 -->{{ #If:{{{collapsible|}}} |
 {{ #If:{{{collapsed|}}} |
-{{{!}} class=&quot;wikitable sortable mw-collapsible mw-collapsed;&quot; |
+{{{!}} class="wikitable sortable mw-collapsible mw-collapsed;" |
-{{{!}} class=&quot;wikitable sortable mw-collapsible&quot; }} |
+{{{!}} class="wikitable sortable mw-collapsible" }} |
-{{{!}} class=&quot;wikitable sortable&quot; }} style=&quot;text-align:left; width:{{{width|500}}}px;&quot;
+{{{!}} class="wikitable sortable" }} style="text-align:left; width:{{{width|500}}}px;"
 |-
-! class=&quot;unsortable&quot; style=&quot;background:#{{{bgcolor|CCCCFF}}};&quot; {{ #If:{{{column9tag|}}} |
+! class="unsortable" style="background:#{{{bgcolor|CCCCFF}}};" {{ #If:{{{column9tag|}}} |
-colspan=&quot;9&quot; | {{ #If:{{{column8tag|}}} |
+colspan="9" | {{ #If:{{{column8tag|}}} |
-colspan=&quot;8&quot; | {{ #If:{{{column7tag|}}} |
+colspan="8" | {{ #If:{{{column7tag|}}} |
-colspan=&quot;7&quot; | {{ #If:{{{column6tag|}}} |
+colspan="7" | {{ #If:{{{column6tag|}}} |
-colspan=&quot;6&quot; | {{ #If:{{{column5tag|}}} |
+colspan="6" | {{ #If:{{{column5tag|}}} |
-colspan=&quot;5&quot; | {{ #If:{{{column4tag|}}} |
+colspan="5" | {{ #If:{{{column4tag|}}} |
-colspan=&quot;4&quot; | {{ #If:{{{column3tag|}}} |
+colspan="4" | {{ #If:{{{column3tag|}}} |
-colspan=&quot;3&quot; | {{ #If:{{{column2tag|}}} |
+colspan="3" | {{ #If:{{{column2tag|}}} |
-colspan=&quot;2&quot; | {{ #If:{{{column1tag|}}} |
+colspan="2" | {{ #If:{{{column1tag|}}} |
-colspan=&quot;1&quot; }} }} }} }} }} }} }} }} }} | {{{topic|Table}}}
+colspan="1" }} }} }} }} }} }} }} }} }} | {{{topic|Table}}}
-! class=&quot;unsortable&quot; style=&quot;background:#{{{bgcolor|CCCCFF}}}; text-align:right; width:50px;&quot; | {{Refresh}}
+! class="unsortable" style="background:#{{{bgcolor|CCCCFF}}}; text-align:right; width:50px;" | {{Refresh}}
 |-
 {{ #If:{{{column1tag|}}} |
 {{ #If:{{{column1sort|}}}{{{column1width|}}} |
 ! {{ #If:{{{column1sort|}}} |
-class=&quot;unsortable&quot; }} {{ #If:{{{column1width|}}} |
+class="unsortable" }} {{ #If:{{{column1width|}}} |
-style=&quot;width:{{{column1width}}}px;&quot; }} {{!}} | ! }} {{{column1name}}}
+style="width:{{{column1width}}}px;" }} {{!}} | ! }} {{{column1name}}}
 {{ #If:{{{column2tag|}}} |
 {{ #If:{{{column2sort|}}}{{{column2width|}}} |
 ! {{ #If:{{{column2sort|}}} |
-class=&quot;unsortable&quot; }} {{ #If:{{{column2width|}}} |
+class="unsortable" }} {{ #If:{{{column2width|}}} |
-style=&quot;width:{{{column2width}}}px;&quot; }} {{!}} | ! }} {{{column2name}}}
+style="width:{{{column2width}}}px;" }} {{!}} | ! }} {{{column2name}}}
 {{ #If:{{{column3tag|}}} |
 {{ #If:{{{column3sort|}}}{{{column3width|}}} |
 ! {{ #If:{{{column3sort|}}} |
-class=&quot;unsortable&quot; }} {{ #If:{{{column3width|}}} |
+class="unsortable" }} {{ #If:{{{column3width|}}} |
-style=&quot;width:{{{column3width}}}px;&quot; }} {{!}} | ! }} {{{column3name}}}
+style="width:{{{column3width}}}px;" }} {{!}} | ! }} {{{column3name}}}
 {{ #If:{{{column4tag|}}} |
 {{ #If:{{{column4sort|}}}{{{column4width|}}} |
 ! {{ #If:{{{column4sort|}}} |
-class=&quot;unsortable&quot; }} {{ #If:{{{column4width|}}} |
+class="unsortable" }} {{ #If:{{{column4width|}}} |
-style=&quot;width:{{{column4width}}}px;&quot; }} {{!}} | ! }} {{{column4name}}}
+style="width:{{{column4width}}}px;" }} {{!}} | ! }} {{{column4name}}}
 {{ #If:{{{column5tag|}}} |
 {{ #If:{{{column5sort|}}}{{{column5width|}}} |
 ! {{ #If:{{{column5sort|}}} |
-class=&quot;unsortable&quot; }} {{ #If:{{{column5width|}}} |
+class="unsortable" }} {{ #If:{{{column5width|}}} |
-style=&quot;width:{{{column5width}}}px;&quot; }} {{!}} | ! }} {{{column5name}}}
+style="width:{{{column5width}}}px;" }} {{!}} | ! }} {{{column5name}}}
 {{ #If:{{{column6tag|}}} |
 {{ #If:{{{column6sort|}}}{{{column6width|}}} |
 ! {{ #If:{{{column6sort|}}} |
-class=&quot;unsortable&quot; }} {{ #If:{{{column6width|}}} |
+class="unsortable" }} {{ #If:{{{column6width|}}} |
-style=&quot;width:{{{column6width}}}px;&quot; }} {{!}} | ! }} {{{column6name}}}
+style="width:{{{column6width}}}px;" }} {{!}} | ! }} {{{column6name}}}
 {{ #If:{{{column7tag|}}} |
 {{ #If:{{{column7sort|}}}{{{column7width|}}} |
 ! {{ #If:{{{column7sort|}}} |
-class=&quot;unsortable&quot; }} {{ #If:{{{column7width|}}} |
+class="unsortable" }} {{ #If:{{{column7width|}}} |
-style=&quot;width:{{{column7width}}}px;&quot; }} {{!}} | ! }} {{{column7name}}}
+style="width:{{{column7width}}}px;" }} {{!}} | ! }} {{{column7name}}}
 {{ #If:{{{column8tag|}}} |
 {{ #If:{{{column8sort|}}}{{{column8width|}}} |
 ! {{ #If:{{{column8sort|}}} |
-class=&quot;unsortable&quot; }} {{ #If:{{{column8width|}}} |
+class="unsortable" }} {{ #If:{{{column8width|}}} |
-style=&quot;width:{{{column8width}}}px;&quot; }} {{!}} | ! }} {{{column8name}}}
+style="width:{{{column8width}}}px;" }} {{!}} | ! }} {{{column8name}}}
 {{ #If:{{{column9tag|}}} |
 {{ #If:{{{column9sort|}}}{{{column9width|}}} |
 ! {{ #If:{{{column9sort|}}} |
-class=&quot;unsortable&quot; }} {{ #If:{{{column9width|}}} |
+class="unsortable" }} {{ #If:{{{column9width|}}} |
-style=&quot;width:{{{column9width}}}px;&quot; }} {{!}} | ! }} {{{column9name}}} }} }} }} }} }} }} }} }} }}
+style="width:{{{column9width}}}px;" }} {{!}} | ! }} {{{column9name}}} }} }} }} }} }} }} }} }} }}
-! class=&quot;unsortable&quot; | Map
+! class="unsortable" | Map
 |-
 {{#for_external_table:<nowiki/>
@@ Line 173: / Line 173: @@
 [[{{{{{{column9tag|}}}}}}]] | {{{{{{column9tag|}}}}}}
 }} }} }} }} }} }} }} }} }} }}
-{{!}} [[File:OGFmapicon.png|18px|link=]] <span class=&quot;plainlinks&quot;>[https://opengeofiction.net/{{{type}}}/{{{{{{type}}}_id}}} map]</span>
+{{!}} [[File:OGFmapicon.png|18px|link=]] <span class="plainlinks">[https://opengeofiction.net/{{{type}}}/{{{{{{type}}}_id}}} map]</span>
 {{!}}-
 }} |}