My PI OLEDB SQL statement is:
"select top 1 time,value from picomp2 where tag='P1:PI11350' and time > '01/01/2008' and value > 363.0 order by time asc"
I got "[-11091] event collection exceeded the maximum allowed" error.
Our user wants me to search a PI tag value over certain max value for PI archived data from 10 years ago to now. All I need is just to find the first value and time of these archived data. I specified 'top 1' in my select statement, but it seems PI OLEDB collects all information first then picks the 'top 1' value for me. Any good alternative for my select statement?