Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
onSortCol Custom sort
31/05/2013
17:50
Avatar
Atsistemas
New Member
Members
Forum Posts: 1
Member Since:
31/05/2013
sp_UserOfflineSmall Offline

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.

Forum Timezone: Europe/Sofia

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.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information