jQuery Grid Plugin - jqGridForum

Topic RSS

Treegrid date sorting

10/11/2009
08:20

Marcel Karras

Member

Members

Forum Posts: 22

Member Since:
19/03/2009

Offline

Hello,

I've found a problem by sorting a treegrid column by date. I used the same column model as in non-tree grids (there everything works fine) but the attempt to sort the date column will sort the date letter by letter. It seems if the date formatter I use isn't recognized correctly. I use the formatter "date" and the options "srcformat: 'Y-m-d', newformat: 'd.m.Y' " to display a localized date string.

The treegrid examples on the jqgrid demo pages don't show a date formatted column, furthermore the "Debit" column in the examples won't get sorted correctly either.

Is this a bug or am I missing something?

Greetings

- Marcel Karras

10/11/2009
08:27

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

It is not a bug. The problem is that in tree grid mode the sorting is at client side. For this purpose you should set sorttype option in colModel in order all to work. Ok. See docs.

Best Regrds

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

15/02/2010
16:25

Marcel Karras

Member

Members

Forum Posts: 22

Member Since:
19/03/2009

Offline

Hello Tony,

thanks for your comment on that. I did like you told me but it doesn't work. These are the treegrid options I use:

({

   url: 'https://...',
   datatype: 'json',
   sortname: 'start_date',
   sortorder: 'asc',
   rowList: [50,100,250,500,750],
   rowNum:100,
   mtype: 'POST',
   viewrecords: true,
   imgpath: 'https://...',
   width: '...',
   height: '...',
   pager: jQuery("#pager"),
   forceFit: true,
   treeGrid: true,
   treeGridModel: 'adjacency',
   ExpandColumn: 'prm_states.name',
   colModel : [
      { label: '...',name: 'prm_states.name',width: '650',align: 'left',sortable: true,search: true},
      { label: '...',name: 'state_owner',width: '200',align: 'left',sortable: true,search: true},
      { label: '...',name: 'prm_states.start_date',width: '100',align: 'center',sortable: true,search: false,
         formatter: 'date',
         formatoptions: {srcformat: 'Y-m-d',newformat: 'd.m.Y'},
         sorttype: 'date',datefmt: 'Y-m-d'}
})

Maybe the datatype "json" is the problem?

Greetings

- Marcel Karras

15/02/2010
16:52

Marcel Karras

Member

Members

Forum Posts: 22

Member Since:
19/03/2009

Offline

Ah,...

datefmt: 'd.m.Y'

... did the job. 🙂 Thanks so far.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
44 Guest(s)

Currently Browsing this Page:
1 Guest(s)