Hello,
You do not need to write this question two times. See my previous post.
Kind Regards,
Will
Guriddo Support Team
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,
Thanks. We are not aware of this problem in 5.5.2 version.
Kind Regards,
WIll
Guriddo Support Team
Hello,
We can not reproduce your problem, since we do not know anything.
Please prepare a WORKING demo, so that we can see what is happen.
Thank you
Kind Regards,
Will
Guriddo Support Team
Hello,
We have fixed the problem. If you want to test the fix, please let us know on the support e-mail.
Kind Regards,
Will
Guriddo Support Team
Hello,
Thank you for demo.
Should I suppose that your question is that this should not happen or…?
I see that there are other keys that should be disabled too – Home, End, Ins, PgUp, pgDn,
We will try to fix this in the next days.
Kind Regards,
Will
Guriddo Support Team
Hello,
In your replace_format function for that field you will need to replace the comma too in order excel to parse the data correct.
1 2 3 4 5 |
... {name:'curSalePrice',index:'curSalePrice',width:65,align:"right",search:false,formatter:'currency' ,formatoptions:{decimalSeparator:'.',thousandsSeparator: ',',decimalPlaces:2,prefix:'$'} ,exportoptions:{excel_parsers:false,excel_format:"[$$-45C]\#,##0.00_-",replace_format:function(v){return v.replace('$','').replace(',','');}} ... |
Kind Regards,
Will
Guriddo Support Team
Hello,
Again I’m not sure that I undersatnd correct the question.
Maybe you want to use multi sort function – see here
multiSort property or maybe you want to apply your custom sort function. See docs for custom multisort.
Regards,
Will
Guriddo Support Team
Hello,
I’m not sure that I understand the question. What you mean with secondary sort?
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
Hello,
We have fix this problem for Bootstrap4.
Thanks and sorry for delay in the answer.
Kind Regards,
Will
Guriddo Support Team
Hello,
The searchField, searchOper, and searchString field values are not present in filterToolbar method. These are valid only in certain cases in form searching (this is a old behaviour)
Instead of this use the filters property and accept it in the server. I recommend you to read this docs Here we describe what is posted to the server when searching
Kind Regards
Will
Guriddo Support Team
Hello,
For us it is working. We use not the latest version 5.15.1, but 5.14. It seems that the last version is not yes published online.
We use the following CSS:
1 2 3 |
< link rel="stylesheet" type="text/css" media="screen" href="../../../css/trirand/ui.jqgrid-bootstrap4.css" /> < link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css"> < link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.14.0/css/all.css"> |
Be a sure you have a icon_base : fas
If you have problems, we can prepare a online demo
Kind Regards,
Will
Guriddo Support Team
Hello,
Unfortunately column names can not contain commas in multi-sort, since the name with comma is treated as two names, because the separator in multi-sorting is “,”.
It is highly recommend that column names should contain only letters and numbers.
Kind Regards,
Will
Kind Regards
Guriddo Support Team
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top