[rharding98Participant]

I’m not asking for anything custom I just don’t want null to be considered a zero in the built in aggregate. The jsfiddle I linked is ignoring the null which is what I want it to do.

[rharding98Participant]

Yeah but could you explain why this fiddle is ignoring the null on the price aggregates without a custom aggregation function?

http://jsfiddle.net/8BE5w/30/

Thanks,
Roy

[rharding98Participant]

Was an option to ignore null ever added?

[rharding98Participant]

UGH!! Yeah I should have based this jsfiddle more on my existing code. My problem is that the work I did 7 months ago is not working now when it use to. Having a hard time figuring out why it has stopped working. I will build an example closer to what I did before. Sorry for wasting your time.

[rharding98Participant]

Hi Peter,

I made some changes so it is closer to the JSON example you sent but it’s still not working. Could you please take a look at the jsfiddle again? I would really appreciated it.

http://jsfiddle.net/e6rX2/

Thanks,
Roy

[rharding98Participant]

I think there should at least be an option to have the aggregate functions ignore null. Null does not equal Zero.

[rharding98Participant]

Guess I will have to setup an example to show you as it happens every time for me.

[rharding98Participant]

Do you have an example of returning the selected rows?

http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/index.htm?(energyblue)#demos/jqxgrid/checkboxselection.htm

[rharding98Participant]

Thanks for that almost 5am here already guess my eyes are telling me I’m done for the night

[rharding98Participant]

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>0>value"},{"name":"Occ1","type":"float","map":"PremQualData>0>occupancy"},{"name":"Val5","type":"float","map":"PremQualData>1>value"},{"name":"Occ5","type":"float","map":"PremQualData>1>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 & 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 & 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
            });

[rharding98Participant]

Hope someone replies to the issue with showdefaultloadelement that is reproducible here http://jsfiddle.net/Tm4ct/15/ If it is on and you click the search twice the verticle scroll bar is pushed out of view and the default load element is displayed even though it is off. The grid also appears to be locked up.

Thanks,
Roy

[rharding98Participant]

“map”:”PremQualData>0>value” works

[rharding98Participant]

I will reply by item number

1. I would think that if the width is empty that it would be ignored.
2. OK. I will try setting the width for all columns and then call “autoresizecolumns” once it is initialized. I tried this already but without setting the widths and I had to click search twice for the grid to autosize.
3. OK
4. How can I get those quotes removed Any ideas? I have tried several way without success.
5. OK
6. BUG?

Thanks for the quick reply,
Roy

[rharding98Participant]

Thanks Peter but I just took a look at the mapping examples and am still a bit confused as to how I would map the following sub object?

"PremQualData":[{"id":1,"value":"","occupancy":""},{"id":5,"value":"","occupancy":""}]

[rharding98Participant]

me again

I also can’t figure out what to put as the datafield name for a nested json object. This is also in the jsfiddle above.

datafields:

{"name":"PremQualData[0].value","type":"float"},{"name":"PremQualData[0].occupancy","type":"float"},{"name":"PremQualData[1].value","type":"float"},{"name":"PremQualData[1].occupancy","type":"float"}

data snippet:

{"PropertyStatusID":1,"PropertyTypeMajor":"Agricultural","PropertyTypeSub":"Agribusiness-Aquaculture","PropertyType":"Agricultural - Agribusiness-Aquaculture","PropertyTypeDesc":"","JobID":214,"City":"Cincinnati","ST":"OH","Retechsno":"05-000050","JobSequence":"01","FileNumber":"","ProjectID":153,"TaskCode":"","Obligor":"","LoanNumber":"","BorrowersName":"Large Customer","EffDOV":null,"PropertySize":"20000","PropUnit":"SF-GBA","PropertySize2":"","PropUnit2":".","LandSize":"2.00","LandSizeUnit":"Acres","OAR":"","MAGIM":"","EffValPerIdx":null,"IAStabilizedVal":"","IAPerIdx":"","IAOAR":"","IANOI":"","IAExpenseRatio":"","MAStabilizedVal":"","MAValPerIdx":"","DiscountRate":"","YearBuilt":2002,"PendingSaleAmt":null,"Address1":"123 Main","ZipCode":"45205","MapNumber":"","NumElevators":"Null","PremQualData":[{"id":1,"value":"","occupancy":""},{"id":5,"value":"","occupancy":""}]}

[Author]

Posts