Menu
▾
▴
#41 Sort Not Working on Panel Grid
In my developed application, I have selected Can Sort on the grid column properties and the column header responds to clicks (up and down arrows designating sort direction show up), however, the data in the grid doesn't actually sort. Is there a setting somewhere that I'm missing that will make the data in the grid sort when clicking on the column headings?
Look at the log file generated by Platorom on the server side:
<yourinstallationpath>/logs/platform.log</yourinstallationpath>
You can check out which SQL query is executed when you click on a column header to sort it.
Probably there is not any problem: you simply have clicked on multiple columns to sort and, consequently, additional order by clauses have been added to the base SQL query.
Bear in mind that every time you click on a column a new clause it added. Example:
Threrefore, you could not notice any change in data on the grid, but that's due to the first order by condition!
Hello...
Thank you for your response. I got the sort to work by taking the ORDER BY clause off of the business component. However, now the original sort is via the SELECT clause, whichh starts with a numeric key value. Maybe i need to remove the key value from the SELECT clause? Will the update/save still work if I do that?
Regards...Tom
Look at the log file generated by Platorom on the server side:<yourinstallationpath>/logs/platform.logYou can check out which SQL query is executed when you click on a column header to sort it.
Probably there is not any problem: you simply have clicked on multiple columns to sort and, consequently, additional order by clauses have been added to the base SQL query.
Bear in mind that every time you click on a column a new clause it added. Example: </yourinstallationpath>
Threrefore, you could not notice any change in data on the grid, but that's due to the first order by condition! [tickets:#41] Sort Not Working on Panel GridStatus: open
Milestone: 5.2.1
Created: Fri Jun 09, 2017 02:42 PM UTC by Tom Malick
Last Updated: Fri Jun 09, 2017 02:42 PM UTC
Owner: nobodyIn my developed application, I have selected Can Sort on the grid column properties and the column header responds to clicks (up and down arrows designating sort direction show up), however, the data in the grid doesn't actually sort. Is there a setting somewhere that I'm missing that will make the data in the grid sort when clicking on the column headings?Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/xwsplatform/tickets/41/To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
Hi!
It is really hard to understand what you are saying...
What does it mean: i need to remove the key value from the SELECT clause? Will the update/save still work if I do that?