Wednesday, 15 June 2011

javascript - Selectively extract data from multi-level JSON object -



javascript - Selectively extract data from multi-level JSON object -

i have multi-level json object contains array of 143 other objects.

running console.log(obj) on object displays:

0: object actftes: 0.00 actual: 11111 bud_month: "october" fy_cd: 2013 mission_name: "rst" __proto__: object 1: object actftes: 0.00 actual: 10000 bud_month: "fy total" fy_cd: 2013 mission_name: "rst"

etc.... through 143 objects. however, name/value pair mission_name:"rst" prevalent in first n objects.

for example, obj 43 contains:

43: object actftes: 0.00 actual: 10000 bud_month: "fy total" fy_cd: 2013 mission_name: "vao"

i have created next function, still returns total range of 143 values name/value pair related "bud_month".

function get_dataarray() { var arr = []; var i= 0; (i=0;i<jsonobj.row.length;i++) { if (jsonobj.row[i][name]="rst") { arr[i] = jsonobj.row[i]["bud_month"]; } } console.log(arr); homecoming arr; }

this returns:

["october", "fy total", "december", "january", "february", "march", "april", "may", "june", "july", "august", "september", "fy total", "october", "november", "december", "january", "february", "march", "april", "may", "june", "july", "august", "september", "november", "october", "november", "december", "january", "february", "march", "april", "may", "june", "july", "august", "september", "fy total", "october", "fy total", "december", "january", "february", "march", "april", "may", "june", "july", "august", "september", "fy total", "october", "november", "december", "january", "february", "march", "april", "may", "june", "july", "august", "september", "november", "october", "fy total", "december", "january", "february", "march", "april", "may", "june", "july", "august", "september", "fy total", "october", "november", "december", "january", "february", "march", "april", "may", "june", "july", "august", "september", "november", "october", "fy total", "december", "january", "february", "march", "april", "may", "june"…]

does have advice how homecoming value "bud_month" in objects containing name/value pair of mission_name:"rst" ?

if (jsonobj.row[i][name]="hst") { arr[i] = jsonobj.row[i]["bud_month"]; }

should be:

if (jsonobj.row[i][name]=="rst") { arr[i] = jsonobj.row[i]["bud_month"]; }

javascript json if-statement loops

No comments:

Post a Comment