jQWidgets Forums

This topic contains 4 replies, has 2 voices, and was last updated by rharding98 11 years, 9 months ago.
Viewing 5 posts - 1 through 5 (of 5 total)
Author

grid checkbox not checked Posts
September 9, 2013 at 6:03 pm grid checkbox not checked #28595
Participant
Here are the relevant portions of the config. I’m not sure why the checkboxes are not being checked on true when the grid is rendered.
column
{
“text”: “Is Land Only”,
“datafield”: “IsLandOnly”,
“width”: “90”,
“cellsformat”: “”,
“hidden”: false,
“columntype”: “checkbox”
}
datainfo
{
“name”: “IsLandOnly”,
“type”: “bool”,
“map”: “”
}
data
“isLandOnly”: true,
Thanks,
Roy
September 9, 2013 at 6:42 pm grid checkbox not checked #28597
Peter Stoev
Keymaster
Hi Roy,
To render a boolean column, you should specify it as a boolean column during the initialization. Example: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/cellediting.htm?arctic
Best Regards,
Peter Stoev
jQWidgets Team
http://www.jqwidgets.com/
September 9, 2013 at 7:06 pm grid checkbox not checked #28600
rharding98
Participant
Yeah it renders fine but it is not being checked even though it is true. The json data is coming from an ajax request not shown here.
Thanks,
Roy

