2 Replies Latest reply on Jan 26, 2018 10:53 AM by igreguri

    SQL query in notification

    igreguri

      Is it possible to attach table (SQL query result) in notification?

       

      PI AF Server v2.9.2.8185

      PI Server v3.4.405.1198

        • Re: SQL query in notification
          jsanchezcolunga

          Hello Igor,

           

          Thank you for sharing your questions in PI Square!

           

          I believe in order to do that you should firstly link the SQL table to your AF Database. Then a Table Lookup Data Reference (TLDR) attribute will perform the query to that table and show the result. Finally you will be able to add the value of this TLDR to the notification message.

           

          Would this work for you?

           

          Kind regards,

          José