Template:WalesLAMetric: Difference between revisions

No edit summary
No edit summary
 
Line 1: Line 1:
{{#clear_external_data:}}
{{#get_db_data: db=ID| from=wales_joined |limit=1|data=period=period}}
For reporting period: {{#external_value:period}}{{#clear_external_data:}}
{{#clear_external_data:}}
{{#clear_external_data:}}
{{#get_db_data: db=ID |from=wales_joined |where=gsscode='{{{gss}}}' |data=tmwcg=tmwcg,hhwrr=hhwrr,hhwc=hhwc,nhhwrr=nhhwrr,nhhwc=nhhwc,trrc=trrc,w2rec=w2rec,recrecy=recrecy,reccomp=reccomp,incinengy=incinengy,incinnoengy=incinnoengy,lfill=lfill,hhwrrpc=hhwrrpc,hhwcpc=hhwcpc,nhhwrrpc=nhhwrrpc,nhhwcpc=nhhwcpc,wrrccpc=wrrccpc,hhwpp=hhwpp,rnkkkwrec=rnkkkwrec,rnkhhwpp=rnkhhwpp}}
{{#get_db_data: db=ID |from=wales_joined |where=gsscode='{{{gss}}}' |data=tmwcg=tmwcg,hhwrr=hhwrr,hhwc=hhwc,nhhwrr=nhhwrr,nhhwc=nhhwc,trrc=trrc,w2rec=w2rec,recrecy=recrecy,reccomp=reccomp,incinengy=incinengy,incinnoengy=incinnoengy,lfill=lfill,hhwrrpc=hhwrrpc,hhwcpc=hhwcpc,nhhwrrpc=nhhwrrpc,nhhwcpc=nhhwcpc,wrrccpc=wrrccpc,hhwpp=hhwpp,rnkkkwrec=rnkkkwrec,rnkhhwpp=rnkhhwpp}}