jQuery Grid Plugin - jqGrid - All Forums

Anandha on Disable row selection

Thu, 20 Jun 2013 01:29:15 +0000

onCellSelect : function(rowid,iCol,cellcontent,e) {
$("#"+gridId + " tr#"+rowid).css("background", "none");
$("#"+gridId + " tr.jqgrow:odd").css("background", "#DDDDDC");
}

marciaKeglevich on How get the click event of buttons pagination?

Wed, 19 Jun 2013 19:31:32 +0000

Well, after a long research, I found the solution for my case using this code :

$('#idGrid').setGridParam({

onPaging: function() {

//make something here

}

});

Few lines that caused me a headache

Anyway, I hope this helps someone

sean_k on IE8, JQuery 1.9+, JqGrid 4.5.2 - Jquery UI dialog modal has wrong stack order

Wed, 19 Jun 2013 13:17:41 +0000

Hi all,

As the title states. Simple to repro – use the html below (cannot use JsFiddle/Plunker as they do not support IE8).

Open the html below in IE8. Click the 'Click Me' button. You will get a dialog but the jquery ui widget overlay gets rendered over the dialog. The culprit is here: https://github.com/tonytomov/jqGrid/blob/master/js/jquery.jqGrid.js#L11945. Commenting this out reverts back to the jquery version:

function (n){

var t=n.offsetWidth,r=n.offsetHeight;

return t===0&&r===0||!i.support.reliableHiddenOffsets&&(n.style&&n.style.display||i.css(n,"display"))==="none"

}

I'm not sure of the reason for the jqGrid override of this or if removing will break another feature. If I can provide more information, please let me know.

Thanks,

Sean

<html>

<head>

