How can we improve PI Developer Technologies for you?

Automatically update Transpose Function in SQL Commander when referenced Element Template name is updated

In PI SQL Commander, users can create Transpose Functions that are linked to Element Templates in AF. When the referenced Element Template is renamed in PI System Explorer, the Transpose Function in PI SQL Commander is no longer able to find the Element Template which breaks the Function and underlying Data Table.

Users are not aware that the Transpose Function or the underlying Transpose Data Table are broken until they attempt to query the Table or Transpose Function. It would be ideal if the Transpose function could either update this reference automatically or if the function referenced the GUID of the Element Template instead of its name so that renaming the template doesn't break this reference.

1 vote
Sign in Sign in with OSIsoft
Signed in as (Sign out)

We’ll send you updates on this idea

Jason Jian-Hao Lu shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in Sign in with OSIsoft
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base

Posted ideas will have one of the following statuses.
Full definition of these statuses can be found on the Home Page.
No status
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA
COMPLETED