• Replies 5 replies
  • Subscribers 22 subscribers
  • Views 42 views
  • Users 0 members are here
Options
Related

PI SQL Query - ROW_NUMBER() ?

Javith Fareeth

PI SQL Query has multiple result. How can i add the row number. there is one example but that is for linked server.

My requirement is for PI SQL client and i read the result back to AF attribute.

Parents

  • I also have a use case for this functionality.

     

    I have bad actor KPI's relating to lots of assets - a dynamic number, and I want to be able to query to determine what are my top bad actors. So I used the PI SQL Client driver to do the searching and sorting of the results and have this as a liked table in AF (back to itself). I then want to display say the top 5 bad actors on each site. However there is no way in a table lookup attribute DR to extract a specific row number. It only lets you choose the first row returned.

     

    Ultimately this will displayed in a PI Vision page so maybe a custom symbol could be written to display the table, but I am not a JavaScript guru so I want to avoid this at all costs. And I have limits on tags so cannot go wild with an Analysis solution.

     

    If PI SQL Client would support returning a specific row, or the table lookup DR supported returnign a specific row number that would make this kind of use case easy to implement.

Reply

  • I also have a use case for this functionality.

     

    I have bad actor KPI's relating to lots of assets - a dynamic number, and I want to be able to query to determine what are my top bad actors. So I used the PI SQL Client driver to do the searching and sorting of the results and have this as a liked table in AF (back to itself). I then want to display say the top 5 bad actors on each site. However there is no way in a table lookup attribute DR to extract a specific row number. It only lets you choose the first row returned.

     

    Ultimately this will displayed in a PI Vision page so maybe a custom symbol could be written to display the table, but I am not a JavaScript guru so I want to avoid this at all costs. And I have limits on tags so cannot go wild with an Analysis solution.

     

    If PI SQL Client would support returning a specific row, or the table lookup DR supported returnign a specific row number that would make this kind of use case easy to implement.

Children