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 31: / Line 31: @@
 tables=FloodReports
 |fields = COUNT(_pageName)
-|where=Country='{{PAGENAME}}' OR OtherCountry HOLDS '{{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.
+}}
 [[Category:Subdivisions]]