How To Group Rows In JEasyUI DataGrid
Posted by admin on
April 1, 2013
When I first encountered this problem, there was no solution. Not even in the documentation of sample list of JEasyUI‘s portal.
However, I after I posted a topic in their forum to include it in a future release or so, probably after a day or two, they immediately created a Javascript library to do just that.
Impressive!
Look for the file datagrid-groupview.js and make sure you include that or else grouping rows won’t work in the data grid.
Retrieve your JSON data as is and simply assign the field that you want as basis for grouping the rows and changing the view’s value to groupview.
view: groupview, groupField: 'mycolumn',
That’s it! Easy as pie!
Donations appreciated. Every little $ helps. Or click Google +1.tags: datagrid, group, jeasyui, row
No Comments
MySQL: Show Results Of A Column As 1 Line
Posted by admin on
February 1, 2009
Say, your sql result will return multiple rows that may look something like this
| id | |
| 1 | email1@email.com |
| 1 | email2@email.com |
There is a pretty useful MySQL function that displays the email addresses found in the 2 rows as one. Using the GROUP_CONCAT(), e.g. GROUP_CONCAT(column_name separator_character) maybe result in something like this
| id | |
| 1 | email1@email.com email2@email.com |
The syntax used was SELECT id, GROUP_CONCAT(email, ‘ ‘) …
You can use any other character like comma.
Donations appreciated. Every little $ helps. Or click Google +1.
