Using just the "text" property did not work. But the following code worked:

    if (rowObject.IsOverdue == undefined){
        if (rowObject.childNodes[5].textContent == "True"){
            return "<a href='Reports/RPT_Dashboard.asp?ReportProjectID=" + options.rowId + "' target=_new title='Progress Updates on this project is outdated! Click to open the latest Project Dashboard' class='gridOverdue' style='color:#FF0000;'>" + $.fmatter.util.DateFormat("m/d/Y",cellvalue,"d M Y",$.jgrid.formatter.date) + "</a>";
        }
        else{
            return "<a href='Reports/RPT_Dashboard.asp?ReportProjectID=" + options.rowId + "' target=_new title='Click to open the latest Project Dashboard'>" + $.fmatter.util.DateFormat("m/d/Y",cellvalue,"d M Y",$.jgrid.formatter.date) + "</a>";
        }
    }
    else{
        if (rowObject.IsOverdue == "True"){
            return "<a href='Reports/RPT_Dashboard.asp?ReportProjectID=" + options.rowId + "' target=_new title='Progress Updates on this project is outdated! Click to open the latest Project Dashboard' class='gridOverdue' style='color:#FF0000;'>" + $.fmatter.util.DateFormat("m/d/Y",cellvalue,"d M Y",$.jgrid.formatter.date) + "</a>";
        }
        else{
            return "<a href='Reports/RPT_Dashboard.asp?ReportProjectID=" + options.rowId + "' target=_new title='Click to open the latest Project Dashboard'>" + $.fmatter.util.DateFormat("m/d/Y",cellvalue,"d M Y",$.jgrid.formatter.date) + "</a>";
        }
    }

It seems when the grid is created, the childNodes[5] is available, but not thereafter. Then you can use the actual column name, e.g. "rowObject.IsOverdue".

Thanks for all your help!!

Cheers,

Cas

