Skip navigation
All Places > All Things PI - Ask, Discuss, Connect > Ideas

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

score 3
You have not voted Submitted

Originally posted on UserVoice
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.