• State Not Answered
  • Replies 2 replies
  • Subscribers 3 subscribers
  • Views 143 views
  • Users 0 members are here
Options
Related

PI Vision Navigation Links Used in Multiple displays

tmarothi_wipro

 

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,

TM

Parents
  • 0

    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

     

Reply
  • 0

    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

     

Children