Print Page - [SOLVED] Treegrid from JSON

Title: [SOLVED] Treegrid from JSON
Post by: Pierre on November 08, 2018, 06:07:17 AM

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

Title: Re: Treegrid from JSON
Post by: stworthy on November 08, 2018, 11:44:14 PM

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;
	}
})

Title: Re: Treegrid from JSON
Post by: Pierre on November 09, 2018, 12:06:37 AM

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.

Title: Re: Treegrid from JSON
Post by: stworthy on November 09, 2018, 01:10:28 AM

It works fine.

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

Title: Re: Treegrid from JSON
Post by: Pierre on November 09, 2018, 01:21:30 AM

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

EasyUI Forum

General Category => EasyUI for jQuery => Topic started by: Pierre on November 08, 2018, 06:07:17 AM