Is there any document on SQL database of PI Vision so that we can mess around while using a testing environment?
I came across a topic on how to bulk-change navigation links using SQL query and wondered if this is well documented.
Is there any document on SQL database of PI Vision so that we can mess around while using a testing environment?
I came across a topic on how to bulk-change navigation links using SQL query and wondered if this is well documented.
We do not document our database schema. You would be better off messing around with the public API: https://docs.aveva.com/bundle/pi-vision-api-reference/page/overview.html
Thank you JSwar for the suggestion. Is this the only available option as of now if I want to bulk-change something within my displays i.e changing the navigation links into non-IP-specific URLs?
This is the only documented way I can think of for the changes you mention. You can bulk-change your data servers and databases, display owners, and a few other things using the display utility, but nothing related to navigation links.
Damian Nguyen, for the specific issue of updating link URLs from absolute links to relative links, please see this article (Navigation Links to Displays Not Working After PI Vision Server Name Change) and contact Technical Support. They can help.
Thanks anyway, I'll try with the LinkUrl key to see if it helps.