Support Forums
about TagName_Current in SQLQuery

in the SQLQuery help page, there is a section "The current values of a tag may be retrieved using a table name with the format "TagName_Current". This table will have one row whose columns are Timestamp (the current time) and the current values of each logged value in the tag.".

How do I use the "TagName_Current"? Can you give me an example? Thanks.

in the [SQLQuery](https://www.vtscada.com/help/Content/Pro_Functions/SQLQuery.htm) help page, there is a section "The current values of a tag may be retrieved using a table name with the format "TagName_Current". This table will have one row whose columns are Timestamp (the current time) and the current values of each logged value in the tag.". How do I use the "TagName_Current"? Can you give me an example? Thanks.

I usually look for the current value (and basic data) starting from something like the following (I would use this as a REST query typically):

SELECT%20Name,%20ShortName,%20Description,%20Area,%20Value%20FROM%20Parms_AllTypes

Most of the info on the calls can be found here: https://www.vtscada.com/help/Content/D_LogAndReport/Dev_ODBCTableStructure.htm?tocpath=Use%20VTScada%7CLog%252C%20Note%252C%20and%20Report%7CSQL%20Queries%7C_____2

Here are some example queries: https://www.vtscada.com/help/Content/D_LogAndReport/Dev_SQLQueryExamples.htm?tocpath=Use%20VTScada%7CLog%252C%20Note%252C%20and%20Report%7CSQL%20Queries%7C_____3

I usually look for the current value (and basic data) starting from something like the following (I would use this as a REST query typically): **SELECT%20Name,%20ShortName,%20Description,%20Area,%20Value%20FROM%20Parms_AllTypes** **Most of the info on the calls can be found here:** https://www.vtscada.com/help/Content/D_LogAndReport/Dev_ODBCTableStructure.htm?tocpath=Use%20VTScada%7CLog%252C%20Note%252C%20and%20Report%7CSQL%20Queries%7C_____2 **Here are some example queries:** https://www.vtscada.com/help/Content/D_LogAndReport/Dev_SQLQueryExamples.htm?tocpath=Use%20VTScada%7CLog%252C%20Note%252C%20and%20Report%7CSQL%20Queries%7C_____3

Trihedral Engineering Ltd.

26
2
2
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft