PI Vision Navigation Links Used in Multiple displays

Hello All,

We are looking for experts' opinion in here for our scenario here:

Problem Statement:

How to identify navigation links that are used in multiple displays.

Scenario:

We have few PI Vision displays: A, B, C. These displays have different navigation links used in them, along with PI Tags mapped to it and on the fly calculations. We plan to reference PI points used in these displays with AF Attributes & migrate on the fly calculations to AF Analysis.

Also, we want to have an asset-based vision display for the existing A, B & C displays. We are not sure if these displays A, B, C are being used elsewhere, as we do not want to have the links (if used) broken.

Tried to explore if we can track from SQL but not helpful, could anyone recommend the best way to find out?

Cheers,

0 MainelyInnovations 11 months ago
The official answer from AVEVA would be to do it through the API, but that's going to be extremely slow. Your best option is SQL.

Your base query can be as simple as the following. It will highlight any display that has a link. What you'll need to do is further refining on whether or not the links are ones you are interested in.
SELECT * FROM [PIVision].[dbo].[StandardDisplays] WHERE CHARINDEX('"LinkURL":', [EditorDisplay]) > 0 AND CHARINDEX('"LinkURL":""', [EditorDisplay]) = 0
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tmarothi_wipro 9 months ago in reply to MainelyInnovations

Thanks Much, it helped, we got the details with the query
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel