AnsweredAssumed Answered

c# code to delete specific row from PI Archive using 'value' column in osi pi

Question asked by shekar on Jul 29, 2015
Latest reply on Jul 29, 2015 by shekar

Hi Team,


I want to delete the wrongly inserted values like 'Configure, I/O Timeout etc...' from PI Archive through PI OLEDB using c# code.


For this I tried the below command but it is not working.


Delete From [piarchive].[picomp2]   

Where ( value = 'Configure' or value = 'I/O Timeout' ) and tag = 'sinusoid' and time between '*-1h' and '*'


Can anyone provide me the solution to delete the data based on the value column.