Searching for the Value of an AF Attribute in Web parts

Discussion created by DDeCastro on May 16, 2013
Latest reply on May 23, 2013 by Kapil.Rakh

I set up and AF database with 6 attributes -2 of which get data from PI Tags and 4 which get data from a table I set up.  The name of each element is a Meter Number which has attributes kWh and voltage from PI and Substation, Feeder, Acct# and Transformer # from the table in AF.  The data in the table can change from time to time (the feeder that supply's a meter can change or the meter's transformer # can change) and there are going to be ~1,000,000 meters in the table so I can't change it manually, instead I take an export from the database with the information and then import into AF.  What I want is to be able in web parts to search for a particular feeder/ACCT#, transformer#/Substation and have it return every meter associated with that value, then select a meter from this list and have a trend for both the Voltage and kWh.  Does anyone know of a way to do this?