Forum
17:50
31/05/2013
Hello,
I have a grid where there is a row called 'Priority' when the user presses on the header of that row, JQGrid sorts the grid but it orders it placing the value 'A' before 'A1' that is the logical thing. The problem is that I want to force it to be opposite so I developed this query that it works in my SQL Server:
"CASE Prioridad
WHEN 'A1' THEN 1
WHEN 'A' THEN 2
WHEN 'B' THEN 3
WHEN 'C' THEN 4
WHEN 'E' THEN 5
ELSE Prioridad + 6 END, Prioridad"
I applied it in my code (I use JQgrid for PHP) as follows:
$colo = <<<ONSORTCOL
function (index, columnIndex, sortOrder) {
if(index=='Prioridad'){
$("#grid").jqGrid('setGridParam',{
sortname: "CASE Prioridad WHEN 'A1' THEN 1 WHEN 'A' THEN 2 WHEN 'B' THEN 3 WHEN 'C' THEN 4 WHEN 'E' THEN 5 ELSE Prioridad + 6 END, Prioridad "+sortOrder});
// trigger the grid
$("#grid").trigger('reloadGrid');
// return stop to prevent other things
return 'stop'
}
}
ONSORTCOL;
$grid->setGridEvent('onSortCol',$colo);
But JQGrid automatically removes the " ' " character, and does the same with the " ( " and ") " characters if I replace the chars for CHAR(65) for example.
Do you have any ideas?
Thanks in advance.
Most Users Ever Online: 715
Currently Online:
36 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66