I have an application to display the report in pi vision by user select time interval for hour in a day, shift in a day, day in a month.
Can I display the result of pi query on pi vision?
>Can I display the result of pi query on pi vision?
Do you mean pi query = PI Performance Equation Syntax?
If you use AF Analysis's expression function, attributes can get the calculation results.
From PI Vision, it can show the calculated result attribute.
If you don't want to create additional attributes, you can create custom symbol that can call PI Web API to get calculation results. So it should be able to display.
If it is not what you want, could you explain more details?
I mean pi query is sql statement query to pi server as a relational database.
i would like to make the reports by using sql statement query to pi server and then the reports result are displayed in tables on pi vision.
do you have some examples? how to do it?
For getting results by SQL query, you need to use PI ODBC, PI OLEDB, PI JDBC Drivers.
I think it is difficult to call these from PI Vision custom symbol. If you can get results by PI Web API, custom symbol works very well with it.
This is community example for showing time series data as table.
PI-Vision-Custom-Symbols/Community Samples/OSIsoft/timeSeriesDataTable at master · osisoft/PI-Vision-Custom-Symbols · Gi…
If you really need to run SQL query, one thing I can imagine is that you can import/link table by AF Table function and get the data from attirbute's table lookup.
thank you very for your help.
I have the report as below picture and i would like to display them on pi vision.
the summary reports can be selected for hour in a day, shift in a day, day in a month.
could you help to solve this?
Retrieving data ...