Template:QualIN: Difference between revisions

Revision as of 08:41, 15 December 2021

During Error: no local variable "year" has been set. the site received tonnes as qualifying material, as broken down below.

@@ Line 1: / Line 1: @@
 {{#clear_external_data:}}
-{{#get_db_data: db=engy
+{{#get_db_data: db=engy|from=mrfin2020|where=epr='{{{EPR}}}'|limit=1|data=year=year}}{{#vardefine: year|{{#external_value: year}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=mrfin2020|where=epr='{{{EPR}}}'|data=ton=sum(tonnes)}}{{#vardefine: total|{{#external_value:ton}}}}{{#clear_external_data:}}
-|from=mrfin2020
-|where=epr='{{{EPR}}}'
-|limit=1
-|data=year=year
-}}{{#vardefine: year|{{#externa_value: year}}}}
-{{#clear_external_data:}}
-{{#get_db_data: db=engy
-|from=mrfin2020
-|where=epr='{{{EPR}}}'
-|data=ton=sum(tonnes)
-}}{{#vardefine: total|{{#external_value:ton}}}}
-{{#clear_external_data:}}
 ==Qualifying Waste Entering Site==
 During {{#var:year}} the site received {{#var:total}} tonnes as qualifying material, as broken down below.