I want to inquire about the maximum and minimum daily values and average values through PI-ODBC. I have written a wrong statement. At present, I can not find a good way, so I can only ask you for advice and advice.
It might be helpful to know what was your query statement in order to troubleshoot the issue.
The simplist syntax goes as below:
SELECT * FROM [piarchive]..[pimax] WHERE tag = 'sinusoid' AND time BETWEEN '*-1d' AND '*'
Please let us know how you are writing the SQL query for more detail.
Thank you. My SQL was written incorrectly before.
I have another question.I see other tables in PISDk,
such as PIinterp, Pimin, Pimaxm, Piavg, Pimean.
I want to know what data these tables contain and
whether I can use them directly.
Glad it helped.
The table definitions are contained in the PI OLEDB Provider User Guide. Please find either 'Compendium' or 'Table Reference' section in the user guide.For a short intro:
Thank you. PI is very powerful. The resources about PI in my place are very limited, so I have to turn to you.
We are here and happy to help!
Retrieving data ...