Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Historian

LIKE clause limitations

  • Last UpdatedMar 19, 2025
  • 1 minute read

The LIKE clause is only supported for the TagName and Value columns. The syntax " ... Value LIKE 'a string' ... " is only supported for a string table. For example:

SELECT TagName, Value FROM History

WHERE TagName LIKE 'Sys%'

AND DateTime > '1999-05-24 14:30:00'

AND DateTime < '1999-05-24 14:32:00'

TitleResults for “How to create a CRG?”Also Available in