This topic is locked
[SOLVED]

 Chart TOP 10 trouble

4/24/2018 5:18:13 AM
PHPRunner General questions
L
Levani author

Hi all! I have a little problem using charts in phprunner and I don't know exactly what to do to solve it:
We want to obtain a list of the 10 values that fail the most regarding the percentage. Using the TOP 10 statement in the SELECT, we obtain these 10 values.


Values obtained when executing the query PHPRunner 9.0:


When viewing the query -> build. View in browser, we get this error: SELCET TOP 1 TOP 10


We have tried with an alternative, SET ROWCOUNT 10 to visualize only 10 columns, the result of the execution of the query is correct, it shows the 10 columns, but when viewing it in the browser, another error related to TOP 1 appears.



We believe that the error may be here


We have tried to modify the"Record per page to 0" but there are still problems. There would be some way to be able to visualize 10 results in a CHART?

jadachDevClub member 4/24/2018

Try using a prepared view from your database.

admin 4/24/2018

You cannot add "TOP 10" directly to the query. Use PHPRunner 9.8 where you can specify how many records to select (Limit data to first ...):

https://xlinesoft.com/phprunner/docs/about_sql_query_designer.htm

L
Levani author 4/27/2018

Ty all

Thanks for the answers