Guriddo » Topic: saveState issue with cellattr/formatter

saveState issue with cellattr/formatter

Guriddo
cellattr, formatter, loadState, saveState
saveState issue with cellattr/formatter

Tagged: cellattr, formatter, loadState, saveState

This topic has 2 replies, 2 voices, and was last updated 9 years, 1 month ago by wwhardy.

Creator

Topic

June 23, 2017 at 11:54 pm #126233

wwhardy

Participant

Hi,

I have one other bug to report on saveState/loadState (otherwise it works great). When spanning table columns, the formatter is lost after a loadState followed by filterToolbar search. Please run this example:

Click Save Search
Click Load Search
Search on a colspan field, such as Last Name. Note that the formatter is lost after pressing enter.

Here is an example:

&lt;button onClick=&quot;savegrid();&quot;&gt;Save Search&lt;/button&gt;
&lt;button onClick=&quot;loadgrid();&quot;&gt;load Search&lt;/button&gt;
&lt;button onClick=&quot;resetgrid();&quot;&gt;Reset&lt;/button&gt;

&lt;table id=&quot;jqGrid&quot;&gt;&lt;/table&gt;
&lt;div id=&quot;jqGridPager&quot;&gt;&lt;/div&gt;

&lt;script type=&quot;text/javascript&quot;&gt;

    var mydata = [
           { id: &quot;1&quot;, prefix: &quot;Mr.&quot;, first: &quot;John&quot;, middle: &quot;M.&quot;, last: &quot;Smith&quot;, city: &quot;Boston&quot;, namefull: &quot;Mr. John M. Smith&quot; },
           { id: &quot;2&quot;, prefix: &quot;Ms.&quot;, first: &quot;Mary&quot;, middle: &quot;L.&quot;, last: &quot;Jones&quot;, city: &quot;Chicago&quot;, namefull: &quot;Ms. Mary L. Jones&quot; },
    ];

  $(document).ready(function () {
    $(&quot;#jqGrid&quot;).jqGrid({
      datatype: &quot;local&quot;,
      data: mydata,
      height: 250,
      width: 780,
      colModel: [
          { label: &#039;ID&#039;,
            name: &#039;id&#039;,
            width: 75,
            key:true
          },{
            label: &#039;Prefix&#039;,
            name: &#039;prefix&#039;,
            width: 80,
            cellattr: function (rowId, tv, rawObject, cm, rdata) { return &#039; colspan=4&#039; },
            formatter: function(value, options, rData){ return rData[&#039;namefull&#039;]; },
          },{
            label: &#039;First&#039;,
            name: &#039;first&#039;,
            width: 100,
            cellattr: function (rowId, tv, rawObject, cm, rdata) { return &#039; style=\&quot;display:none\&quot;&#039; },
          },{
            label: &#039;Middle&#039;,
            name: &#039;middle&#039;,
            width: 80,
            cellattr: function (rowId, tv, rawObject, cm, rdata) { return &#039; style=\&quot;display:none\&quot;&#039; },
          },{
            label: &#039;Last&#039;,
            name: &#039;last&#039;,
            width: 100,
            cellattr: function (rowId, tv, rawObject, cm, rdata) { return &#039; style=\&quot;display:none\&quot;&#039; },
          },{
            label: &#039;City&#039;,
            name: &#039;city&#039;,
            width: 100,
          },
      ],
      viewrecords: true,
      caption: &quot;Save Grid State&quot;,
      storeNavOptions : true,
    });
    $(&quot;#jqGrid&quot;).jqGrid(&#039;filterToolbar&#039;,{
      searchOperators: true,
      autosearch: true,
    });
  });
  function savegrid() {
    $.jgrid.saveState(&quot;jqGrid&quot;);
  }
  function loadgrid() {
    $.jgrid.loadState(&quot;jqGrid&quot;, null, {});
  }
  function resetgrid() {
    window.location.reload(true);
  }

&lt;/script&gt;

<button onClick="savegrid();">Save Search</button>

<button onClick="loadgrid();">load Search</button>

<button onClick="resetgrid();">Reset</button>

var mydata = [

{ id: "1", prefix: "Mr.", first: "John", middle: "M.", last: "Smith", city: "Boston", namefull: "Mr. John M. Smith" },

{ id: "2", prefix: "Ms.", first: "Mary", middle: "L.", last: "Jones", city: "Chicago", namefull: "Ms. Mary L. Jones" },

];

$(document).ready(function () {

$("#jqGrid").jqGrid({

datatype: "local",

data: mydata,

height: 250,

width: 780,

colModel: [

{ label: 'ID',

width: 75,

key:true

},{

label: 'Prefix',

width: 80,

cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' colspan=4' },

formatter: function(value, options, rData){ return rData['namefull']; },

},{

label: 'First',

width: 100,

cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' style=\"display:none\"' },

},{

label: 'Middle',

width: 80,

cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' style=\"display:none\"' },

},{

label: 'Last',

width: 100,

cellattr: function (rowId, tv, rawObject, cm, rdata) { return ' style=\"display:none\"' },

},{

label: 'City',

width: 100,

viewrecords: true,

caption: "Save Grid State",

storeNavOptions : true,

});

$("#jqGrid").jqGrid('filterToolbar',{

searchOperators: true,

autosearch: true,

});

function savegrid() {

$.jgrid.saveState("jqGrid");

}

function loadgrid() {

$.jgrid.loadState("jqGrid", null, {});

}

function resetgrid() {

window.location.reload(true);

}

</script>

Thanks for your help,
Walter Hardy

Creator

Topic

Viewing 2 replies - 1 through 2 (of 2 total)

Author

Replies
June 26, 2017 at 9:22 am #126234

guriddo.support
Participant

Hello Walter,

Thank you very much for the test case. It help us a lot to identify the problem.

It seems that the first fix does not cover all cases. We have do more stronger check.

The fix is again in GitHub andf you can test if everything is ok.

Please let us know if it is working for you.

Kind Regards,

Will

Guriddo Support Team

June 27, 2017 at 2:13 am #126239

wwhardy
Participant

Hi Will,
Thank you! The fix is working great for us. Very much appreciated, and glad to provide the test case.

Best,
Walter
Author

Replies

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

saveState issue with cellattr/formatter

Search Forum

Recent Replies

Forum Statistics

UserOnline