Hi Abu, I have a query which runs fine on other projects and indeed inside phpmyadmin but not inside the grid. The grid doesn't like with rollup, any way around that?
In phpmyadmin it sums up the columns at bottom
adviser with rollup
Error it throws is 'Couldn't execute query. Incorrect usage of CUBE/ROLLUP and ORDER BY' even though I am not using an order by..
HI Abu, to follow this up I also note that using the grid it adds an extra column called 'Null', I cant even remove that using show hide. This query works fine in phpmyadmin and on other php projects I used so a bit confused why these 2 issues appear in the grid?
Code is here – http://pastebin.com/383gz4iD
You can try using main query inside subquery.
$g->select_command = "SELECT * FROM (SELECT client_id, SUM(total) FROM `invheader` GROUP BY client_id WITH ROLLUP) as t";
This way, order by will be applied to external and not conflict the rollup.
Thanks Abu, that sorted it after I set the sort in grid to't.Total ASC'.
Any ideas why the gris also places a NULL column on the end, this doesnt occur in plan php or phpmyadmin?
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?