Page 1 of 1
What's the Webtag for Annual ET
Posted: Fri 21 Jan 2022 8:24 am
by kevinTDWX
I'm using the Custom Minute MYSQL feature to update the Monthly data table every 5 minutes. The column for AnnualEvapTran does not populate (stays at 0.00) using a webtag <#ETyear> that I guessed would work. I can't seem to find what the actual webtag is, after doing a search of this forum or the wiki. Any clue what that webtag is?
Regards, Kevin
Re: What's the Webtag for Annual ET
Posted: Fri 21 Jan 2022 12:49 pm
by Mapantz
There isn't a webtag for that, as far as I am aware?!
The way to get a total in SQL, I would guess..
Is to just populate the AnnualEvapTran table using the custom SQL at rollover function.
You'd have to use:
<#metdateyesterday>
INSERT IGNORE INTO AnnualEvapTran (LogDate,TotalEvap) VALUES ('<#metdateyesterday format=yyyy-MM-dd>',<#ET>);
You could then call back the full total of that table.
Re: What's the Webtag for Annual ET
Posted: Fri 21 Jan 2022 8:48 pm
by kevinTDWX
Mapantz wrote: ↑Fri 21 Jan 2022 12:49 pm
There isn't a webtag for that, as far as I am aware?!
The way to get a total in SQL, I would guess..
Is to just populate the AnnualEvapTran table using the custom SQL at rollover function.
You'd have to use:
<#metdateyesterday>
INSERT IGNORE INTO AnnualEvapTran (LogDate,TotalEvap) VALUES ('<#metdateyesterday format=yyyy-MM-dd>',<#ET>);
You could then call back the full total of that table.
Okay, thanks.. I'll give that a try
Regards, Kevin
Re: What's the Webtag for Annual ET
Posted: Mon 31 Jan 2022 10:10 pm
by kevinTDWX
Thank you Mark, for adding annual ET total <#AnnualET> to build 3169
Regards, Kevin
Re: What's the Webtag for Annual ET
Posted: Tue 01 Feb 2022 9:13 am
by mcrossley
