PI Square

Forum PI Vision SQL database

State Verified Answer
Replies 5 replies
Subscribers 3 subscribers
Views 813 views
Users 0 members are here

Options

Related

PI Vision SQL database

Damian Nguyen over 2 years ago

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.

Top Replies

JSwar over 2 years ago +1 verified

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
JSwar over 2 years ago +1

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…
Brent bregenzer over 2 years ago in reply to Damian Nguyen +1

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…

Parents

0 JSwar over 2 years ago

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
Cancel
Vote Up +1 Vote Down

Sign in to reply

Reject Answer

Cancel
0 Damian Nguyen over 2 years ago in reply to JSwar

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?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Brent bregenzer over 2 years ago in reply to Damian Nguyen

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.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Brent bregenzer over 2 years ago in reply to Damian Nguyen

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.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data