$(function(){

$('input').click(function(){

$('<div>Can't click me</div>').dialog({

modal: true

});

</script>

</head>

<body>

</body>

Mantezuma on Excel export bug when actions column is added

Wed, 19 Jun 2013 12:13:31 +0000

This problem was solved here

anand_matta on Copy to clipboard?

Wed, 19 Jun 2013 11:15:52 +0000

Hay JQ Grid exports. Thank you for this excellent component. This makes most of the life easy.

I have started working on one application where I used JQGrid.

Actually I am migtating a desktop application to wen based.

I need to copy option only for one colunm to clipboard. Rest of the colunms should not be selected or copied.

is there any way to copy colunm data toclipboard?

Thank you in advance

Anand

anand_matta on bold the row content not happening

Wed, 19 Jun 2013 11:10:02 +0000

Hay JQ Grid exports. Thank you for this excellent component. This makes most of the life easy.

I have started working on one application where I used JQGrid.

Actually I am migtating a desktop application to wen based.

I am sending in a hidden colunm with the style class name and the same name coded in the jsp also.

in a row model

jQuery("#atrisk").jqGrid(

.....

colModel : [ {

.....

                          {
                               name : 'ROWSTYLE',
                               index : 'ROWSTYLE',
                               hidden:true
                           }

..............

                      rowattr: function (rd) {
                               return {"class": rd.ROWSTYLE};
                           },

But the problem is color to font is chnaging but bold is not applying is there any issue with the code or any workaround?

Thank you in advance

Anand

25dd

anand_matta on Reminders and notes

Wed, 19 Jun 2013 11:00:53 +0000

Hay JQ Grid exports. Thank you for this excellent component. This makes most of the life easy.

I have started working on one application where I used JQGrid.

Actually I am migtating a desktop application to wen based.

I wanted to set reminders and based on time it give the reminder alert, user can open it and view the note. With this snoozing, dismiss and cancel reminders. Is there any component with JQgrid. Please let me know.

Thank you in advance

Anand

zeestorm on Single Column Table - setGridWidth

Wed, 19 Jun 2013 05:32:03 +0000

When you have a single column table, and you attempt to call "setGridWidth", the table will not update.

This is due to line 3465 (on my copy), which reads:

if (!lvc) { return; }

Since a single column will have index of 0, this ends the function, instead of finishing updating the grid. It should be something like this:

if (lvc === undefined) { return; }

Which would mean there are no visible columns to be resized.

The above code is what I changed locally and it appears to be working as intended.

crohit on Help! jqgrid onclick or click only works once

Tue, 18 Jun 2013 23:43:31 +0000

tony said:
Hello,

Check to see if you have a uniquie id's in the grid.

Regards

Yes, I do have unique ids in the grid for my data. If you see my code, you will notice that I have 3 different ways I am trying to circumvent the issue. But, if i DO NOT call jqgrid, then the onclick works every time. Thats where i show an JS Alert in my code.

iski.wang on How to asynchrously update jqgrid pgtext

Tue, 18 Jun 2013 20:59:04 +0000

I am using jqgrid to display a very large data set. Since the query to get the total number of record count takes a long time. I am trying to see if I can fire a separate ajax call to get the total count and then update the recordcount and total page number after the grid is rendered with the first result data set.

I am able to update the total record count by using

$("#list").jqGrid('setGridParam', { recordtext: "View {0} - {1}" + " of " + datacount}).trigger("reloadGrid");

However I am not able to update the totalpage with the code below:

$("#list").jqGrid('setGridParam', { pgtext: "page {0} of {1}" + " of " + totalPage}).trigger("reloadGrid");

Anything wrong in the code above? Thank you so much for the help! I really appreciate it!

tony on Help! jqgrid onclick or click only works once

Tue, 18 Jun 2013 19:29:25 +0000

Hello,

Check to see if you have a uniquie id's in the grid.

Regards

tony on Excel export bug when actions column is added

Tue, 18 Jun 2013 18:59:46 +0000

Hello,

Can you please post your problem here

It seemes you use our commercial suite.

Regards

Mantezuma on Excel export bug when actions column is added

Tue, 18 Jun 2013 12:32:55 +0000

When the actions column was added excel export is not working properly - exports all fields (even hidden) with the names of the database, not from the model column.
What i need to do ?
Sorry for my English.

venugopalsmartboy on Event triggered by column reorder?

Tue, 18 Jun 2013 09:49:46 +0000

According to this post in trirand forum,

sortable : { options : { <whatever sortable options you want> },

update : function(perumtation) {},

This is working great.. thanks to the jqGrid development teams and support communities..

venugopalsmartboy on Event triggered by column reorder?

Tue, 18 Jun 2013 09:40:59 +0000

Hi Tony,

If I use like this,

                sortable:{

               options: {
                  stop: function(event, ui) {

                     var d = $("div.ui-jqgrid-sortable",$(ui.item));
                    console.log('Colomn "'+ d.text() + '" was reorded');

                         },
                  update: function(relativeColumnOrder) {
                  console.log("in update");


                       }

                  }

             },

The sortability is not working. Though the headers are moving, but the data in the grid is not moving.

You can find the same in this jsbin example. Please suggest on how to go ahead on this.

24ce

crohit on Help! jqgrid onclick or click only works once

Tue, 18 Jun 2013 00:30:43 +0000

I am using Master Detail grid. I have a Form, where the user inputs one or more search criteria and clicks a Button. The button calls the JS function, which in turn calls jqgrid master detail logic and shows the grids with the data returned from the server.

The problem is that the Button onclick only works One time. After that I have to do a page reload to make the onclick work again.

I tried calling another simple JS function (non jqgrid) and in that case Onclick works any number of times.

There is something in jqgrid code, that takes away my ability of onclick.

Please let me know if there is a setting or workaround for this.

thanks

Here is the code:

<head>

$.jgrid.no_legacy_api = true;

$.jgrid.useJSON = true;

$('mylink').click(get_servers());

function get_alert(){

alert("this sucks!!!");

}

function get_servers() {

jQuery("#list10").jqGrid({

url:"json/getServers.htm?hostName="+$('#hostName').val()+"&osType="+$('#osType').val()+"&processor="+$('#processor').val(),

datatype: "json",

colNames:['_id','dMesg','nisName','id','hostName','hypervisor_name','parserVersion','osType','cpuInfo','memory_GB','blkId','extended_attributes','serverName','processor_reference','dnsName','processor_frequency_GHz','memInfo','df','packages','lsPci','osVersion','partitions','name','ypName','lines','ifConfig','mounts','processor_system_count','dmiInfo'],

colModel:[

{name:'_id',index:'_id', key:true, width:50},

{name:'dMesg',index:'dMesg', width:50},

{name:'nisName',index:'nisName', width:50},

{name:'id',index:'id', width:50},

{name:'hostName',index:'hostName', width:50},

{name:'hypervisor_name',index:'hypervisor_name', width:50},

{name:'parserVersion',index:'parserVersion', width:50},

{name:'osType',index:'osType', width:50},

{name:'cpuInfo',index:'cpuInfo', width:50},

{name:'memory_GB',index:'memory_GB', width:50},

{name:'blkId',index:'blkId', width:50},

{name:'extended_attributes',index:'extended_attributes', width:50},

{name:'serverName',index:'serverName', width:50},

{name:'processor_reference',index:'processor_reference', width:50},

{name:'dnsName',index:'dnsName', width:50},

{name:'processor_frequency_GHz',index:'processor_frequency_GHz', width:50},

{name:'memInfo',index:'memInfo', width:50},

{name:'df',index:'df', width:50},

{name:'packages',index:'packages', width:50},

{name:'lsPci',index:'lsPci', width:50},

{name:'osVersion',index:'osVersion', width:50},

{name:'partitions',index:'partitions', width:50},

{name:'name',index:'name', width:50},

{name:'ypName',index:'ypName', width:50},

{name:'lines',index:'lines', width:50},

{name:'ifConfig',index:'ifConfig', width:50},

{name:'mounts',index:'mounts', width:50},

{name:'processor_system_count',index:'processor_system_count', width:50},

{name:'dmiInfo',index:'dmiInfo', width:50}

rowNum:10,

rowList:[10,20,30],

pager: '#pager10',

sortname: 'id',

viewrecords: true,

sortorder: "desc",

multiselect: false,

caption: "Server list",

onSelectRow: function(ids) {

if(ids == null) {

ids=0;

if(jQuery("#list10_d").jqGrid('getGridParam','records') >0 )

{

jQuery("#list10_d").jqGrid('setGridParam',{url:"json/getCpuInfo.htm?_id="+ids,page:1});

jQuery("#list10_d").jqGrid('setCaption',"CPU Info: "+ids)

.trigger('reloadGrid');

}

} else {

jQuery("#list10_d").jqGrid('setGridParam',{url:"json/getCpuInfo.htm?_id="+ids,page:1});

jQuery("#list10_d").jqGrid('setCaption',"CPU Info: "+ids)

.trigger('reloadGrid');

}

});

jQuery("#list10").jqGrid('navGrid','#pager10',{add:false,edit:false,del:false});

jQuery("#list10_d").jqGrid({

height: 100,

//url:'get_json_subgrid?_id=0',

datatype: "json",

colNames:['cpu family','model name','cache_alignment','vendor_id','flags'],

colModel:[

{name:'cpu family',index:'cpu family', width:100},

{name:'model name',index:'model name', width:100},

{name:'cache_alignment',index:'cache_alignment', width:100},

{name:'vendor_id',index:'vendor_id', width:100},

{name:'flags',index:'flags', width:100}

rowNum:5,

rowList:[5,10,20],

pager: '#pager10_d',

sortname: 'item',

viewrecords: true,

sortorder: "asc",

multiselect: false,

caption:"CPU Info"

}).navGrid('#pager10_d',{add:false,edit:false,del:false});

jQuery("#ms1").click( function() {

var s;

s = jQuery("#list10_d").jqGrid('getGridParam','selarrrow');

alert(s);

});

}

</script>

<title>Server search</title>

</head>

<body>

<ul>

<li>

</li>

<li>

</li>

<li>

</li>

<li>

</li>

</form>

<ul>

<li>

<a href="#" id="mylink" onclick="javascript:get_servers();">Search servers</a>

</li>

<li>

<div style="cursor: pointer;" onclick="get_alert()"> Click here</div>

</li>

</ul>

Server List

<br />

CPU Info

</body>

16a1

zhe2605 on CSS Validation of ui.jqgrid.css

Mon, 17 Jun 2013 23:39:29 +0000

Hi!
Is it possible to fix W3C CSS Validation errors of this document?

jm44122 on setGridParam no longer loads data as of jQuery 1.8.3

Mon, 17 Jun 2013 22:49:24 +0000

We have not been frequently updating our jQuery or jqGrid versions. When trying to upgrade to the latest releases, I've discovered that setGridParam no longer works in my code. Since no one else seems to be having this issue, I am blaming my code, but cannot identify the problem.

When we were using jQuery 1.7.1 and jqGrid 4.4.1; all worked okay. I've tried a few versions of jQuery, and the issue seems to have started with the release of 1.8.3. Using that version and jqGrid 4.4.4; the data no longer shows in the grid.

Here is a short bit of the program. trows is the JSON length returned from the $.ajax call. tdata is the JSON data. Stepping through a debugger, these values do exist when calling the jqGrid functions. Can someone point out what I may have missed in the release notes? Thanks.

$myTable

.jqGrid('clearGridData')

.jqGrid('setGridParam',

{

datatype: "local",

data: tdata,

rowNum: trows > 50 ? 50 : trows

}

.trigger("reloadGrid");

marciaKeglevich on How get the click event of buttons pagination?

Mon, 17 Jun 2013 22:10:23 +0000

Hi guys,

I'm new at the forum and I need some help to get the click event of pagination buttons,

I don't know if it's possible to make this, I tried get the event by this way, using the css class

and using the functions .live(); and .click();

But none of these functions get the click event.

$('.ui-icon ui-icon-seek-next').live('click', function () { });

$('.ui-icon ui-icon-seek-next').click(function() { });

In this example, I tried to get the event of the button 'next' in the pagination, but I think other plugin event calls the button first.

Sorry for my bad english guys and thanks anyway.

Inara on Select control options automatically re-sorted when values are numeric.

Mon, 17 Jun 2013 21:34:05 +0000

I recently stumbled upon the following issue: For an editable grid (I tested both form edit and inline edit modes), if you pass a select control a value list with only numeric storage values, jqGrid automatically re-sorts the list by the storage values when it converts the values to a dropdown.

For example, if I include the following value list in the editoptions for a select column:

value:{"":"","8":"ACME Inc.","3":"Basic, LLC","7":"Large Corp","2":"Simple Organization","4":"Testing Organization"}

I expect to get the following select list:
<option role="option" value=""></option>
<option role="option" value="8">ACME Inc.</option>
<option role="option" value="3">Basic, LLC</option>
<option role="option" value="7">Large Corp</option>
<option role="option" value="2">Simple Organization</option>
<option role="option" value="4">Testing Organization</option>

Instead, I get this:
<option role="option" value="2">Simple Organization</option>
<option role="option" value="3">Basic, LLC</option>
<option role="option" value="4">Testing Organization</option>
<option role="option" value="7">Large Corp</option>
<option role="option" value="8">ACME Inc.</option>
<option role="option" value=""></option>

Is there any way to turn off this auto-sorting behavior? I would like to be able to display values from the database in alphabetical order while storing their IDs.