Guriddo » Topic: ts.rows is undefined

ts.rows is undefined

Guriddo
ts.rows is undefined

This topic has 6 replies, 6 voices, and was last updated 15 years, 11 months ago by Dave.

Creator

Topic

January 12, 2009 at 10:59 pm #72597

faizaliqbaal

Participant

hi all,

Back again

for some reason my grid is not loading data..here is what i my handler returns

{<br />  "page": "1",<br />  "total": "1",<br />  "records": "22",<br />  "rows": [<br />    {<br />      "id": "1231822674171",<br />      "cell": [<br />        "-",<br />        "-",<br />        "AlanSujovolsky",<br />        "User1",<br />        "-",<br />        "2401000270",<br />        "0270",<br />        "AlanSujovolskyGenericSIP",<br />        "Details",<br />        "-"<br />      ]<br />    },<br />    {<br />      "id": "1231822674171",<br />      "cell": [<br />        "-",<br />        "-",<br />        "AlanSujovolsky",<br />        "User2",<br />        "-",<br />        "2401000271",<br />        "0271",<br />        "AlanSujovolskyGenericSIP",<br />        "Details",<br />        "-"<br />      ]<br />    },<br />    {<br />      "id": "1231822674171",<br />      "cell": [<br />        "-",<br />        "-",<br />        "AlanSujovolsky",<br />        "User3",<br />        "-",<br />        "-",<br />        "1272",<br />        "AlanSujovolskyGenericSIP",<br />        "Details",<br />        "-"<br />      ]<br />    },<br />    {<br />      "id": "1231822674171",<br />      "cell": [<br />        "-",<br />        "-",<br />        "Marcelo",<br />        "Valotta",<br />        "-",<br />        "-",<br />        "5551",<br />        "-",<br />        "Details",<br />        "-"<br />      ]<br />    },<br />    {<br />      "id": "1231822674171",<br />      "cell": [<br />        "-",<br />        "-",<br />        "Marcelo Enrique",<br />        "Valotta",<br />        "-",<br />        "-",<br />        "5552",<br />        "-",<br />        "Details",<br />        "-"<br />      ]<br />    },<br />    {<br />      "id": "1231822674171",<br />      "cell": [<br />        "-",<br />        "-",<br />        "AlanSujovolsky",<br />        "User1",<br />        "-",<br />        "2401000270",<br />        "0270",<br />        "AlanSujovolskyGenericSIP",<br />        "Details",<br />        "-"<br />      ]<br />    },<br />    {<br />      "id": "1231822674171",<br />      "cell": [<br />        "-",<br />        "-",<br />        "AlanSujovolsky",<br />        "User2",<br />        "-",<br />        "2401000271",<br />        "0271",<br />        "AlanSujovolskyGenericSIP",<br />        "Details",<br />        "-"<br />      ]<br />    },<br />    {<br />      "id": "1231822674171",<br />      "cell": [<br />        "-",<br />        "-",<br />        "AlanSujovolsky",<br />        "User3",<br />        "-",<br />        "-",<br />        "1272",<br />        "AlanSujovolskyGenericSIP",<br />        "Details",<br />        "-"<br />      ]<br />    },<br />    {<br />      "id": "1231822674171",<br />      "cell": [<br />        "-",<br />        "-",<br />        "Marcelo",<br />        "Valotta",<br />        "-",<br />        "-",<br />        "5551",<br />        "-",<br />        "Details",<br />        "-"<br />      ]<br />    },<br />    {<br />      "id": "1231822674171",<br />      "cell": [<br />        "-",<br />        "-",<br />        "Marcelo Enrique",<br />        "Valotta",<br />        "-",<br />        "-",<br />        "5552",<br />        "-",<br />        "Details",<br />        "-"<br />      ]<br />    },<br />    {<br />      "id": "1231822674171",<br />      "cell": [<br />        "-",<br />        "-",<br />        "AlanSujovolsky",<br />        "User1",<br />        "-",<br />        "2401000270",<br />        "0270",<br />        "AlanSujovolskyGenericSIP",<br />        "Details",<br />        "-"<br />      ]<br />    },<br />    {<br />      "id": "1231822674171",<br />      "cell": [<br />        "-",<br />        "-",<br />        "AlanSujovolsky",<br />        "User2",<br />        "-",<br />        "2401000271",<br />        "0271",<br />        "AlanSujovolskyGenericSIP",<br />        "Details",<br />        "-"<br />      ]<br />    },<br />    {<br />      "id": "1231822674171",<br />      "cell": [<br />        "-",<br />        "-",<br />        "AlanSujovolsky",<br />        "User3",<br />        "-",<br />        "-",<br />        "1272",<br />        "AlanSujovolskyGenericSIP",<br />        "Details",<br />        "-"<br />      ]<br />    },<br />    {<br />      "id": "1231822674171",<br />      "cell": [<br />        "-",<br />        "-",<br />        "Marcelo",<br />        "Valotta",<br />        "-",<br />        "-",<br />        "5551",<br />        "-",<br />        "Details",<br />        "-"<br />      ]<br />    },<br />    {<br />      "id": "mainautoatt@xdp.broadsoft.com",<br />      "cell": [<br />        "-",<br />        "MainAttendant",<br />        "-",<br />        "-",<br />        "Support \\ Tier 1",<br />        "2401000273",<br />        "0273",<br />        "N/A",<br />        "Detail Members",<br />        "mainautoatt@xdp.broadsoft.com"<br />      ]<br />    },<br />    {<br />      "id": "centerl1@xdp.broadsoft.com",<br />      "cell": [<br />        "-",<br />        "Call Center Asujo 1",<br />        "-",<br />        "-",<br />        "",<br />        "2401000272",<br />        "0272",<br />        "N/A",<br />        "Detail Members",<br />        "centerl1@xdp.broadsoft.com"<br />      ]<br />    },<br />    {<br />      "id": "HGAsujo1@xdp.broadsoft.com",<br />      "cell": [<br />        "-",<br />        "Hunt Group Asujo 1",<br />        "-",<br />        "-",<br />        "",<br />        "2401000274",<br />        "0274",<br />        "N/A",<br />        "Detail Members",<br />        "HGAsujo1@xdp.broadsoft.com"<br />      ]<br />    },<br />    {<br />      "id": "mainautoatt@xdp.broadsoft.com",<br />      "cell": [<br />        "-",<br />        "MainAttendant",<br />        "-",<br />        "-",<br />        "Support \\ Tier 1",<br />        "2401000273",<br />        "0273",<br />        "N/A",<br />        "Detail Members",<br />        "mainautoatt@xdp.broadsoft.com"<br />      ]<br />    },<br />    {<br />      "id": "centerl1@xdp.broadsoft.com",<br />      "cell": [<br />        "-",<br />        "Call Center Asujo 1",<br />        "-",<br />        "-",<br />        "",<br />        "2401000272",<br />        "0272",<br />        "N/A",<br />        "Detail Members",<br />        "centerl1@xdp.broadsoft.com"<br />      ]<br />    },<br />    {<br />      "id": "HGAsujo1@xdp.broadsoft.com",<br />      "cell": [<br />        "-",<br />        "Hunt Group Asujo 1",<br />        "-",<br />        "-",<br />        "",<br />        "2401000274",<br />        "0274",<br />        "N/A",<br />        "Detail Members",<br />        "HGAsujo1@xdp.broadsoft.com"<br />      ]<br />    },<br />    {<br />      "id": "mainautoatt@xdp.broadsoft.com",<br />      "cell": [<br />        "-",<br />        "MainAttendant",<br />        "-",<br />        "-",<br />        "Support \\ Tier 1",<br />        "2401000273",<br />        "0273",<br />        "N/A",<br />        "Detail Members",<br />        "mainautoatt@xdp.broadsoft.com"<br />      ]<br />    },<br />    {<br />      "id": "centerl1@xdp.broadsoft.com",<br />      "cell": [<br />        "-",<br />        "Call Center Asujo 1",<br />        "-",<br />        "-",<br />        "",<br />        "2401000272",<br />        "0272",<br />        "N/A",<br />        "Detail Members",<br />        "centerl1@xdp.broadsoft.com"<br />      ]<br />    }<br />  ]<br /><br /><br /><br />here is my grid code<br /><br />		jqGrid({ <br />				datatype: "json",<br />				url:"pbxEntityMap.do?opName=all",<br />				colNames:["Type","User Name","First Name","Last Name","Department","Phone Number","Ext","Device Id","Command","id"], <br />				colModel:[ 	<br />							<br />							{name:&#39;Type&#39;,index:1, width:80, align:"center",editable:false},<br />							{name:&#39;User Name&#39;,index:2, width:80, align:"center",editable:false},<br />							{name:&#39;First Name&#39;,index:3, width:175,align:"center",editable:false}, <br />							{name:&#39;Last Name&#39;,index:4, width:180,align:"center",editable:false}, <br />							{name:&#39;Department&#39;,index:5, width:90, align:"center",editable:false} ,<br />							{name:&#39;Phone Number&#39;,index:6, width:90, align:"center",editable:false},<br />							{name:&#39;Ext.&#39;,index:7, width:80, align:"center",editable:false},<br />							{name:&#39;Device Id&#39;,index:8, width:80, align:"center",editable:false},<br />							{name:&#39;Command&#39;,index:9, width:100, align:"center",editable:false},<br />							{name:&#39;id&#39;,index:10,hidden:true}<br />							 ], <br />							 sortname: "id",<br />	    					sortorder: "desc",<br />							imgpath: "../css/images", <br />							caption: "PBX Entities" }); <br /><br /><br />what could be wrong herein..<br /><br />Thanks all,<br />}

{ "page": "1", "total": "1", "records": "22", "rows": [ { "id": "1231822674171", "cell": [ "-", "-", "AlanSujovolsky", "User1", "-", "2401000270", "0270", "AlanSujovolskyGenericSIP", "Details", "-" ] }, { "id": "1231822674171", "cell": [ "-", "-", "AlanSujovolsky", "User2", "-", "2401000271", "0271", "AlanSujovolskyGenericSIP", "Details", "-" ] }, { "id": "1231822674171", "cell": [ "-", "-", "AlanSujovolsky", "User3", "-", "-", "1272", "AlanSujovolskyGenericSIP", "Details", "-" ] }, { "id": "1231822674171", "cell": [ "-", "-", "Marcelo", "Valotta", "-", "-", "5551", "-", "Details", "-" ] }, { "id": "1231822674171", "cell": [ "-", "-", "Marcelo Enrique", "Valotta", "-", "-", "5552", "-", "Details", "-" ] }, { "id": "1231822674171", "cell": [ "-", "-", "AlanSujovolsky", "User1", "-", "2401000270", "0270", "AlanSujovolskyGenericSIP", "Details", "-" ] }, { "id": "1231822674171", "cell": [ "-", "-", "AlanSujovolsky", "User2", "-", "2401000271", "0271", "AlanSujovolskyGenericSIP", "Details", "-" ] }, { "id": "1231822674171", "cell": [ "-", "-", "AlanSujovolsky", "User3", "-", "-", "1272", "AlanSujovolskyGenericSIP", "Details", "-" ] }, { "id": "1231822674171", "cell": [ "-", "-", "Marcelo", "Valotta", "-", "-", "5551", "-", "Details", "-" ] }, { "id": "1231822674171", "cell": [ "-", "-", "Marcelo Enrique", "Valotta", "-", "-", "5552", "-", "Details", "-" ] }, { "id": "1231822674171", "cell": [ "-", "-", "AlanSujovolsky", "User1", "-", "2401000270", "0270", "AlanSujovolskyGenericSIP", "Details", "-" ] }, { "id": "1231822674171", "cell": [ "-", "-", "AlanSujovolsky", "User2", "-", "2401000271", "0271", "AlanSujovolskyGenericSIP", "Details", "-" ] }, { "id": "1231822674171", "cell": [ "-", "-", "AlanSujovolsky", "User3", "-", "-", "1272", "AlanSujovolskyGenericSIP", "Details", "-" ] }, { "id": "1231822674171", "cell": [ "-", "-", "Marcelo", "Valotta", "-", "-", "5551", "-", "Details", "-" ] }, { "id": "mainautoatt@xdp.broadsoft.com", "cell": [ "-", "MainAttendant", "-", "-", "Support \\ Tier 1", "2401000273", "0273", "N/A", "Detail Members", "mainautoatt@xdp.broadsoft.com" ] }, { "id": "centerl1@xdp.broadsoft.com", "cell": [ "-", "Call Center Asujo 1", "-", "-", "", "2401000272", "0272", "N/A", "Detail Members", "centerl1@xdp.broadsoft.com" ] }, { "id": "HGAsujo1@xdp.broadsoft.com", "cell": [ "-", "Hunt Group Asujo 1", "-", "-", "", "2401000274", "0274", "N/A", "Detail Members", "HGAsujo1@xdp.broadsoft.com" ] }, { "id": "mainautoatt@xdp.broadsoft.com", "cell": [ "-", "MainAttendant", "-", "-", "Support \\ Tier 1", "2401000273", "0273", "N/A", "Detail Members", "mainautoatt@xdp.broadsoft.com" ] }, { "id": "centerl1@xdp.broadsoft.com", "cell": [ "-", "Call Center Asujo 1", "-", "-", "", "2401000272", "0272", "N/A", "Detail Members", "centerl1@xdp.broadsoft.com" ] }, { "id": "HGAsujo1@xdp.broadsoft.com", "cell": [ "-", "Hunt Group Asujo 1", "-", "-", "", "2401000274", "0274", "N/A", "Detail Members", "HGAsujo1@xdp.broadsoft.com" ] }, { "id": "mainautoatt@xdp.broadsoft.com", "cell": [ "-", "MainAttendant", "-", "-", "Support \\ Tier 1", "2401000273", "0273", "N/A", "Detail Members", "mainautoatt@xdp.broadsoft.com" ] }, { "id": "centerl1@xdp.broadsoft.com", "cell": [ "-", "Call Center Asujo 1", "-", "-", "", "2401000272", "0272", "N/A", "Detail Members", "centerl1@xdp.broadsoft.com" ] } ] here is my grid code jqGrid({ datatype: "json", url:"pbxEntityMap.do?opName=all", colNames:["Type","User Name","First Name","Last Name","Department","Phone Number","Ext","Device Id","Command","id"], colModel:[ {name:'Type',index:1, width:80, align:"center",editable:false}, {name:'User Name',index:2, width:80, align:"center",editable:false}, {name:'First Name',index:3, width:175,align:"center",editable:false}, {name:'Last Name',index:4, width:180,align:"center",editable:false}, {name:'Department',index:5, width:90, align:"center",editable:false} , {name:'Phone Number',index:6, width:90, align:"center",editable:false}, {name:'Ext.',index:7, width:80, align:"center",editable:false}, {name:'Device Id',index:8, width:80, align:"center",editable:false}, {name:'Command',index:9, width:100, align:"center",editable:false}, {name:'id',index:10,hidden:true} ], sortname: "id", sortorder: "desc", imgpath: "../css/images", caption: "PBX Entities" }); what could be wrong herein.. Thanks all, }

Creator

Topic

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

Author

Replies

January 12, 2009 at 11:12 pm #84875

faizaliqbaal

Participant

found out the issue…my mistake…wrong id. sorry for the post

July 7, 2009 at 4:06 am #87552

robert.w

Participant

hi,

I'm getting the same error message – what id did you mean?

July 20, 2009 at 10:36 am #87710

hughitt1

Participant

I ran into the same problem recently. The problem turned out to be that I was attempting to use a DIV instead of a TABLE for the datagrid container. Using a table instead resolved the issue, e.g.

        <span class="comment"><!-- Grid --></span><br />        &lt;<span class="start-tag">table</span><span class="attribute-name"> id</span>=<span class="attribute-value">"search-results-datagrid" </span><span class="attribute-name">class</span>=<span class="attribute-value">"scroll" </span><span class="attribute-name">cellpadding</span>=<span class="attribute-value">"0" </span><span class="attribute-name">cellspacing</span>=<span class="attribute-value">"0"</span>&gt;&lt;/<span class="end-tag">table</span>&gt; <br />        <br />        <span class="comment"><!-- Pager --></span><br />        &lt;<span class="start-tag">div</span><span class="attribute-name"> id</span>=<span class="attribute-value">"search-results-pager" </span><span class="attribute-name">class</span>=<span class="attribute-value">"scroll" </span><span class="attribute-name">style</span>=<span class="attribute-value">"text-align:center;"</span>&gt;&lt;/<span class="end-tag">div</span>&gt; <br /><br />Best,<br />Keith<br />

<table id="search-results-datagrid" class="scroll" cellpadding="0" cellspacing="0"></table>  <div id="search-results-pager" class="scroll" style="text-align:center;"></div> Best, Keith

January 22, 2010 at 10:50 am #92231