PI SQL Query - ROW_NUMBER() ?

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.

Hello Simon Dyson and Javith Fareeth Basha,

You both have totally different use cases and both appear reasonable to me. I suggest you to post an enhancement request on Uservoice for the PI SQL Client.

Hello Simon Dyson and Javith Fareeth Basha,

You both have totally different use cases and both appear reasonable to me. I suggest you to post an enhancement request on Uservoice for the PI SQL Client.