Forum
16:01
08/02/2010
Hi,
Am using JQGrid 4.1.2 version. In this am facing some problem in tree grid while using Adjacency model (Load at once). Am loading the JSON data from server. Tree grid is getting formed according to the row order from JSON data. Say for ex., Am forming tree grid for Branch & Department. In my query am not able to sort according to the parent child hierarchy. Because around 6 tables i need to join. But i can get the records with proper id, parent, level & is_leaf properties.
What grid is doing means – just its creating the rows from JSON whatever order it is. So the tree format is not coming up properly. When i click the root node of any department its collapsing the correct child but all children are under different parent(according to my JSON order).
Below is the data which am getting as a json from my server.
id name level parent is_leaf expanded loaded
—– —————– ——– ——— ———- ———– ——-
B1 Shanghai Pvt Ltd 1 (null) false true true
D3 Finance & Account 2 B1 true true true
D4 Production 2 B1 true true true
D5 Support 2 B1 true true true
D6 Operation 2 B1 false true true
D13 Software 2 B1 true true true
D82 BPO 2 B1 false true true
D76 Sub D12 3 D1 true true true
D75 Sub D11 3 D1 true true true
D78 Sub D21 3 D2 false true true
D84 Operation1 3 D6 true true true
D83 BPO1 3 D82 false true true
D79 Sub D211 4 D78 false true true
D87 BPO11 4 D83 true true true
D80 Sub D2111 5 D79 true true true
D1 Admin 2 B1 false true true
D2 Sales 2 B1 false true true
B13 Beijing Pvt Ltd 1 (null) false true true
D86 Test 2 2 B13 false true true
D134 Test Root 2 B13 true true true
D91 Test Level 1 3 D85 false true true
D93 Test 2 Level 1 3 D86 true true true
D133 Test Level 3 5 D92 true true true
D92 Test Level 2 4 D91 false true true
D85 Test 2 B13 false true true
B14 Branch Office 3 1 (null) false true true
D132 Software 2 B14 false true true
D95 Level 1 3 D132 true true true
D94 Root 2 B14 true true true
D136 Level 2 3 D132 true true true
B15 Branch Office 4 1 (null) true true true
Inside jqgrid function i've defined all these..
treeGrid: true,
treeGridModel:'adjacency',
ExpandColumn : 'deptName'
anything am i missing/doing wrong or this is how tree grid works right now??
Most Users Ever Online: 715
Currently Online:
45 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66