Guriddo » kccarter's Replies

kccarter

Guriddo

Forum Replies Created

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

Author

Replies

October 20, 2012 at 6:16 am in reply to: Jqgrid toolbar search and multi select – multiple filters for one column. #100336

kccarter

Participant

I was able to get a jquery multi select to work on the jqgrid toolbar filter in fire fox. For some reason this fails in IE but works for fire fox. does anyone know the reason?

October 20, 2012 at 1:33 am in reply to: True Scrolling not request page 2 or more #100335

kccarter

Participant

$(document).ready(function () { &#039;use strict&#039;;<br />
function width() {<br />
return ($(&#039;#MainContent_SectionGrid&#039;).parent()[0].offsetWidth);<br />
}<br />
<br />
function height() {<br />
return ($(&#039;#MainContent_SectionGrid&#039;).parent()[0].offsetHeight - 75);<br />
}<br />
if ($(&#039;.ui-jqgrid&#039;, $(&#039;#MainContent_SectionGrid&#039;)).length === 0) {<br />
var grid_sectiongrid = $("#MainContent_SectionGrid_grid"), pager = "#MainContent_SectionGrid_pager", lastSel, initialized = false;<br />
<br />
grid_sectiongrid.jqGrid({<br />
datatype: "json",<br />
ajaxGridOptions: { contentType: "application/json", dataType: "json" },<br />
serializeGridData: function (data) {<br />
return $.isFunction(page.section.serialize) ? page.section.serialize.call($(&#039;#MainContent_SectionGrid_grid&#039;), data) : data;<br />
},<br />
modifyPostData: function (data) {<br />
return $.isFunction(page.section.serialize) ? page.section.serialize.call($(&#039;#MainContent_SectionGrid_grid&#039;), data) : data;<br />
},<br />
ajaxRowOptions: { contentType: "application/x-www-form-urlencoded", dataType: "json" },<br />
ajaxDelOptions: { contentType: "application/x-www-form-urlencoded", dataType: "json" },<br />
serializeRowData: function (data) {<br />
return $.isFunction(page.section.serialize) ? page.section.serialize.call($(&#039;#MainContent_SectionGrid_grid&#039;), data) : data;<br />
},<br />
mtype: "GET",<br />
imgpath: &#039;&#039;,<br />
jsonReader: {<br />
repeatitems: false,<br />
id: "0"<br />
},<br />
meta: {"table":"section.data","name":null,"actions":{"canInlineEditRow":false,"canEditRow":false,"canDeleteRow":false,"canRetrieveRow":false},"args":{"tableID":"MainContent_SectionGrid","callbackID":"ctl00$MainContent$SectionGrid"}},<br />
multiboxonly: true,<br />
sortorder: "asc",<br />
scroll: 1, rowNum: 100, rownumbers: true, rownumWidth: 50,<br />
viewrecords: true,<br />
url: "/Services/Data.svc/QueryGridResults?typename=section.data&amp;isentity=false&amp;action=Equal&amp;indexID=acb6f080-7db9-46e6-9f6b-6036f703aee2",<br />
height: height(),<br />
width: width(),<br />
colNames: ["Action", "QC SS SectionDataID", "Error", "QC ProjectID", "Comments", "Resolved", "Comments", "File Name", "Unique ID", "Site", "Team #", "Inspector", "Special Area", "Bldg Num", "Bldg Name", "Bldg Area (SF)", "Bldg Year", "Num Floors", "System", "Component", "Section Name", "Mat/Equip Type", "Comp Type", "Quantity", "UM", "Inst Year", "Inv Comments", "Insp Date", "Insp Type", "Rating", "CompType PrevValue", "CompType isChanged", "Quantity PrevValue", "Quantity IsChanged", "UM PrevValue", "UM IsChanged", "InstYear PrevValue", "InstYear IsChanged", "InvComments isChanged", "InvComments PrevValue", "InspDate isChanged", "InspDate PrevValue", "InspType PrevValue", "InspType isChanged", "Rating isChanged", "Rating PrevValue", "InspComments", "InspComments isChanged", "InspComments PrevValue"],<br />
colModel: [<br />
{ name: &#039;SectionGrid&#039;, index: &#039;Action&#039;, width: 100, sortable: false, search: false, align: &#039;center&#039;, formatter: function () { return &#039;&#039;; }, hidden: true, resizable: false, frozen: true },<br />
{ name: &#039;QC_SS_SectionDataID&#039;, index: &#039;QC_SS_SectionDataID&#039;, label: &#039;QC_SS_SectionDataID&#039;, hidden: true, search: true, sortable: false, key: true, editable: true, editrules: { edithidden: true }, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;QCErrorsFound&#039;, index: &#039;QCErrorsFound&#039;, label: &#039;QCErrorsFound&#039;, search: true, sortable: true, width: 75, align: &#039;center&#039;, formatter: &#039;checkbox&#039;, editable: true, edittype: &#039;checkbox&#039;, editoptions: { value: "Y:N" }, editrules: {  }, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;QC_ProjectID&#039;, index: &#039;QC_ProjectID&#039;, label: &#039;QC_ProjectID&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;1&#039; } },<br />
{ name: &#039;QCComments&#039;, index: &#039;QCComments&#039;, label: &#039;QCComments&#039;, search: true, sortable: true, width: 250, align: &#039;left&#039;, editable: true, edittype: &#039;textarea&#039;, editoptions: {  }, editrules: {  }, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InspectorResolved&#039;, index: &#039;InspectorResolved&#039;, label: &#039;InspectorResolved&#039;, search: true, sortable: true, width: 75, align: &#039;center&#039;, formatter: &#039;checkbox&#039;, editable: true, edittype: &#039;checkbox&#039;, editoptions: { value: "Y:N" }, editrules: {  }, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InspectorComments&#039;, index: &#039;InspectorComments&#039;, label: &#039;InspectorComments&#039;, search: true, sortable: true, width: 250, align: &#039;left&#039;, editable: true, edittype: &#039;textarea&#039;, editoptions: {  }, editrules: {  }, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;BREDFileName&#039;, index: &#039;BREDFileName&#039;, label: &#039;BREDFileName&#039;, search: true, sortable: true, width: 150, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;UniqueID&#039;, index: &#039;UniqueID&#039;, label: &#039;UniqueID&#039;, search: true, sortable: true, width: 150, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;Site&#039;, index: &#039;Site&#039;, label: &#039;Site&#039;, search: true, sortable: true, width: 150, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;TeamNumber&#039;, index: &#039;TeamNumber&#039;, label: &#039;TeamNumber&#039;, search: true, sortable: true, width: 150, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;Inspector&#039;, index: &#039;Inspector&#039;, label: &#039;Inspector&#039;, search: true, sortable: true, width: 100, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;SpecialArea&#039;, index: &#039;SpecialArea&#039;, label: &#039;SpecialArea&#039;, search: true, sortable: true, width: 100, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;BldgNum&#039;, index: &#039;BldgNum&#039;, label: &#039;BldgNum&#039;, search: true, sortable: true, width: 75, align: &#039;right&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;BldgName&#039;, index: &#039;BldgName&#039;, label: &#039;BldgName&#039;, search: true, sortable: true, width: 150, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;BldgArea_SF&#039;, index: &#039;BldgArea_SF&#039;, label: &#039;BldgArea_SF&#039;, search: true, sortable: true, width: 75, align: &#039;right&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;BldgYear&#039;, index: &#039;BldgYear&#039;, label: &#039;BldgYear&#039;, search: true, sortable: true, width: 75, align: &#039;right&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;NumFloors&#039;, index: &#039;NumFloors&#039;, label: &#039;NumFloors&#039;, search: true, sortable: true, width: 75, align: &#039;right&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;SystemCode&#039;, index: &#039;SystemCode&#039;, label: &#039;SystemCode&#039;, search: true, sortable: true, width: 150, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;Component&#039;, index: &#039;Component&#039;, label: &#039;Component&#039;, search: true, sortable: true, width: 150, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;SectionName&#039;, index: &#039;SectionName&#039;, label: &#039;SectionName&#039;, search: true, sortable: true, width: 150, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;MatEquipType&#039;, index: &#039;MatEquipType&#039;, label: &#039;MatEquipType&#039;, search: true, sortable: true, width: 150, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;CompType&#039;, index: &#039;CompType&#039;, label: &#039;CompType&#039;, search: true, sortable: true, width: 150, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;Quantity&#039;, index: &#039;Quantity&#039;, label: &#039;Quantity&#039;, search: true, sortable: true, width: 75, align: &#039;right&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;UM&#039;, index: &#039;UM&#039;, label: &#039;UM&#039;, search: true, sortable: true, width: 75, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InstYear&#039;, index: &#039;InstYear&#039;, label: &#039;InstYear&#039;, search: true, sortable: true, width: 75, align: &#039;right&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InvComments&#039;, index: &#039;InvComments&#039;, label: &#039;InvComments&#039;, search: true, sortable: true, width: 150, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InspDate&#039;, index: &#039;InspDate&#039;, label: &#039;InspDate&#039;, search: true, sortable: true, width: 75, align: &#039;left&#039;, formatter: &#039;date&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InspType&#039;, index: &#039;InspType&#039;, label: &#039;InspType&#039;, search: true, sortable: true, width: 75, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;Rating&#039;, index: &#039;Rating&#039;, label: &#039;Rating&#039;, search: true, sortable: true, width: 75, align: &#039;right&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;CompType_PrevValue&#039;, index: &#039;CompType_PrevValue&#039;, label: &#039;CompType_PrevValue&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;CompType_isChanged&#039;, index: &#039;CompType_isChanged&#039;, label: &#039;CompType_isChanged&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;Quantity_PrevValue&#039;, index: &#039;Quantity_PrevValue&#039;, label: &#039;Quantity_PrevValue&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;Quantity_IsChanged&#039;, index: &#039;Quantity_IsChanged&#039;, label: &#039;Quantity_IsChanged&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;UM_PrevValue&#039;, index: &#039;UM_PrevValue&#039;, label: &#039;UM_PrevValue&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;UM_IsChanged&#039;, index: &#039;UM_IsChanged&#039;, label: &#039;UM_IsChanged&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InstYear_PrevValue&#039;, index: &#039;InstYear_PrevValue&#039;, label: &#039;InstYear_PrevValue&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InstYear_IsChanged&#039;, index: &#039;InstYear_IsChanged&#039;, label: &#039;InstYear_IsChanged&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InvComments_isChanged&#039;, index: &#039;InvComments_isChanged&#039;, label: &#039;InvComments_isChanged&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InvComments_PrevValue&#039;, index: &#039;InvComments_PrevValue&#039;, label: &#039;InvComments_PrevValue&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InspDate_isChanged&#039;, index: &#039;InspDate_isChanged&#039;, label: &#039;InspDate_isChanged&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InspDate_PrevValue&#039;, index: &#039;InspDate_PrevValue&#039;, label: &#039;InspDate_PrevValue&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InspType_PrevValue&#039;, index: &#039;InspType_PrevValue&#039;, label: &#039;InspType_PrevValue&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InspType_isChanged&#039;, index: &#039;InspType_isChanged&#039;, label: &#039;InspType_isChanged&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;Rating_isChanged&#039;, index: &#039;Rating_isChanged&#039;, label: &#039;Rating_isChanged&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;Rating_PrevValue&#039;, index: &#039;Rating_PrevValue&#039;, label: &#039;Rating_PrevValue&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InspComments&#039;, index: &#039;InspComments&#039;, label: &#039;InspComments&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InspComments_isChanged&#039;, index: &#039;InspComments_isChanged&#039;, label: &#039;InspComments_isChanged&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } },<br />
{ name: &#039;InspComments_PrevValue&#039;, index: &#039;InspComments_PrevValue&#039;, label: &#039;InspComments_PrevValue&#039;, search: true, sortable: true, hidden: true, width: 50, align: &#039;left&#039;, stype: &#039;text&#039;, searchoptions: { searchhidden: false, defaultValue: &#039;&#039; } }],<br />
pager: pager !== undefined ? pager : null,<br />
beforeRequest: function () {<br />
if (!initialized) {<br />
initialized = true;<br />
$(this).jqGrid(&#039;filterToolbar&#039;, { autosearch: true });<br />
if ($.isFunction(this.triggerToolbar)) {<br />
this.triggerToolbar();<br />
}<br />
}<br />
},<br />
loadComplete: page.section.complete,<br />
beforeSelectRow: undefined,<br />
onSelectRow: page.section.select,<br />
onSelectAll: undefined,<br />
gridComplete: undefined,<br />
ondblClickRow: undefined,<br />
onRightClickRow: undefined,<br />
loadError: function (xhr, stat, err) {<br />
alert(err + &#039;nn&#039; + xhr.responseText);<br />
},<br />
editurl: undefined,<br />
shrinkToFit: false,<br />
multiselect: true,<br />
caption: &#039;&#039;,<br />
grouping: false<br />
});<br />
<br />
$(&#039;#MainContent_SectionGrid&#039;).height($(&#039;div&#039;, $(&#039;#MainContent_SectionGrid&#039;)).height());<br />
<br />
if(pager !== undefined) {<br />
grid_sectiongrid.navGrid(pager, { edit: false, add: false, del: false, refresh: true, search: false });<br />
}<br />
<br />
grid_sectiongrid.navButtonAdd(pager, {<br />
caption: "",<br />
position: "first",<br />
buttonicon: "ui-icon-wrench",<br />
title: "Show the current data filter",<br />
onClickButton: function (e) {<br />
var data = $(this).jqGrid(&#039;getGridParam&#039;, &#039;postData&#039;), url = $(this).jqGrid(&#039;getGridParam&#039;, &#039;url&#039;);<br />
<br /><br />
data["filter"] = true;<br />
<br />
function serialize(d) {<br />
return $.isFunction(page.section.serialize) ? page.section.serialize.call($(&#039;#MainContent_SectionGrid_grid&#039;), d) : d;<br />
}<br />
<br />
$.ajax({<br />
url: url,<br />
type: "GET",<br />
contentType: "application/json; charset=utf-8",<br />
data: serialize(data),<br />
success: function (d, t, x) {<br />
if (typeof(d) === &#039;string&#039;) {<br />
d = $.parseJSON(d);<br />
}<br />
<br />
alert(d.filter);<br />
}<br />
});<br />
<br />
delete $(this).jqGrid(&#039;getGridParam&#039;, &#039;postData&#039;)[&#039;filter&#039;];<br />
}<br />
});<br />
<br /><br />
}<br />
});<br />

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

$(document).ready(function () { 'use strict';

function width() {

return ($('#MainContent_SectionGrid').parent()[0].offsetWidth);

}

function height() {

return ($('#MainContent_SectionGrid').parent()[0].offsetHeight - 75);

}

if ($('.ui-jqgrid', $('#MainContent_SectionGrid')).length === 0) {

var grid_sectiongrid = $("#MainContent_SectionGrid_grid"), pager = "#MainContent_SectionGrid_pager", lastSel, initialized = false;

grid_sectiongrid.jqGrid({

datatype: "json",

ajaxGridOptions: { contentType: "application/json", dataType: "json" },

serializeGridData: function (data) {

return $.isFunction(page.section.serialize) ? page.section.serialize.call($('#MainContent_SectionGrid_grid'), data) : data;

},

modifyPostData: function (data) {

return $.isFunction(page.section.serialize) ? page.section.serialize.call($('#MainContent_SectionGrid_grid'), data) : data;

},

ajaxRowOptions: { contentType: "application/x-www-form-urlencoded", dataType: "json" },

ajaxDelOptions: { contentType: "application/x-www-form-urlencoded", dataType: "json" },

serializeRowData: function (data) {

return $.isFunction(page.section.serialize) ? page.section.serialize.call($('#MainContent_SectionGrid_grid'), data) : data;

},

mtype: "GET",

imgpath: '',

jsonReader: {

repeatitems: false,

id: "0"

},

meta: {"table":"section.data","name":null,"actions":{"canInlineEditRow":false,"canEditRow":false,"canDeleteRow":false,"canRetrieveRow":false},"args":{"tableID":"MainContent_SectionGrid","callbackID":"ctl00$MainContent$SectionGrid"}},

multiboxonly: true,

sortorder: "asc",

scroll: 1, rowNum: 100, rownumbers: true, rownumWidth: 50,

viewrecords: true,

url: "/Services/Data.svc/QueryGridResults?typename=section.data&isentity=false&action=Equal&indexID=acb6f080-7db9-46e6-9f6b-6036f703aee2",

height: height(),

width: width(),

colNames: ["Action", "QC SS SectionDataID", "Error", "QC ProjectID", "Comments", "Resolved", "Comments", "File Name", "Unique ID", "Site", "Team #", "Inspector", "Special Area", "Bldg Num", "Bldg Name", "Bldg Area (SF)", "Bldg Year", "Num Floors", "System", "Component", "Section Name", "Mat/Equip Type", "Comp Type", "Quantity", "UM", "Inst Year", "Inv Comments", "Insp Date", "Insp Type", "Rating", "CompType PrevValue", "CompType isChanged", "Quantity PrevValue", "Quantity IsChanged", "UM PrevValue", "UM IsChanged", "InstYear PrevValue", "InstYear IsChanged", "InvComments isChanged", "InvComments PrevValue", "InspDate isChanged", "InspDate PrevValue", "InspType PrevValue", "InspType isChanged", "Rating isChanged", "Rating PrevValue", "InspComments", "InspComments isChanged", "InspComments PrevValue"],

colModel: [

{ name: 'SectionGrid', index: 'Action', width: 100, sortable: false, search: false, align: 'center', formatter: function () { return ''; }, hidden: true, resizable: false, frozen: true },

{ name: 'QC_SS_SectionDataID', index: 'QC_SS_SectionDataID', label: 'QC_SS_SectionDataID', hidden: true, search: true, sortable: false, key: true, editable: true, editrules: { edithidden: true }, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'QCErrorsFound', index: 'QCErrorsFound', label: 'QCErrorsFound', search: true, sortable: true, width: 75, align: 'center', formatter: 'checkbox', editable: true, edittype: 'checkbox', editoptions: { value: "Y:N" }, editrules: { }, stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'QC_ProjectID', index: 'QC_ProjectID', label: 'QC_ProjectID', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '1' } },

{ name: 'QCComments', index: 'QCComments', label: 'QCComments', search: true, sortable: true, width: 250, align: 'left', editable: true, edittype: 'textarea', editoptions: { }, editrules: { }, stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InspectorResolved', index: 'InspectorResolved', label: 'InspectorResolved', search: true, sortable: true, width: 75, align: 'center', formatter: 'checkbox', editable: true, edittype: 'checkbox', editoptions: { value: "Y:N" }, editrules: { }, stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InspectorComments', index: 'InspectorComments', label: 'InspectorComments', search: true, sortable: true, width: 250, align: 'left', editable: true, edittype: 'textarea', editoptions: { }, editrules: { }, stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'BREDFileName', index: 'BREDFileName', label: 'BREDFileName', search: true, sortable: true, width: 150, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'UniqueID', index: 'UniqueID', label: 'UniqueID', search: true, sortable: true, width: 150, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'Site', index: 'Site', label: 'Site', search: true, sortable: true, width: 150, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'TeamNumber', index: 'TeamNumber', label: 'TeamNumber', search: true, sortable: true, width: 150, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'Inspector', index: 'Inspector', label: 'Inspector', search: true, sortable: true, width: 100, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'SpecialArea', index: 'SpecialArea', label: 'SpecialArea', search: true, sortable: true, width: 100, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'BldgNum', index: 'BldgNum', label: 'BldgNum', search: true, sortable: true, width: 75, align: 'right', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'BldgName', index: 'BldgName', label: 'BldgName', search: true, sortable: true, width: 150, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'BldgArea_SF', index: 'BldgArea_SF', label: 'BldgArea_SF', search: true, sortable: true, width: 75, align: 'right', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'BldgYear', index: 'BldgYear', label: 'BldgYear', search: true, sortable: true, width: 75, align: 'right', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'NumFloors', index: 'NumFloors', label: 'NumFloors', search: true, sortable: true, width: 75, align: 'right', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'SystemCode', index: 'SystemCode', label: 'SystemCode', search: true, sortable: true, width: 150, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'Component', index: 'Component', label: 'Component', search: true, sortable: true, width: 150, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'SectionName', index: 'SectionName', label: 'SectionName', search: true, sortable: true, width: 150, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'MatEquipType', index: 'MatEquipType', label: 'MatEquipType', search: true, sortable: true, width: 150, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'CompType', index: 'CompType', label: 'CompType', search: true, sortable: true, width: 150, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'Quantity', index: 'Quantity', label: 'Quantity', search: true, sortable: true, width: 75, align: 'right', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'UM', index: 'UM', label: 'UM', search: true, sortable: true, width: 75, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InstYear', index: 'InstYear', label: 'InstYear', search: true, sortable: true, width: 75, align: 'right', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InvComments', index: 'InvComments', label: 'InvComments', search: true, sortable: true, width: 150, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InspDate', index: 'InspDate', label: 'InspDate', search: true, sortable: true, width: 75, align: 'left', formatter: 'date', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InspType', index: 'InspType', label: 'InspType', search: true, sortable: true, width: 75, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'Rating', index: 'Rating', label: 'Rating', search: true, sortable: true, width: 75, align: 'right', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'CompType_PrevValue', index: 'CompType_PrevValue', label: 'CompType_PrevValue', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'CompType_isChanged', index: 'CompType_isChanged', label: 'CompType_isChanged', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'Quantity_PrevValue', index: 'Quantity_PrevValue', label: 'Quantity_PrevValue', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'Quantity_IsChanged', index: 'Quantity_IsChanged', label: 'Quantity_IsChanged', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'UM_PrevValue', index: 'UM_PrevValue', label: 'UM_PrevValue', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'UM_IsChanged', index: 'UM_IsChanged', label: 'UM_IsChanged', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InstYear_PrevValue', index: 'InstYear_PrevValue', label: 'InstYear_PrevValue', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InstYear_IsChanged', index: 'InstYear_IsChanged', label: 'InstYear_IsChanged', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InvComments_isChanged', index: 'InvComments_isChanged', label: 'InvComments_isChanged', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InvComments_PrevValue', index: 'InvComments_PrevValue', label: 'InvComments_PrevValue', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InspDate_isChanged', index: 'InspDate_isChanged', label: 'InspDate_isChanged', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InspDate_PrevValue', index: 'InspDate_PrevValue', label: 'InspDate_PrevValue', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InspType_PrevValue', index: 'InspType_PrevValue', label: 'InspType_PrevValue', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InspType_isChanged', index: 'InspType_isChanged', label: 'InspType_isChanged', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'Rating_isChanged', index: 'Rating_isChanged', label: 'Rating_isChanged', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'Rating_PrevValue', index: 'Rating_PrevValue', label: 'Rating_PrevValue', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InspComments', index: 'InspComments', label: 'InspComments', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InspComments_isChanged', index: 'InspComments_isChanged', label: 'InspComments_isChanged', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } },

{ name: 'InspComments_PrevValue', index: 'InspComments_PrevValue', label: 'InspComments_PrevValue', search: true, sortable: true, hidden: true, width: 50, align: 'left', stype: 'text', searchoptions: { searchhidden: false, defaultValue: '' } }],

pager: pager !== undefined ? pager : null,

beforeRequest: function () {

if (!initialized) {

initialized = true;

$(this).jqGrid('filterToolbar', { autosearch: true });

if ($.isFunction(this.triggerToolbar)) {

this.triggerToolbar();

}

},

loadComplete: page.section.complete,

beforeSelectRow: undefined,

onSelectRow: page.section.select,

onSelectAll: undefined,

gridComplete: undefined,

ondblClickRow: undefined,

onRightClickRow: undefined,

loadError: function (xhr, stat, err) {

alert(err + 'nn' + xhr.responseText);

},

editurl: undefined,

shrinkToFit: false,

multiselect: true,

caption: '',

grouping: false

});

$('#MainContent_SectionGrid').height($('div', $('#MainContent_SectionGrid')).height());

if(pager !== undefined) {

grid_sectiongrid.navGrid(pager, { edit: false, add: false, del: false, refresh: true, search: false });

}

grid_sectiongrid.navButtonAdd(pager, {

caption: "",

position: "first",

buttonicon: "ui-icon-wrench",

title: "Show the current data filter",

onClickButton: function (e) {

var data = $(this).jqGrid('getGridParam', 'postData'), url = $(this).jqGrid('getGridParam', 'url');

data["filter"] = true;

function serialize(d) {

return $.isFunction(page.section.serialize) ? page.section.serialize.call($('#MainContent_SectionGrid_grid'), d) : d;

}

$.ajax({

url: url,

type: "GET",

contentType: "application/json; charset=utf-8",

data: serialize(data),

success: function (d, t, x) {

if (typeof(d) === 'string') {

d = $.parseJSON(d);

}

alert(d.filter);

}

});

delete $(this).jqGrid('getGridParam', 'postData')['filter'];

}

});

}

});

August 4, 2011 at 2:33 am in reply to: How to define groupText if groupField has more as one items #98541

kccarter

Participant

in order to maintain compatibility with IE the following needs to be done

if (Array.prototype.indexOf === undefined) {

August 4, 2011 at 12:50 am in reply to: How to define groupText if groupField has more as one items #98540

kccarter

Participant

you can enable multiple mapping for the group by text with the following code:

groupingRender: function(c, b) {

Author

Replies

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