Passing tagnames to PE expression in PI-OLEDB

Discussion created by rodriguy on Mar 3, 2009
Latest reply on Mar 4, 2009 by spilon

Is it possible to pass several tags at once to return the result of a PE expression in SQL?


I want to calculate the average of a list of tags for last month and my expression is as follow:


SELECT "value" FROM "piarchive".."picalc" WHERE expr = 'TagAvg(''sinusoid'',BOM(Bom(''*'')-1),Bom(''*''))' AND time ='*'




Instead of passing the tag directly (SINUSOID), I want to pass the tag name stored as an alias under a module in MDB and have the equation pick that tagname






Yanelly Rodriguez