PDA

View Full Version : Grid not displaying full results



ryanyoungsma
7 May 2009, 10:50 AM
Hi.

I have a grid that is not displaying the full results for a reason that I can not detect. When I look at the straight query results it brings back everything it should, but when loaded to the grid, it is not displaying everything. Any thoughts?

Here is the Grid code:


//Grid
var QuoteGrid = new Ext.grid.GridPanel({
store: new Ext.data.JsonStore({
url:'pages/supplier/data/getFullQuotes.php'
,id: 'id'
,totalProperty: 'total'
,root: 'data'
,fields:[
{name:'supp_q_id', type: 'float'}
,{name:'name', type: 'string'}
,{name:'new_file', type: 'string'}
,{name:'ext', type: 'string'}
,{name:'original_file', type: 'string'}
,{name:'quote_date', type: 'string'}
,{name:'description', type: 'string'}
]
})
,cm: new Ext.grid.ColumnModel([
{dataIndex: 'supp_q_id', header: 'Id', sortable: true, fixed: true, width: 30}
,{dataIndex: 'name', header: 'Supplier Name', sortable: true, width: 100}
,{dataIndex: 'description', header: 'Description', sortable: false, width: 150}
,{dataIndex: 'original_file', header: 'File Name', sortable: false}
,{dataIndex: 'quote_date', header: 'Date Added', sortable: true}
,{dataIndex: 'new_file', header: 'Download', sortable: false, renderer: viewQuote, width: 60}
])
//,plugins: filters
,sm: new Ext.grid.RowSelectionModel({singleSelect:true})
,title: 'Supplier Quotes'
,id: 'supplierList'
,viewConfig:{forceFit:true}
,enableColLock: false
,loadMask: true
,height: 300
,width: '100%'
,margins: '5 5 5 5'
,frame:true
,border: false
});
QuoteGrid.store.load();
//End QuoteGridHere is the response from the server.


{"total":"8","data":[{"supp_q_id":"14","suppliers_id":"16","description":"WID - CIP1C","supp_q_f_id"
:"9","supp_q_f_s_id":"16","supplier_quotes_id":"14","original_file":"quote_21491","new_file":"8979a40dcc
.pdf","quote_ext":null,"ext":"pdf","quote_date":"2009-05-07","id":"16","name":"Jor-Mac Company"},{"supp_q_id"
:"13","suppliers_id":"16","description":"WID - CIP1B","supp_q_f_id":"8","supp_q_f_s_id":"16","supplier_quotes_id"
:"13","original_file":"quote_21490","new_file":"c369dc7b77.pdf","quote_ext":null,"ext":"pdf","quote_date"
:"2009-05-07","id":"16","name":"Jor-Mac Company"},{"supp_q_id":"12","suppliers_id":"16","description"
:"WID - CIP1A","supp_q_f_id":"7","supp_q_f_s_id":"16","supplier_quotes_id":"12","original_file":"quote_21489"
,"new_file":"d354fc818f.pdf","quote_ext":null,"ext":"pdf","quote_date":"2009-05-07","id":"16","name"
:"Jor-Mac Company"},{"supp_q_id":"11","suppliers_id":"19","description":"Italy - Fire resistant cabinets"
,"supp_q_f_id":"6","supp_q_f_s_id":"19","supplier_quotes_id":"11","original_file":"a.t.villausa,inc.-q20751"
,"new_file":"bcabbee965.pdf","quote_ext":null,"ext":"pdf","quote_date":"2009-05-07","id":"19","name"
:"A & A Securall Prod"},{"supp_q_id":"10","suppliers_id":"14","description":"RICE Raceway","supp_q_f_id"
:"5","supp_q_f_s_id":"14","supplier_quotes_id":"10","original_file":"101282r2","new_file":"c51ad1c27d
.pdf","quote_ext":null,"ext":"pdf","quote_date":"2009-05-05","id":"14","name":"Post Glover LifeLink"
},{"supp_q_id":"9","suppliers_id":"18","description":"New Upright & Horiz Extrusions","supp_q_f_id":"4"
,"supp_q_f_s_id":"18","supplier_quotes_id":"9","original_file":"q71126a","new_file":"4aed461eba.pdf"
,"quote_ext":null,"ext":"pdf","quote_date":"2009-05-05","id":"18","name":"NSM"},{"supp_q_id":"8","suppliers_id"
:"15","description":"Test - WID Items","supp_q_f_id":"3","supp_q_f_s_id":"15","supplier_quotes_id":"8"
,"original_file":"graybarquotation-208676689","new_file":"0111dfad14.pdf","quote_ext":null,"ext":"pdf"
,"quote_date":"2009-05-04","id":"15","name":"Graybar"},{"supp_q_id":"7","suppliers_id":"15","description"
:"WID - CIP & CM","supp_q_f_id":"2","supp_q_f_s_id":"15","supplier_quotes_id":"7","original_file":"graybarquotation-208676689"
,"new_file":"0111dfad14.pdf","quote_ext":null,"ext":"pdf","quote_date":null,"id":"15","name":"Graybar"
}]}Example items that are not displaying are:

"supp_q_id":"14"
"supp_q_id":"13"

micgala
8 May 2009, 5:43 AM
This is GXT help forum...
I guess you need to post your question to ext forum...

ryanyoungsma
8 May 2009, 5:55 AM
Yes, sorry about that, realized that this morning. Not sure how that happened. Tried to delete it, but did not see a way. Thanks.