YetAnotherForum
Welcome Guest Search | Active Topics | Log In | Register

Referencing PI Point using points in from a DB table Options · View
HDelesalle
#1 Posted : Sunday, January 16, 2011 8:46:32 PM
Rank: Newbie
Groups: Member

Joined: 1/16/2011
Posts: 1
Location: France
Hi all,

My question is about setting the configuration of an attribute to a PI point fetching the name of the PI point in a DB table.

In more detail :
I have a table with 3 cols :
Equipment_Name (eg "Pipe-234"),
Attribute_Name (eg "Temperature"),
PI_Point_Name (eg "PP234-T-VAL")

I have configured a template element with
a template attribute called name, holding the name of the equipment as a string : "Pipe-234"
a template attribute called Temp-Tag-Name, configured as a Table lookup and getting the PI Point Name from my table
My statement :(SELECT PI-POINT_NAME from MyTable where Equipment_Name =@Name and Attribute_Name = 'Temperature')

I would like to configure another template attribute named "Temperature" that would refer to the PI Point whose name is retrieved in Temp-Tag-Name....

Is that feasible with PI-AF using either the AF System Explorer or the PI-SDK ?

Thanks for any help.

HDelesalle.
France.
Sponsor  
 

OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System.
We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ  or contact OSIsoft vCampus for more details.
RJK Solutions
#2 Posted : Monday, January 17, 2011 1:36:55 PM
Rank: Administration

Groups: Administration

Joined: 6/20/2008
Posts: 617
Location: Cheshire, United Kingdom.
Hello,

Welcome to the forum.
Sure this is feasible, the joy of the Attribute Templates!

If you add a third Attribute Template to your Element Template, call the Attribute "Tag" and set it to the "PI Point" Data Reference. Then just set your config of the attribute to:

Code:

\\%Server%\%@Temp-Tag-Name%


BigGrin
Principal Consultant
Real-Time Data Management @ Wipro Technologies
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.