if (rowObject.childNodes[5].textContent == "True"){

to

if (rowObject.childNodes[5].text === "True") {

see the results. Of case to be able to use gridview: true you should use custom formatter for all coulumns which values you counstruct you currecntly inside of afterInsertRow.

Regards
Oleg

jqGrid Defaults:

            $.extend(jQuery.jgrid.defaults,{
                altRows: true,
                altclass: 'altRow',
                datatype: 'xml',
                emptyrecords: 'No records to display.',
                gridview: true,
                loadonce: true,
                loadui: 'disable',
                pgbuttons: false,
                pginput: false,
                //rowNum: -1,
                recordtext: '{2} items',
                sortable: true,
                viewrecords: true,
                viewsortcols: [false,'vertical',true]
            });

Grid definition:

            $("#tblActiveProjects").jqGrid({
                url:'../Data_Templates/DTM_Projects_Select.asp?FilterType=1&TeamMemberType=1',
                colNames: ['Prj. No.','Project Name', 'Status','RAG','Latest Update','','','','Issues','Risks','Changes','Defects',''],
                colModel: [
                    {name:'ProjectNumber', width:80, align:'center', sorttype:'text'},
                    {name:'ProjectName', width:445, align:'left', sorttype:'text', classes:'gridLink'},
                    {name:'ProjectStatus', width:90, align:'center', sorttype:'text'},
                    {name:'ProjectRAGIndicator', width:40, align:'center', sortable:false, formatter:RAG_formatter},
                    {name:'ProjectStatusDate', width:90, align:'center', sorttype:'date', formatter:OverdueDate_formatter, classes:'gridLink'},
                    {name:'IsOverdue', width:0, align:'center', hidden:true},
                    {name:'LinkToDashboard', width:0, align:'center', hidden:true},
                    {name:'LinkToWorkspace', width:0, align:'center', hidden:true},
                    {name:'ActiveIssues', width:50, align:'center', sorttype:'integer', classes:'gridLink'},
                    {name:'ActiveRisks', width:50, align:'center', sorttype:'integer', classes:'gridLink'},
                    {name:'ActiveChanges', width:50, align:'center', sorttype:'integer'},
                    {name:'ActiveDefects', width:50, align:'center', sorttype:'integer'},
                    {name:'Delete', width:25, align:'center', sortable:false, classes:'actionIcon', title:'Delete'}                    
                ],
                height: 90,
                sortname: 'ProjectName',
                pager: '#pagerActiveProjects',
                toolbar: [true,"top"],
                afterInsertRow: function(rowid, aData){
                    $("#tblActiveProjects").setCell(rowid,'ProjectName',"<a href='" + aData.LinkToWorkspace + "' target=_new title='Click the Project Name to open the Project Workspace'>" + aData.ProjectName + "</a>");
                    $("#tblActiveProjects").setCell(rowid,'ActiveRisks',"<a href='" + aData.LinkToWorkspace + "/Lists/Risks' target=_new title='Click to open the Project Risks list'>" + aData.ActiveRisks + "</a>");
                    $("#tblActiveProjects").setCell(rowid,'ActiveIssues',"<a href='" + aData.LinkToWorkspace + "/Lists/Issues' target=_new title='Click to open the Project Issues list'>" + aData.ActiveIssues + "</a>");
                    $("#tblActiveProjects").setCell(rowid,'Delete',"<img src='../Images/ButtonImages/delete_small.png' onclick=alert('" + rowid + "'); />");
                }
            });

Custom Formatter Fucntion:

OverdueDate_formatter = function (cellvalue, options, rowObject){
    if (rowObject.childNodes[5].textContent == "True"){
        return "<a href='Reports/RPT_Dashboard.asp?ReportProjectID=" + options.rowId + "' target=_new title='Progress Updates on this project is outdated! Click to open the latest Project Dashboard'>" + $.fmatter.util.DateFormat("m/d/Y",cellvalue,"d M Y",$.jgrid.formatter.date) + "</a>";
    }
    else{
        return "<a href='Reports/RPT_Dashboard.asp?ReportProjectID=" + options.rowId + "' target=_new title='Click to open the latest Project Dashboard'>" + $.fmatter.util.DateFormat("m/d/Y",cellvalue,"d M Y",$.jgrid.formatter.date) + "</a>";
    }
}

I suppose there are a bug in your code. If you post the full code of your current example which reproduce your problem (or post a link to it) I could show it.

Regards
Oleg 

When I put the alert(rowObject.childNodes[5].textContent); debug statement in the formatter function, it does return the values. It just seems to ignore it in the if (rowObject.childNodes[5].textContent == "True") condition. Any ideas?

Thanks,

Cas

In case of index as function it should be declared as  index: function(obj) {/**/} and return for example text string which can be used instead of the cell contain. Look at my old post for more details. In the post you will find some urls to code examples.

Best regards
Oleg 

After implementing the custom formatter, I'm getting closer to the solution.

However, I'm facing this issue now:

If I add the following code in my custom formatter function, the data is displayed correctly in the gird, and the sorting works well:

return "<a href='Reports/RPT_Dashboard.asp?ReportProjectID=" + options.rowId + "' target=_new title='Progress Updates on this project is outdated! Click to open the latest Project Dashboard'>" + $.fmatter.util.DateFormat("m/d/Y",cellvalue,"d M Y",$.jgrid.formatter.date) + "</a>";

When I however add a condition into this function, the data is still diplayed correctly, but the moment I sort, all the rows disappear from the grid:

    if (rowObject.childNodes[5].textContent == "True"){
        return "<a href='Reports/RPT_Dashboard.asp?ReportProjectID=" + options.rowId + "' target=_new title='Progress Updates on this project is outdated! Click to open the latest Project Dashboard'>" + $.fmatter.util.DateFormat("m/d/Y",cellvalue,"d M Y",$.jgrid.formatter.date) + "</a>";
    }
    else{
        return "<a href='Reports/RPT_Dashboard.asp?ReportProjectID=" + options.rowId + "' target=_new title='Click to open the latest Project Dashboard'>" + $.fmatter.util.DateFormat("m/d/Y",cellvalue,"d M Y",$.jgrid.formatter.date) + "</a>";
    }

look at this old answer which can be easy modified for your date format. You can also use $.fmatter.util.DateFormat function. But if you need only display only the date like you describe in your last post, you can use predefined formatter date like I used on the example.

Regards
Oleg 

I'm trying your suggestion of custom formatter and unformatter, but with no luck. Can you please give me some guidance: I've got a date column that comes in the XML in format m/d/Y. I want to display this in the jqGrid in the format d M Y. But, I also want to be able to sort this column in date order.

Can you please give me the code for the colmodel, as well for the formatter and unformatter fucntions?

Thanks,

Cas

I have removed the datefmt: 'd m Y', and also added: formatoptions:{srcformat:'m/d/Y',newformat:'d M Y'}.

This still works on version 3.6.5, but breaks on 3.72 and 3.8.

Thanks,

Cas

I understand why some parameters are missing, but all other problems stay opened. I recommend you to rewrite your code using the custom formatters.

Regards
Oleg

Sorry, I forgot to post the jqGrid defaults. Here it is:

            $.extend(jQuery.jgrid.defaults,{
                altRows: true,
                altclass: 'altRow',
                datatype: 'xml',
                emptyrecords: 'No records to display.',
                gridview: true,
                loadonce: true,
                loadui: 'disable',
                pgbuttons: false,
                pginput: false,
                rowNum: -1,
                recordtext: '{2} items',
                sortable: true,
                viewrecords: true,
                viewsortcols: [false,'vertical',true]
            });

I have also made the following change in the language file: newformat:"d M Y"

Thanks,

Cas

the code which you posted has some problems. First, I don't found datatype:'xml' in the code which you posted. Second, your XML data has no page and total items. So it will be supposed that you have the first page from total 0 pages. Next, the date format of the XML data are not in the ISO format which is expected. So you have to use

instead of datefmt:'d M Y'. At the end you not really use the most of data formated by the jqGrid. Instead of that you overwrite the data with absolute another formatted data inside of afterInsertRow. What you will have for example in the column, which you mark as the column in date format, are far from the declared date type. To be able to sort the data jqGrid should be able to read the data value from the cell, unformat it with the formatter which you declared (date formatter). Then jqGrid try compare different values decoded in the way. Is it possible with the data thich you placed in the grid manually?

After all of changes which are required and commenting of the RAG_formatter, which code you not posted, the data can be displayed, but I see no "NaN" error (see here). I could imagine that with other data you can have different kind of errors, because like I wrote before, you do manual formatting of data with declaring the data as the data formatted corresponds to another formatter.

If you need format the cell contains manually, you should define your custom formatter and custom unformater as a functions. Inside of the functions you can do almost the same as you do inside of afterInsertRow. After removing afterInsertRow you can set also gridview:true which is almost always recommended.

Best regards
Oleg 

I'm using the grid.locale-en.js language file. I'm using an XML data source, and not JSON. Here's an extract of my XML:

<?xml version='1.0' encoding='ISO-8859-1'?><rows><records>8</records><row id='14668'><cell><![CDATA[PRJ-3366]]></cell><cell><![CDATA[Banking - Italian Casino]]></cell><cell>2 Active</cell><cell>Green</cell><cell>11/10/2010</cell><cell>False</cell><cell></cell><cell>http://derpwa3/EPM2007/Banking - Italian Casino</cell><cell>0</cell><cell>0</cell><cell>99</cell><cell>99</cell><cell></cell></row><row id='14669'><cell><![CDATA[PRJ-2853]]></cell><cell><![CDATA[Banking - WebECash NET]]></cell><cell>2 Active</cell><cell>Green</cell><cell>11/10/2010</cell><cell>False</cell><cell></cell><cell>http://derpwa3/EPM2007/Banking - WebECash NET</cell><cell>0</cell><cell>0</cell><cell>99</cell><cell>99</cell><cell></cell></row><row id='14670'><cell><![CDATA[PRJ-2537]]></cell><cell><![CDATA[Business Applications - Affiliates - Project Brooklyn]]></cell><cell>2 Active</cell><cell>Green</cell><cell>11/10/2010</cell><cell>False</cell><cell></cell><cell>http://derpwa3/EPM2007/Project Brooklyn (Affiliates Redesign)</cell><cell>0</cell><cell>2</cell><cell>99</cell><cell>99</cell><cell></cell></row><row id='14671'><cell><![CDATA[PRJ-3288]]></cell><cell><![CDATA[Business Applications - Affiliates - Spiral Upgrade Project]]></cell><cell>2 Active</cell><cell>Green</cell><cell>11/10/2010</cell><cell>False</cell><cell></cell><cell>http://derpwa3/EPM2007/Business Applications - Affiliates - Spiral Upgrade Project</cell><cell>0</cell><cell>0</cell><cell>99</cell><cell>99</cell><cell></cell></row><row id='14672'><cell><![CDATA[PRJ-2897]]></cell><cell><![CDATA[Business Applications - Game Recommendation Engine]]></cell><cell>2 Active</cell><cell>Green</cell><cell>11/10/2010</cell><cell>False</cell><cell></cell><cell>http://derpwa3/EPM2007/Business Applications - Game Recommendation Engine</cell><cell>0</cell><cell>0</cell><cell>99</cell><cell>99</cell><cell></cell></row><row id='14673'><cell><![CDATA[PRJ-3179]]></cell><cell><![CDATA[Business Applications - Orinoco - Casino Management System]]></cell><cell>2 Active</cell><cell>Green</cell><cell>11/10/2010</cell><cell>False</cell><cell></cell><cell>http://derpwa3/EPM2007/Business Applications - Vision - Cashier Management System</cell><cell>0</cell><cell>0</cell><cell>99</cell><cell>99</cell><cell></cell></row><row id='10269'><cell><![CDATA[PRJ-1869]]></cell><cell><![CDATA[Collusion and Fraud Control (CFC)]]></cell><cell>6 On Hold</cell><cell>Green</cell><cell>3/31/2010</cell><cell>True</cell><cell></cell><cell>http://derpwa3/EPM2007/Collusion and Fraud Control (CFC)</cell><cell>1</cell><cell>2</cell><cell>99</cell><cell>99</cell><cell></cell></row><row id='14674'><cell><![CDATA[PRJ-3362]]></cell><cell><![CDATA[OLR-NET v16]]></cell><cell>2 Active</cell><cell>Green</cell><cell>11/10/2010</cell><cell>False</cell><cell></cell><cell>http://derpwa3/EPM2007/OLR-NET v16</cell><cell>0</cell><cell>0</cell><cell>99</cell><cell>99</cell><cell></cell></row></rows>

Thanks,

Cas

Could you post the information which jqGrid language file you use. Morover test JSON data will be also required to be able to reproduce your problem. You can see JSON data in Fiddler or Firebug.

Regards
Oleg

Has anyone found a sloution yet?

Thanks!

I'm also having the problem where data disappears on sorting - below is a short example that shows the behaviour. If I use setRowData instead of addJSONData it works OK - the rows are sorted and do not disappear. Trouble is I need the pager method as I want to set userdata. This worked ok in 3.6.

Thanks,

Andy

$("#tblActiveProjects").jqGrid({
    url:'../Data_Templates/DTM_Projects_Select.asp?FilterType=1&TeamMemberType=1',
    colNames: ['Prj. No.','Project Name', 'Status','RAG','Latest Update','','','','Issues','Risks','Changes','Defects',''],
    colModel: [
        {name:'ProjectNumber', width:80, align:'center', sorttype:'text'},
        {name:'ProjectName', width:445, align:'left', sorttype:'text', classes:'gridLink'},
        {name:'ProjectStatus', width:90, align:'center', sorttype:'text'},
        {name:'ProjectRAGIndicator', width:40, align:'center', sortable:false, formatter:RAG_formatter},
        {name:'ProjectStatusDate', width:90, align:'center', datefmt:'d M Y', sorttype:'date', formatter:'date'},
        {name:'IsOverdue', width:0, align:'center', hidden:true},
        {name:'LinkToDashboard', width:0, align:'center', hidden:true},
        {name:'LinkToWorkspace', width:0, align:'center', hidden:true},
        {name:'ActiveIssues', width:50, align:'center', sorttype:'integer', classes:'gridLink'},
        {name:'ActiveRisks', width:50, align:'center', sorttype:'integer', classes:'gridLink'},
        {name:'ActiveChanges', width:50, align:'center', sorttype:'integer'},
        {name:'ActiveDefects', width:50, align:'center', sorttype:'integer'},
        {name:'Delete', width:25, align:'center', sortable:false, classes:'actionIcon', title:'Delete'}                    
    ],
    height: 160,
    sortname: 'ProjectName',
    pager: '#pagerActiveProjects',
    gridview: false,
    toolbar: [true,"top"],
    afterInsertRow: function(rowid, aData){
        $("#tblActiveProjects").setCell(rowid,'ProjectName',"<a href='" + aData.LinkToWorkspace + "' target=_new title='Click the Project Name to open the Project Workspace'>" + aData.ProjectName + "</a>");
        $("#tblActiveProjects").setCell(rowid,'ActiveRisks',"<a href='" + aData.LinkToWorkspace + "/Lists/Risks' target=_new title='Click to open the Project Risks list'>" + aData.ActiveRisks + "</a>");
        $("#tblActiveProjects").setCell(rowid,'ActiveIssues',"<a href='" + aData.LinkToWorkspace + "/Lists/Issues' target=_new title='Click to open the Project Issues list'>" + aData.ActiveIssues + "</a>");
        $("#tblActiveProjects").setCell(rowid,'Delete',"<img src='../Images/ButtonImages/delete_small.png' onclick=alert('" + rowid + "'); />");
        if (aData.IsOverdue=='True'){
            $("#tblActiveProjects").setCell(rowid,'ProjectStatusDate',"<a href='Reports/RPT_Dashboard.asp?ReportProjectID= " + rowid + "' target=_new title='Progress Updates on this project is outdated! Click to open the latest Project Dashboard'>" + $("#tblActiveProjects").getCell(rowid,4) + "</a>","gridLink gridOverdue");
        }
        else{
            $("#tblActiveProjects").setCell(rowid,'ProjectStatusDate',"<a href='Reports/RPT_Dashboard.asp?ReportProjectID=" + rowid + "' target=_new title='Click to open the latest Project Dashboard' class='gridLink'>" + $("#tblActiveProjects").getCell(rowid,4) + "</a>","gridLink");
        }
    }

});

The grid works 100% on 3.6.5, but when I upgrade to 3.72, 3.8.0 or 3.8.1, the sorting of the date colum is not working. I get "NaN" errors in this column.

Thanks!

I already see one small errors in your javaScript file: there are no autoWidth parameter in jqGrid: only autowidth.

Moreover if groupLabel column contain unique data for every grid row you should probably better define key:true in the groupLabel column definition. Then you can remove id: 'groupLabel' from the jsonReader.

Instead of setting datatype to 'local' inside of loadComplete it is better to use new parameter loadonce:true which do the same.

Best regards
Oleg 

The data loads fine initially but when I click a column all the data disapears.