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
Welcome to the Cumulus Support forum.
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4019) - 03 April 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024
Cumulus MX V4 beta test release 4.0.0 (build 4019) - 03 April 2024
Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)
Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki
What's the Webtag for Annual ET
Moderator: mcrossley
-
- Posts: 1808
- Joined: Sat 17 Dec 2011 11:55 am
- Weather Station: Davis Vantage Pro2
- Operating System: Windows 11 x64
- Location: Dorset - UK
- Contact:
Re: What's the Webtag for Annual ET
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.
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.
-
- Posts: 6
- Joined: Sun 14 Jun 2020 4:49 am
- Weather Station: Davis VP2 Plus
- Operating System: Windows 10 Pro 21H2
Re: What's the Webtag for Annual ET
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
-
- Posts: 6
- Joined: Sun 14 Jun 2020 4:49 am
- Weather Station: Davis VP2 Plus
- Operating System: Windows 10 Pro 21H2
Re: What's the Webtag for Annual ET
Thank you Mark, for adding annual ET total <#AnnualET> to build 3169
Regards, Kevin
Regards, Kevin