What's the Webtag for Annual ET

[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

[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.

[kevinTDWX]

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

[kevinTDWX]

Thank you Mark, for adding annual ET total <#AnnualET> to build 3169
Regards, Kevin

[mcrossley]