[SOLVED] Treegrid from JSON

[Pierre]

Hello
I have such JSON file:

Code:

{
	"Custom_1": {
		"AA": "Value1",
		"BB": "Value2"
	},
	"Material": {
		"CC": "Value3",
		"DD": "Value4",
		"EE": "Value5"
	},
	"Item": {
		"FF": "Value6",
		"GG": "Value7"
	}
}

is it possible to load such file into TreeGrid where "Custom_1", "Material" and "Item" are parents and "AA", "BB", "CC" (etc) are names and Value1, Value2 etc. are values?
Thank you

[stworthy]

Define the 'loadFilter' function to convert the source data.

Code:

$('#tg').treegrid({
	columns: [[
		{field:'name',title:'Name',width:200},
		{field:'value',title:'Value',width:100}
	]],
	data: data,
	idField: 'id',
	treeField: 'name',
	loadFilter: function(data){
		var index = 0;
		var rows = [];
		for(var name in data){
			var cc = data[name];
			var children = [];
			for(var cname in cc){
				children.push({
					id: index++,
					name: cname,
					value: cc[cname]
				})
			}
			rows.push({
				id: index++,
				name: name,
				children: children
			})
		}
		return rows;
	}
})

[Pierre]

Thank you so much for your help but it does not work on my side
I created example here:
http://code.reloado.com/ejojos/edit#source
What is wrong there, please?
Thank you.

[stworthy]

It works fine.

http://code.reloado.com/ejojos/2/edit#preview

[Pierre]

Awesome, just perfect solution. 
Thank you so much for your help.