Can you use the PITimeFilter function on Performance equation (PE) or Query/Open Query?
if it's possible can you tell me how to do it? maybe little example?
Thank you in Advance
With Performance Equations, you can use something like TimeEQ and it's family of functions. Note that they do not support intervals unlike PITimeFilter. Please see this documentation.
For an OLEDB query, it does support many PE Functions, such as the above. However, for a linked server, it does not recognize OLEDB-specific functions, so you would have to use a pass-through query. Please see the user manual, available here.
yes i've made the linked server. what i try to do is this:
('3120CVB011A.Power' + '3120CVB011B.Power' > 20)"
,"4/10/2015 6:00:00 AM",("4/10/2015 6:00:00 AM"+(23.5/24)),"1d","hours",0,"mnoytpi1")
this on OLEDB query. can you advice me on how to accomplish this? much appreciated.
Have another PE tag (named PETag) to archive the history of
IF 'tagA' > 50 and ('tabB' + 'tagC' >20) then 1 else 0
then use this query
SELECT cast(value as int32)/3600 as value
WHERE expr = 'TimeGe(''PETag'',''*'',''*+1d'',1)'
AND time BETWEEN '4/10/2015 6:00:00' AND '4/14/2015 5:30:00'
and timestep = '1d'
can this be done just on the Query without creating a new tag on PE. basically i don't want to use PE if possible.
Thanks again mate
Performance equations are not that powerful yet in that sense since the TimeEQ function only takes a tag as the argument and not an expression. I have also moved this question to PI SQL Data Access Technologies for continued discussion.
We'd like to follow up on this thread. Please let us know if you have further questions about the topic, and if not, could you mark one of Eugene's or Samuel's posts as Correct?
Retrieving data ...