We have a lot of changes inside Trirand. You may need to read this post

The forum is moved to another place.. All the existing users and forum posts are moved successfully in our new side guriddo.net

In the future, please post your questions and problems in the new place.

The existing forum will stay and will  be in read-only mode.

 

Kind Regards

Tony

 

We have a lot of changes inside Trirand. You may need to read this post

The forum is moved to another place.. All the existing users and forum posts are moved successfully in our new side guriddo.net

In the future, please post your questions and problems in the new place.

The existing forum will stay and will  be in read-only mode.

 

Kind Regards

Tony

 

We have a lot of changes inside Trirand. You may need to read this post

The forum is moved to another place.. All the existing users and forum posts are moved successfully in our new side guriddo.net

In the future, please post your questions and problems in the new place.

The existing forum will stay and will  be in read-only mode.

 

Kind Regards

Tony

 

We have a lot of changes inside Trirand. You may need to read this post

The forum is moved to another place.. All the existing users and forum posts are moved successfully in our new side guriddo.net

In the future, please post your questions and problems in the new place.

The existing forum will stay and will  be in read-only mode.

 

Kind Regards

Tony

 

We have a lot of changes inside Trirand. You may need to read this post

The forum is moved to another place.. All the existing users and forum posts are moved successfully in our new side guriddo.net

In the future, please post your questions and problems in the new place.

The existing forum will stay and will  be in read-only mode.

 

Kind Regards

Tony

After upgrade from 4.6 to jqGrid 4.7, I found there is problem with multiselect option when cellEdit is enabled.

I Can't select row by checkbox clicking. Nothing happens. To select I have to click few pixels out of the checkbox picture.

Select all checkbox works fine.

* @license jqGrid 4.5.1 - jQuery Grid

