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?