var jsonColumns = [{"text":"Job ID","datafield":"JobID","width":"","cellsformat":"","hidden":true},{"text":"Property Type","datafield":"PropertyType","width":"300","cellsformat":"","hidden":false},{"text":"City","datafield":"City","width":"100","cellsformat":"","hidden":false},{"text":"State","datafield":"ST","width":"50","cellsformat":"","hidden":false},{"text":"Project #","datafield":"Retechsno","width":"100","cellsformat":"","hidden":false},{"text":"Date of Value","datafield":"EffDOV","width":"90","cellsformat":"d","hidden":false},{"text":"Improv. Size","datafield":"PropertySize","width":"90","cellsformat":"n0","hidden":false},{"text":"Unit","datafield":"PropUnit","width":"60","cellsformat":"","hidden":false},{"text":"Site Size","datafield":"LandSize","width":"90","cellsformat":"n2","hidden":false},{"text":"Unit","datafield":"LandSizeUnit","width":"60","cellsformat":"","hidden":false},{"text":"Is Land Only","datafield":"IsLandOnly","width":"90","cellsformat":"","hidden":false,"columntype":"checkbox"},{"text":"As-Is Value","datafield":"Val1","width":"100","cellsformat":"c0","hidden":false},{"text":"As-Is Occupancy","datafield":"Occ1","width":"100","cellsformat":"p0","hidden":false},{"text":"UponStabilization Value","datafield":"Val5","width":"100","cellsformat":"c0","hidden":false},{"text":"UponStabilization Occupancy","datafield":"Occ5","width":"100","cellsformat":"p0","hidden":false},{"text":"Effective OAR","datafield":"OAR","width":"100","cellsformat":"p2","hidden":false},{"text":"Overall PGIM","datafield":"MAGIM","width":"100","cellsformat":"n2","hidden":false},{"text":"Effective $/Index","datafield":"EffValPerIdx","width":"100","cellsformat":"c0","hidden":false},{"text":"Income App Value","datafield":"IAStabilizedVal","width":"100","cellsformat":"c0","hidden":false},{"text":"Income App $/Index","datafield":"IAPerIdx","width":"100","cellsformat":"c0","hidden":false},{"text":"Income App OAR","datafield":"IAOAR","width":"100","cellsformat":"p0","hidden":false},{"text":"NOI","datafield":"IANOI","width":"50","cellsformat":"c0","hidden":false},{"text":"Expense Ratio","datafield":"IAExpenseRatio","width":"100","cellsformat":"p0","hidden":false},{"text":"Market App Value","datafield":"MAStabilizedVal","width":"100","cellsformat":"c0","hidden":false},{"text":"IMarket App $/Index","datafield":"MAValPerIdx","width":"100","cellsformat":"c0","hidden":false},{"text":"Discount Rate","datafield":"DiscountRate","width":"90","cellsformat":"p0","hidden":false},{"text":"Files","datafield":"","width":"90","cellsformat":"","hidden":false}]
var jsonDatafields = [{"name":"JobID","type":"int","map":""},{"name":"PropertyType","type":"string","map":""},{"name":"City","type":"string","map":""},{"name":"ST","type":"string","map":""},{"name":"Retechsno","type":"string","map":""},{"name":"EffDOV","type":"date","map":""},{"name":"PropertySize","type":"float","map":""},{"name":"PropUnit","type":"string","map":""},{"name":"LandSize","type":"float","map":""},{"name":"LandSizeUnit","type":"string","map":""},{"name":"IsLandOnly","type":"bool","map":""},{"name":"Val1","type":"float","map":"PremQualData&gt;0&gt;value"},{"name":"Occ1","type":"float","map":"PremQualData&gt;0&gt;occupancy"},{"name":"Val5","type":"float","map":"PremQualData&gt;1&gt;value"},{"name":"Occ5","type":"float","map":"PremQualData&gt;1&gt;occupancy"},{"name":"OAR","type":"float","map":""},{"name":"MAGIM","type":"float","map":""},{"name":"EffValPerIdx","type":"float","map":""},{"name":"IAStabilizedVal","type":"float","map":""},{"name":"IAPerIdx","type":"float","map":""},{"name":"IAOAR","type":"float","map":""},{"name":"IANOI","type":"float","map":""},{"name":"IAExpenseRatio","type":"float","map":""},{"name":"MAStabilizedVal","type":"float","map":""},{"name":"MAValPerIdx","type":"float","map":""},{"name":"DiscountRate","type":"int","map":""}]
var mainData = [{"PropertyStatusID":1,"PropertyTypeMajor":"Assembly/Meeting Place","PropertyTypeSub":"Convention Center","PropertyType":"Assembly/Meeting Place - Convention Center","PropertyTypeDesc":"","JobID":1637,"TaskID":0,"City":"Spindleville","ST":"MA","Retechsno":"12-000116","JobSequence":"01","FileNumber":"","ProjectID":971,"TaskCode":"APR_REV","Obligor":"","LoanNumber":"TBD","BorrowersName":"Charlie Grey","EffDOV":"/Date(1347465600000)/","PropertySize":"","PropUnit":"SF","PropertySize2":"","PropUnit2":".","LandSize":"3.00","LandSizeUnit":"Acres","OAR":"","MAGIM":"","EffValPerIdx":68.87052341597796,"IAStabilizedVal":"","IAPerIdx":"","IAOAR":"","IANOI":"","IAExpenseRatio":"","MAStabilizedVal":"","MAValPerIdx":"","DiscountRate":"","YearBuilt":2005,"PendingSaleAmt":null,"Address1":"1666 Convention Center Drive","ZipCode":"01747","MapNumber":"","NumElevators":"Null","isLandOnly":true,"PremQualData":[{"id":1,"value":"","occupancy":""},{"id":5,"value":"","occupancy":""}]},{"PropertyStatusID":1,"PropertyTypeMajor":"Health Care","PropertyTypeSub":"Acute Care Hospital","PropertyType":"Health Care - Acute Care Hospital","PropertyTypeDesc":"","JobID":182,"TaskID":0,"City":"Boston","ST":"MA","Retechsno":"05-000031","JobSequence":"01","FileNumber":"","ProjectID":116,"TaskCode":"APR_REV","Obligor":"","LoanNumber":"TBD","BorrowersName":"Kenya Community Church","EffDOV":null,"PropertySize":"82","PropUnit":"Beds","PropertySize2":"46000","PropUnit2":"SF","LandSize":"12.45","LandSizeUnit":"Acres","OAR":"","MAGIM":"","EffValPerIdx":null,"IAStabilizedVal":"","IAPerIdx":"","IAOAR":"","IANOI":"","IAExpenseRatio":"","MAStabilizedVal":"","MAValPerIdx":"","DiscountRate":"","YearBuilt":2001,"PendingSaleAmt":null,"Address1":"1 Broadway","ZipCode":"02101","MapNumber":"","NumElevators":"Null","isLandOnly":false,"PremQualData":[{"id":1,"value":"","occupancy":""},{"id":5,"value":"","occupancy":""}]},{"PropertyStatusID":1,"PropertyTypeMajor":"Multi-Family","PropertyTypeSub":"Garden/Low-Rise","PropertyType":"Multi-Family - Garden/Low-Rise","PropertyTypeDesc":"","JobID":179,"TaskID":0,"City":"Boston","ST":"MA","Retechsno":"05-000028","JobSequence":"01","FileNumber":"","ProjectID":115,"TaskCode":"","Obligor":"","LoanNumber":"TBD","BorrowersName":"Ed Smith","EffDOV":null,"PropertySize":"35","PropUnit":"Units","PropertySize2":"24000","PropUnit2":"SF","LandSize":"0.75","LandSizeUnit":"Acres","OAR":"","MAGIM":"","EffValPerIdx":null,"IAStabilizedVal":"","IAPerIdx":"","IAOAR":"","IANOI":"","IAExpenseRatio":"","MAStabilizedVal":"","MAValPerIdx":"","DiscountRate":"","YearBuilt":1985,"PendingSaleAmt":null,"Address1":"1400 El Camino","ZipCode":"02101","MapNumber":"","NumElevators":"Null","isLandOnly":false,"PremQualData":[{"id":1,"value":"","occupancy":""},{"id":5,"value":"","occupancy":""}]},{"PropertyStatusID":1,"PropertyTypeMajor":"Multi-Family","PropertyTypeSub":"Garden/Low-Rise","PropertyType":"Multi-Family - Garden/Low-Rise","PropertyTypeDesc":"","JobID":181,"TaskID":0,"City":"Boston","ST":"MA","Retechsno":"05-000030","JobSequence":"01","FileNumber":"","ProjectID":117,"TaskCode":"","Obligor":"","LoanNumber":"TBD","BorrowersName":"Jones","EffDOV":null,"PropertySize":"35","PropUnit":"Units","PropertySize2":"24000","PropUnit2":"SF","LandSize":"5.00","LandSizeUnit":"Acres","OAR":"","MAGIM":"","EffValPerIdx":null,"IAStabilizedVal":"","IAPerIdx":"","IAOAR":"","IANOI":"","IAExpenseRatio":"","MAStabilizedVal":"","MAValPerIdx":"","DiscountRate":"","YearBuilt":2000,"PendingSaleAmt":null,"Address1":"4444 Downtown","ZipCode":"02101","MapNumber":"","NumElevators":"Null","isLandOnly":false,"PremQualData":[{"id":1,"value":"","occupancy":""},{"id":5,"value":"","occupancy":""}]},{"PropertyStatusID":1,"PropertyTypeMajor":"Multi-Family","PropertyTypeSub":"Garden/Low-Rise","PropertyType":"Multi-Family - Garden/Low-Rise","PropertyTypeDesc":"","JobID":183,"TaskID":0,"City":"Boston","ST":"MA","Retechsno":"05-000032","JobSequence":"01","FileNumber":"","ProjectID":120,"TaskCode":"","Obligor":"","LoanNumber":"TBD","BorrowersName":" Smythe Ent., LLC","EffDOV":null,"PropertySize":"1","PropUnit":"Units","PropertySize2":"","PropUnit2":"SF","LandSize":"1.00","LandSizeUnit":"Acres","OAR":"","MAGIM":"","EffValPerIdx":null,"IAStabilizedVal":"","IAPerIdx":"","IAOAR":"","IANOI":"","IAExpenseRatio":"","MAStabilizedVal":"","MAValPerIdx":"","DiscountRate":"","YearBuilt":1999,"PendingSaleAmt":null,"Address1":"56464","ZipCode":"02101","MapNumber":"","NumElevators":"Null","isLandOnly":false,"PremQualData":[{"id":1,"value":"","occupancy":""},{"id":5,"value":"","occupancy":""}]},{"PropertyStatusID":1,"PropertyTypeMajor":"Multi-Family","PropertyTypeSub":"Garden/Low-Rise","PropertyType":"Multi-Family - Garden/Low-Rise","PropertyTypeDesc":"","JobID":184,"TaskID":0,"City":"Boston","ST":"MA","Retechsno":"05-000033","JobSequence":"01","FileNumber":"","ProjectID":118,"TaskCode":"","Obligor":"","LoanNumber":"TBD","BorrowersName":"Deflaun","EffDOV":null,"PropertySize":"35","PropUnit":"Units","PropertySize2":"24000","PropUnit2":"SF","LandSize":"0.75","LandSizeUnit":"Acres","OAR":"","MAGIM":"","EffValPerIdx":null,"IAStabilizedVal":"","IAPerIdx":"","IAOAR":"","IANOI":"","IAExpenseRatio":"","MAStabilizedVal":"","MAValPerIdx":"","DiscountRate":"","YearBuilt":1900,"PendingSaleAmt":null,"Address1":"1324","ZipCode":"02101","MapNumber":"","NumElevators":"Null","isLandOnly":false,"PremQualData":[{"id":1,"value":"","occupancy":""},{"id":5,"value":"","occupancy":""}]},{"PropertyStatusID":1,"PropertyTypeMajor":"Residential","PropertyTypeSub":"Attached","PropertyType":"Residential - Attached","PropertyTypeDesc":"","JobID":988,"TaskID":0,"City":"Springfield","ST":"MA","Retechsno":"10-000086","JobSequence":"01","FileNumber":"","ProjectID":657,"TaskCode":"","Obligor":"","LoanNumber":"TBD","BorrowersName":"Bob &amp; Martha Smithfield","EffDOV":null,"PropertySize":"2200","PropUnit":"SF","PropertySize2":"","PropUnit2":"SF","LandSize":"0.58","LandSizeUnit":"Acres","OAR":"","MAGIM":"","EffValPerIdx":null,"IAStabilizedVal":"","IAPerIdx":"","IAOAR":"","IANOI":"","IAExpenseRatio":"","MAStabilizedVal":"","MAValPerIdx":"","DiscountRate":"","YearBuilt":2000,"PendingSaleAmt":385000,"Address1":"123 First Street","ZipCode":"01129","MapNumber":"","NumElevators":"Null","isLandOnly":false,"PremQualData":[{"id":1,"value":"","occupancy":""},{"id":5,"value":"","occupancy":""}]},{"PropertyStatusID":1,"PropertyTypeMajor":"Residential","PropertyTypeSub":"Attached","PropertyType":"Residential - Attached","PropertyTypeDesc":"","JobID":990,"TaskID":0,"City":"Springfield","ST":"MA","Retechsno":"10-000086","JobSequence":"03","FileNumber":"","ProjectID":657,"TaskCode":"","Obligor":"","LoanNumber":"TBD","BorrowersName":"Bob &amp; Martha Smithfield","EffDOV":null,"PropertySize":"2200","PropUnit":"SF","PropertySize2":"","PropUnit2":"SF","LandSize":"0.58","LandSizeUnit":"Acres","OAR":"","MAGIM":"","EffValPerIdx":null,"IAStabilizedVal":"","IAPerIdx":"","IAOAR":"","IANOI":"","IAExpenseRatio":"","MAStabilizedVal":"","MAValPerIdx":"","DiscountRate":"","YearBuilt":2000,"PendingSaleAmt":385000,"Address1":"123 First Street","ZipCode":"01129","MapNumber":"","NumElevators":"Null","isLandOnly":false,"PremQualData":[{"id":1,"value":"","occupancy":""},{"id":5,"value":"","occupancy":""}]},{"PropertyStatusID":1,"PropertyTypeMajor":"Retail-Commercial","PropertyTypeSub":"Car Wash-Full Service","PropertyType":"Retail-Commercial - Car Wash-Full Service","PropertyTypeDesc":"","JobID":1393,"TaskID":0,"City":"Boston","ST":"MA","Retechsno":"12-000021","JobSequence":"02","FileNumber":"","ProjectID":860,"TaskCode":"APR_REV","Obligor":"","LoanNumber":"TBD","BorrowersName":"Larry Bird","EffDOV":"/Date(1330444800000)/","PropertySize":"20000","PropUnit":"SF","PropertySize2":"","PropUnit2":".","LandSize":"0.50","LandSizeUnit":"Acres","OAR":"","MAGIM":"","EffValPerIdx":22.5,"IAStabilizedVal":"","IAPerIdx":"","IAOAR":"","IANOI":"","IAExpenseRatio":"","MAStabilizedVal":"","MAValPerIdx":"","DiscountRate":"","YearBuilt":1999,"PendingSaleAmt":null,"Address1":"90 Southhampton St.","ZipCode":"02118","MapNumber":"","NumElevators":"Null","isLandOnly":false,"PremQualData":[{"id":1,"value":"450000","occupancy":""},{"id":5,"value":"","occupancy":""}]},{"PropertyStatusID":1,"PropertyTypeMajor":"Retail-Commercial","PropertyTypeSub":"Free Standing Building-Bank Branch","PropertyType":"Retail-Commercial - Free Standing Building-Bank Branch","PropertyTypeDesc":"","JobID":1625,"TaskID":0,"City":"Lowell","ST":"MA","Retechsno":"12-000109","JobSequence":"01","FileNumber":"","ProjectID":963,"TaskCode":"","Obligor":"","LoanNumber":"TBD","BorrowersName":"Betty Borrower","EffDOV":null,"PropertySize":"10000","PropUnit":"SF","PropertySize2":"","PropUnit2":".","LandSize":"1.00","LandSizeUnit":"Acres","OAR":"","MAGIM":"","EffValPerIdx":null,"IAStabilizedVal":"","IAPerIdx":"","IAOAR":"","IANOI":"","IAExpenseRatio":"","MAStabilizedVal":"","MAValPerIdx":"","DiscountRate":"","YearBuilt":1999,"PendingSaleAmt":null,"Address1":"222 Merrimack St","ZipCode":"01852","MapNumber":"","NumElevators":"Null","isLandOnly":false,"PremQualData":[{"id":1,"value":"","occupancy":""},{"id":5,"value":"","occupancy":""}]},{"PropertyStatusID":1,"PropertyTypeMajor":"Retail-Commercial","PropertyTypeSub":"Free Standing Building-Bank Branch","PropertyType":"Retail-Commercial - Free Standing Building-Bank Branch","PropertyTypeDesc":"","JobID":1736,"TaskID":0,"City":"Brookline","ST":"MA","Retechsno":"13-000021","JobSequence":"01","FileNumber":"","ProjectID":1034,"TaskCode":"","Obligor":"","LoanNumber":"TBD","BorrowersName":"sherry","EffDOV":null,"PropertySize":"20000","PropUnit":"SF","PropertySize2":"","PropUnit2":".","LandSize":"2.00","LandSizeUnit":"Acres","OAR":"","MAGIM":"","EffValPerIdx":null,"IAStabilizedVal":"","IAPerIdx":"","IAOAR":"","IANOI":"","IAExpenseRatio":"","MAStabilizedVal":"","MAValPerIdx":"","DiscountRate":"","YearBuilt":1999,"PendingSaleAmt":null,"Address1":"1115 mainland way","ZipCode":"02446","MapNumber":"","NumElevators":"Null","isLandOnly":false,"PremQualData":[{"id":1,"value":"","occupancy":""},{"id":5,"value":"","occupancy":""}]},{"PropertyStatusID":1,"PropertyTypeMajor":"Retail-Commercial","PropertyTypeSub":"Free Standing Building-Big Box","PropertyType":"Retail-Commercial - Free Standing Building-Big Box","PropertyTypeDesc":"","JobID":1765,"TaskID":0,"City":"Worcester","ST":"MA","Retechsno":"13-000041","JobSequence":"02","FileNumber":"","ProjectID":1054,"TaskCode":"APR_REV","Obligor":"","LoanNumber":"TBD","BorrowersName":"Cowing","EffDOV":"/Date(1368460800000)/","PropertySize":"","PropUnit":"SF","PropertySize2":"","PropUnit2":".","LandSize":"2.00","LandSizeUnit":"Acres","OAR":"","MAGIM":"","EffValPerIdx":null,"IAStabilizedVal":"","IAPerIdx":"","IAOAR":"","IANOI":"","IAExpenseRatio":"100","MAStabilizedVal":"","MAValPerIdx":"","DiscountRate":"","YearBuilt":1999,"PendingSaleAmt":null,"Address1":"9191 Millstone","ZipCode":"01654","MapNumber":"","NumElevators":"Null","isLandOnly":true,"PremQualData":[{"id":1,"value":"","occupancy":"100"},{"id":5,"value":"","occupancy":""}]},{"PropertyStatusID":1,"PropertyTypeMajor":"Retail-Commercial","PropertyTypeSub":"Free Standing Building-Department Store","PropertyType":"Retail-Commercial - Free Standing Building-Department Store","PropertyTypeDesc":"","JobID":1735,"TaskID":0,"City":"Harwich Port","ST":"MA","Retechsno":"13-000020","JobSequence":"01","FileNumber":"","ProjectID":1033,"TaskCode":"","Obligor":"","LoanNumber":"TBD","BorrowersName":"Crowing","EffDOV":null,"PropertySize":"14000","PropUnit":"SF","PropertySize2":"","PropUnit2":".","LandSize":"2.00","LandSizeUnit":"Acres","OAR":"","MAGIM":"","EffValPerIdx":null,"IAStabilizedVal":"","IAPerIdx":"","IAOAR":"","IANOI":"","IAExpenseRatio":"","MAStabilizedVal":"","MAValPerIdx":"","DiscountRate":"","YearBuilt":2005,"PendingSaleAmt":null,"Address1":"5678 Main st","ZipCode":"02646","MapNumber":"","NumElevators":"Null","isLandOnly":false,"PremQualData":[{"id":1,"value":"","occupancy":""},{"id":5,"value":"","occupancy":""}]},{"PropertyStatusID":1,"PropertyTypeMajor":"Retail-Commercial","PropertyTypeSub":"Other","PropertyType":"Retail-Commercial - Other","PropertyTypeDesc":"","JobID":1676,"TaskID":0,"City":"Needham","ST":"MA","Retechsno":"12-000140","JobSequence":"01","FileNumber":"","ProjectID":999,"TaskCode":"APR_REV","Obligor":"","LoanNumber":"TBD","BorrowersName":"Spaniel","EffDOV":"/Date(1352908800000)/","PropertySize":"10000","PropUnit":"SF","PropertySize2":"","PropUnit2":".","LandSize":"1.00","LandSizeUnit":"Acres","OAR":"","MAGIM":"2.5","EffValPerIdx":50,"IAStabilizedVal":"","IAPerIdx":"","IAOAR":"","IANOI":"","IAExpenseRatio":"100","MAStabilizedVal":"","MAValPerIdx":"","DiscountRate":"","YearBuilt":1999,"PendingSaleAmt":null,"Address1":"1450 Parkway Lane","ZipCode":"02492","MapNumber":"","NumElevators":"Null","isLandOnly":false,"PremQualData":[{"id":1,"value":"500000","occupancy":"100"},{"id":5,"value":"","occupancy":""}]}]
        var request = {
            datatype: "json",
            datafields: jsonDatafields,
            localdata: mainData
        };
        
        var dataAdapter = new $.jqx.dataAdapter(request);
        $("#grid").jqxGrid(
            {
                width: '100%',
                height: '100%',
                source: dataAdapter,
                theme: exactbid.rims.jqxWidgets.theme,
                selectionmode: 'checkbox',
                sortable: true,
                altrows: true,
                columnsresize: true,
                columnsreorder: true,
                groupable: true,
                groupsexpandedbydefault: true,
                filterable: true,
                columns: jsonColumns,
                ready: function () {
                    $("#grid").jqxGrid('autoresizecolumns');
                },
                showgroupsheader: true
            });