Grouped column will always get first sort order. In working demo (link), i’ve used grouping with Ship_country but sorted with Ship_via field first. For that i have made a new column ship_country_2:

$g->select_command = “select *,concat(ship_via,’/’,ship_country) as ship_country_2 from orders”;

And make group field based on ship_country_2:

$grid[“groupingView”][“groupField”] = array(“ship_country_2“);

It will give desired result, but the display will also have like 1/Argentina, 1/Belgium. So we can remove it by:

$grid[“groupingView”][“formatDisplayField”] = array(
“function (displayValue, cm, index, grp) { displayValue = displayValue.substring(displayValue.indexOf(‘/’)+1); return displayValue[0].toUpperCase() + displayValue.substring(1).toLowerCase(); }”
);

Complete working demo here:

https://gist.github.com/gridphp/635e61165b066d6d7294021f39fc8ca2

Thanks Abu,

I implemented  what you suggested above in regard to sorting the group names and that solved the display issue of sorting the groups when the grid is loaded.

Here’s what I specified – $g3->select_command = SELECT *,concat(prn,’/’,med_name) as sort_prn_meds FROM medications WHERE first ….

The issue I’m seeing with this solution is if I now do an inline edit on one of the rows I get a SQL error stating that the column with the name – sort_prn_meds doesn’t exist (which it doesn’t).

The Save request is sending sort_prn_meds as a parameter to the server when I save the row edit.

Any ideas ?

Thanks,

Steve

Still not working …

I tried adding this in hopes of catching the edit operation on the backend to remove the “sort_prn_meds ” parm from the POST data …

$med_e[“on_update”] = array(“strip_concat_from_SQL”, null, true);

$g3->set_events($med_e);

function strip_concat_from_SQL($mydata) {
if ($_POST[“oper”] == “edit”) {
unset($_POST[‘sort_prn_meds’]);
}

}

But I still get this SQL error –

Couldn’t execute query. Unknown column ‘sort_prn_meds’ in ‘field list’ – UPDATE medications SET ….

Not sure how I can alter the actual SQL command, to remove this non existant column name, before the UPDATE is executed

Try this inside function:

unset($mydata[“params”][‘sort_prn_meds’]);

You can also do print_r / die on $mydata to see what is being used to make update query.

That did the trick. The SQL concat “column name” now get’s stripped on the backend from the parms used to build the SQL UPDATE command.

Thanks for all the help with this !!