1 Reply Latest reply on Oct 16, 2009 12:44 PM by andreas

    displaying setpoints with AF

    bfrancken

      Hi all,

       

      We're working at an AF project concerning electrical plants and we want to add setpoints (in the future) to AF in a way processbook can display them. These data is saved in a database as timestamp - value and the customer would prefer to use standard AF applications to display them. We were thinking about the build in tables in AF to save the data and use the 'Table lookup' datareference with following query:

       

      "SELECT Value FROM TestTable WHERE Time >= '%Time%'"

       

      But because the Time displayed in this query is not the 'query time' but the local pc time this doesnt work, and even gives an 'Object reference not set to an instance of an object.' in client applications (processbook).

       

      So at the moment we're looking for a substitution parameter for the query date or another means to do it.

        • Re: displaying setpoints with AF
          andreas

          Hi,

           

          I would like to invite you to contact our Technical Support team instead (TechSupport@osisoft.com - +1-510-297-5828 ). The OSIsoft vCampus program and its various features are really meant for programming, development and integration topics. Just like Microsoft's MSDN. On the other hand, "end-user" and "PI administration" questions (e.g. installation, configuration, usage, etc.) are still best handled by our technical support team.

           

          However, there is a workaround if you are using PI AF 2.1 or later:

           

          You must have a tag that serves as the basis for providing high-resolution timestamps. AF essentially does an inner JOIN between a PI tag's timestamps and the timestamps in the relational table. Thus, your PI point must have matching timestamps to ensure all data is retrieved. For example, if you have a timestamp of "6/1/2009 12:00:00 am" in the table, but do not have that timestamp for a value in the PI tag, AF will not provide that value from the table.

           

          For more details, you should have a PM from a TechSupport representative already

           

          Regards,