/*! jQuery UI - v1.10.1 - 2013-02-15

1.Column Chooser heading and buttons are large.Im using Blue Colur Theme .

2.Search Box-Equal to and not equal to text are coming as [Object,Object]

I posted the pull request which contains the changes in addJSONData and normalizeData required to fix problem with the usage key:true in combination with the reader (jsonReader or localReader) having repeatitems:true.

Here is the modified version of jquery.jqGrid.src.js.

The problem come after you changed old keyIndex option to keyName. It was done to fix problem with non-updated keyIndex option after resorting columns in jqGrid (by usage columnChooser or drag and drop of column headers in case of the usage sortable:true).

I hope that I tested all possible cases.

Best regards
Oleg

By the way, by inspecting your code I found I'm setting some properties that aren't needed as sorttype:text and index.

Thanks for your help Oleg!

usage of demos simplify all. The reason of the problem with sending wrong idCity - the rowids of the grid will be wrong assigned. It's a bug in jqGrid. The bug exists in combination of the usage of arrays of strings as the input value of row like ["13570","Some name 1","Australia"] and the usage of key:true property in colModel. I will post later to github my suggestion how to fix the problem. As the workaround I suggest you to add jsonReader : {id: 0} option and remove key:true property from the first column definition. 

See http://jsfiddle.net/OlegKi/d26hzhu6/3/

About the problem with the requirement to post idCity=3 instead of the text "Australia" I wrote you two times before. You used wrong configuration which worked in old versions of jqGrid, but the but are fixed some years ago (probably in the version 4.4.5). So you should decide whether you want that jqGrid hold values like 1,2,3 in idCity column (and displays still the texts "London", "Washington", "Australia") or you use the texts "London", "Washington", "Australia" in the data. In the first case you the communication with the server will be in ids 1,2,3, but the values have to be used in both input of grid and the output. Exactly the example I used in the modified demo. Alternatively you can fill jqGrid with the data like "London", "Washington", "Australia", but exactly the same data will be send to the server during editing.

You still can use serializeEditData to remap any standard values like "London", "Washington", "Australia" to 1,2,3 or on the contrary, but I don't recommend you to do so because I personally find such kind on communication transfer non-consequent.

Best regards
Oleg

Is it possible to make jqgrid responsive like flip scroll in the demo below

http://dbushell.com/demos/tabl.....01-12.html

Love jqgrid. Thanks for all the effort!

Kris

I've noticed ajaxDelOptions (when press "Delete" button for row) is not working properly.

Please see my js-code below:

$SchemaAttrGrid.jqGrid()[0].p.ajaxDelOptions = new Object();
        $SchemaAttrGrid.jqGrid()[0].p.ajaxDelOptions.beforeSend = function(event, jqXHR) {
            return SchemaAttributeGridBeforeEditDelete(event, jqXHR);
        }

And following code for "Edit" button is working properly (in same manner):

        
$SchemaAttrGrid.jqGrid()[0].p.ajaxRowOptions = new Object();
$SchemaAttrGrid.jqGrid()[0].p.ajaxRowOptions.beforeSend = function(event, jqXHR) {
            return SchemaAttributeGridBeforeEditDelete(event, jqXHR);
        }

ajaxDelOptions have only declaration (line #8450) and usage code (line #8592).

I think in some place inside of method delGridRow (for example #8460) should be following line:


rp_ge[$t.p.id].ajaxDelOptions = $t.p.ajaxDelOptions !== undefined ?
 class="brush-javascript syntax">$t[0].p.ajaxDelOptions : {}
]]>
        	        	Fri, 12 Dec 2014 17:00:50 +0200
        
        
        	
        	http://www.trirand.com/blog/?page_id=393/bugs/strange-behaviour-after-updating-to-jqgrid-4-7-0#p31454
        	Bugs
        	http://www.trirand.com/blog/?page_id=393/bugs/strange-behaviour-after-updating-to-jqgrid-4-7-0#p31454
        	        	Here's the jsfiddle for the issue with prmNames (I removed the hidden:true property for column idPer. In edit form the value is displayed correctly, after saving is replaced by the number of the row):

http://jsfiddle.net/d26hzhu6/2/
Notice that if you remove the property id: "idPer" in prmNames this problem is fixed.
Also the same code works correctly in v4.4.4, as you can see in the fiddler used below.
 
Regarding the issue with the combos:
I was using version 4.4.4. I know it may sound strange, but it was working as I previously explained without formatter:'select':
I retrieve from the DB the text "Australia" for the field "idCity". When opening the edit form, jqgrid will match the text to positionate the combo. After successfull submit (which post idCity=3) the text "Australia" would appear in the grid instead of the value 3.
Here's the jsfiddle using v.4.4.4 exposing the behaviour I mentioned above:
http://jsfiddle.net/Lgy7ae3h/1/
After comparing the code in formedit I found that in version 4.4.5 some code was removed that provided that functionality (all related to a var name "expost"). I also found the commit of that change:
https://github.com/tonytomov/jqGrid/commit/edb5073b6bd617878221674d201cba060489241c
Now, how can I update my code to make it work as before but using the new version?. I have more than 20 grids and I would try to avoid to change the stored procedures.
]]>
        	        	Fri, 12 Dec 2014 16:22:07 +0200
        
        
        	
        	http://www.trirand.com/blog/?page_id=393/discussion/mobile-version#p31453
        	Discussion
        	http://www.trirand.com/blog/?page_id=393/discussion/mobile-version#p31453
        	        	As far as my experience with JqGrid Goes - all of your points can be done with the normal jqGrid Plugin - you just need to dig a little and work your way around the restrictions of the Mobile Devices.

It worked for me on iPad (iOs 7 & 8) - as well as on my old Samsung S3 (therefore Android), I just needed to get the right CSS Style and change some things in the CSS so the Keyboard pops up and so on.
]]>
        	        	Fri, 12 Dec 2014 12:05:24 +0200
        
        
        	
        	http://www.trirand.com/blog/?page_id=393/bugs/strange-behaviour-after-updating-to-jqgrid-4-7-0#p31452
        	Bugs
        	http://www.trirand.com/blog/?page_id=393/bugs/strange-behaviour-after-updating-to-jqgrid-4-7-0#p31452
        	        	If you have an interest to prepare the jsfiddle demo which uses Ajax you can use http://jsfiddle.net/OlegKi/ntfw57zm/ as an example.

I can repeat that I think that you use wrong value editoptions:{ value:"1:London;2:Washington;3:Australia"}. You use "Australia" and "Washington" in the input data. So you don't use ids in the input data. It means that editoptions:{ value:"London:London;Washington:Washington;Australia:Australia"} will be correct.
If you do want to use ids in the idCity column you should use [["13570","Some name 1","3"],["34233","Some name2","Washington"]] and

colNames: ['person', 'idCity'],
colModel: [
    {name:'person', editoptions:{size:39}, width:190},
    {name:'idCity', edittype:'select', formatter:'select', width:90,
        editoptions:{ value:"1:London;2:Washington;3:Australia"}}
],
cmTemplate: {editable:true}
In the way the data will hold only ids in idCity column but display texts. formatter:'select' do the mapping. Because you use prmNames: {id: "idPer", ...} no hidden idPer column is required.
Best regards

 Oleg
]]>
        	        	Fri, 12 Dec 2014 08:28:36 +0200
        
        
        	
        	http://www.trirand.com/blog/?page_id=393/bugs/strange-behaviour-after-updating-to-jqgrid-4-7-0#p31451
        	Bugs
        	http://www.trirand.com/blog/?page_id=393/bugs/strange-behaviour-after-updating-to-jqgrid-4-7-0#p31451
        	        	Here's the jsfiddle:

http://jsfiddle.net/d26hzhu6/
The only thing that is missing is the Ajax response. I found the following example, but I don't know how to use it to replace the Ajax call in jqgrid:
new Request.JSONP({

    url: 'http://jsfiddle.net/echo/jsonp/',

    data: {

        text: 'some text',

        par1: 'another text'

    },

    onSuccess: function(response) {

        show_response(response, $('post'));

    }

}).send();
]]>
        	        	Fri, 12 Dec 2014 03:32:15 +0200
        
        
        	
        	http://www.trirand.com/blog/?page_id=393/help/editing-only-one-of-the-tables-that-are-joined-together#p31450
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/editing-only-one-of-the-tables-that-are-joined-together#p31450
        	        	JQgrid is working really nice when there is only one table involved. But I was wondering if it's possible to get it to work with multiple tables as well.

Lets say I have two tables
customer table has cuid, name, gender, cityid

city table has cityid, cityname, citysize
And they are joined together like this
select cuid, name, cityname, citysize

from customer cu

left outer join city ct on cu.cityid = ct.id
1. How can I edit that only customer table is updated?

2. If I want to edit both at the same time, how do I do that instead?
Thanks
]]>
        	        	Fri, 12 Dec 2014 03:12:09 +0200
        
        
        	
        	http://www.trirand.com/blog/?page_id=393/bugs/strange-behaviour-after-updating-to-jqgrid-4-7-0#p31449
        	Bugs
        	http://www.trirand.com/blog/?page_id=393/bugs/strange-behaviour-after-updating-to-jqgrid-4-7-0#p31449
        	        	Thanks for your response. I've never used jsfiddle and I don't know how to simulate ajax requests (apparently only POST is supported and I'm using GET). Anyway here's a small demo:

HTML Body:
    <div>

         <table id="sampleGrid"><tr><td></td></tr></table>

         <div id="pagerSampleGrid"></div>    

     </div>
Javascript:
    //<![CDATA[

         $(document).ready(function () {            

             setjqGridSettings();

             setGridRequirentes();            

         });
    

 function setjqGridSettings()

 {    

     $.extend($.jgrid.defaults,

     {

         mtype:"POST",                       

         datatype: 'json',

         ajaxGridOptions: { contentType: "application/json; charset=utf-8" },    

         viewrecords: true,

         loadonce: true,

         gridview: true,

         scrollOffset: 0,

         autowidth: true,

         ignoreCase: true,

         jsonReader : {

             root: "d.rows",

             page: "d.page",

             total: "d.total",

             records: "d.records",

             cell: ""},

         ajaxSelectOptions: { type: "GET", contentType: 'application/json; charset=utf-8' }

     });
    $.extend($.jgrid.edit,

     {

         ajaxEditOptions: { contentType: "application/json; charset=utf-8" },

         closeAfterEdit: true,

         closeAfterAdd: true,

         closeOnEscape: false,

         reloadAfterSubmit: false,

         jqModal: false

     });    

 }    

     

 function setGridRequirentes()

 {    

     var modSettings =

     {

         width: 440,

         url: 'myUrl.aspx',

         serializeEditData: function(postData) {            

             console.log(postData)

         }        

     };
    var sampleData = [

             {idPer:"13570", person:"some name 1",idCity:"Washington"},

             {idPer:"34233", person:"some name 2",idCity:"Australia"},

         ];            

             

     $("#sampleGrid").jqGrid({        

         //datatype:'local',

         //data: sampleData,

         url: "MyPage.aspx/getPeople",    

         mtype: "GET",        

         prmNames: {id: "idPer", search:null, nd : null, page: null, rows: null, sort : null, order : null},  

         colNames:['idPer', 'person', 'idCity'],  

         colModel:[

             {name:'idPer',index:'idPer', hidden: true, key: true, width:55, editable:true, editrules:{edithidden:false}, sorttype:'int'},

             {name:'person',index:'person', editable:true, editoptions:{size:39}, width:190, sorttype:'text'},

             {name:'idCity',index:'idCity', editable:true, edittype:'select',

                 editoptions:{ value:"1:London;2:Washington;3:Australia"},width:90, sorttype:'text'}],

         rowNum:5,

         rowList:[5,10,15,20],

         pager: '#pagerSampleGrid',    

         caption:"Sample Grid"        

     });    

  

     $("#sampleGrid").jqGrid('navGrid','#pagerSampleGrid',{edit:true,add:true,del:false,search:false,refresh:false},modSettings);

 }

     //]]>
 
The response from my web service getPeople is (I'm using the format suggested in jqGrid demos "Data Mapping"->"Data Optimization" to reduce the size of the response):

{"d":{"page":1,"total":1,"records":100,"rows":[["13570","Some name 1","Australia"],["34233","Some name

 2","Washington"]]}}
In serializeEditData I only get the number of the row instead of the "idPer" value as can be seen in the console.

 Also note that after saving (gives an error since the webservice is not found) for example Australia is replaced by 3.
Thanks for your help

]]>
        	        	Thu, 11 Dec 2014 19:07:18 +0200
        
        
        	
        	http://www.trirand.com/blog/?page_id=393/bugs/resizing-columnchooser-dialog#p31448
        	Bugs
        	http://www.trirand.com/blog/?page_id=393/bugs/resizing-columnchooser-dialog#p31448
        	        	I have next code :

$grid.jqGrid('columnChooser', {

              msel_opts: {dividerLocation: 0.5},

              width:550,

              height:300,  for ver. 4.7.0 not work

              done : function (perm) {

                    if (perm) { // ok button

                        this.jqGrid("remapColumns", perm, true);

                        $grid.setGridWidth(wscreen-2, true);

                     }

                    else { // cancel button
               }

 }
 
height:300,  for ver. 4.7.0 not work
$grid.setGridWidth(wscreen-2, true); for ver <4.7.0 work ok
but in ver 4.7.0 , if scrool vertical is present  , I   modified with $grid.setGridWidth(wscreen+16, true); 
]]>
        	        	Thu, 11 Dec 2014 15:53:49 +0200
        
        
        	
        	http://www.trirand.com/blog/?page_id=393/bugs/strange-behaviour-after-updating-to-jqgrid-4-7-0#p31447
        	Bugs
        	http://www.trirand.com/blog/?page_id=393/bugs/strange-behaviour-after-updating-to-jqgrid-4-7-0#p31447
        	        	To fix the problem one have to debug the code. So one needs to have the working demo which uses uncompressed version of jqGrid jquery.jqGrid.src.js (instead of jquery.jqGrid.min.js). If one can see that wrong information will be posted to the server that one don't need and server part to debug such demo. So please prepare always a working demo if you report the bug.

About the first issue which you report all sounds very strange. You write about "the id's of the combos instead of the text". So you use probably select with options having different value and the text. It seems me wrong if you use edittype:'select' and not uses formatter:'select'. One uses different values and texts in select options only in the case that one fill the data with ids (values), but one want to display the texts for the user. formatter:'select' do that. The only disadvantage of the approach is that the formatter have to know the mapping between ids and the texts during filling of the grid. One can't make an additional asynchronous call to the server. So one uses formatter:'select' with editoptions.value instead of usage of editoptions.dataUrl. If one need still build dynamic values of editoptions.value one can set it inside of beforeProcessing callback. See the answer for more details.
About the problem with the date format you should try to use reformatAfterEdit: true option of formatter: "date".
Best regards

Oleg
]]>
        	        	Thu, 11 Dec 2014 14:24:43 +0200