Hello,
This is possible and depend on your need.
First of all your setting srcformat: ‘U/1000’ is not correct and Gurddo will not recognize this format. You should perform calculations for the Unix timestamp before to pass the data to jqGrid.
1. First option is to show the time offset without to inform user about this. This is done with the settings userLocalTime set to true in format options.
|
1 2 |
{ name : 'approveDate', index : 'approveDate', width : 100,search:true,searchoptions: { dataInit: dateFieldsInit}, editable : false,formatter:'date',formatoptions: {srcformat: 'U', newformat: 'Y-m-d H:i:s', userLocalTime : true } } |
2. You can use either the option O or T newformat. In this case userLocalTime should be set to false
|
1 2 |
{ name : 'approveDate', index : 'approveDate', width : 100,search:true,searchoptions: { dataInit: dateFieldsInit}, editable : false,formatter:'date',formatoptions: {srcformat: 'U', newformat: 'Y-m-d H:i:s O' } } |
or
|
1 2 |
{ name : 'approveDate', index : 'approveDate', width : 100,search:true,searchoptions: { dataInit: dateFieldsInit}, editable : false,formatter:'date',formatoptions: {srcformat: 'U', newformat: 'Y-m-d H:i:s T' } } |
The T option give more information.
Everthing is explained into the documentation
Kind Regards
Will
Guriddo Support Team
Hello,
I suppose your data is local. It is not important if you parse the the data to integer, but it is important the definition in colModel – for this purpose you will need to define the sort type of the column.
By default if there is no definition Guriddo sorts the data as text. In order to fix your problem you will need to set the property sorttype More on this you can find into the docs here
The code should look like this
|
1 2 3 4 5 6 7 8 9 10 |
colModel: [ ... { name: 'price', index: 'price', sorttype : 'integer', ... }, ... ] |
Kind Regards
Will
Guriddo Support Team
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top
