Template:SubdivisionName: Difference between revisions

Latest revision as of 13:53, 13 February 2026

This is the "SubdivisionName" template. It should be called in the following format:

{{SubdivisionName:
 | Country=
 | M49=
 | SubdivisionCategory=
 | Code31662=
 | SubdivisionName=
}}

This template defines the table "SubdivisionNames". View table.

@@ Line 26: / Line 26: @@
 * M49: {{{M49}}}
 * Code31662: {{{Code31662}}}
+=Recorded floods for {{{SubdivisionName}}}=
+Total number of flood events: {{#cargo_query:
+tables=FloodReports
+|fields = COUNT(_pageName)
+|where=SubdivisionName HOLDS '{{PAGENAME}}'
+| format = plain
+}}'''
+{{#cargo_query:
+tables=FloodReports
+|fields=
+    CONCAT_WS('','[[',_pageName, '|', ReportNumber, ']]')=﹟,
+    GlideNumber=Glide ﹟,
+    BeginDate=Start Date,
+    EndDate=End Date,
+    Country=Country,
+    SubdivisionName=State,
+    FORMAT(Area,0)=Area (km²),
+    Source=Source,
+    MainCause=Main Cause,
+    NumberOfFatalities=Fatalities,
+    NumberOfDisplaced=Displaced,
+    Severity=Severity,
+    FORMAT(FloodImpactIndex,1)=Flood impact index
+|where=SubdivisionName HOLDS '{{PAGENAME}}'
+|hidden fields=Glide ﹟,Country,Source
+|order by=Start Date DESC
+|limit=6000
+|rows per page=25
+|link=ReportNumber
+|format=dynamic table
+|default=No flood reports found for this state.
+}}