I inherited a legacy sql server table (that I cannot change) that looks like table below.
LVL is the unlimited levels within the tree (1-??), and within each
level, there are unlimited parents and their unlimited children.
I use remoteObject to pull in the query result as a flatDP.
I want to feed this dynamic data to a Tree component or AdvancedDataGrid
tree.
Can't get me head around how to deal with the unlimited number of levels
and how to convert the flatDP to a hierarchicalDP in Actionscript. Can
anyone help?
Thanks!
Don
I want the "NAME" to be what is visible in the tree at each node. (this
is the team name )
lvl1
parent
team
lvl2
parent
team
lvl3
parent
team
parent
team
lvl1
parent
team
lvl1
parent
team
lvl2
parent
team
lvl3
parent
team
parent
team
query LVL NAME PARENTID
TEAMID 1 1
CxP_SRR null 251 2
2 CxP_SRR_Board 251 252
3 3 CxP_SRR_PRE_Board 252
253 4 4 CxP_SRR_C3I
253 260 5 4
CxP_SRR_IM 253 257 6
4 CxP_SRR_MS 253 254
7 4 CxP_SRR_OTHER 253
262 8 4 CxP_SRR_PP&C
253 259 9 4
CxP_SRR_PTI 253 256 10
4 CxP_SRR_RQMT 253 255
11 4 CxP_SRR_SR&QA 253
258 12 4 CxP_SRR_T&V
253 261 13 1
ESMD null 5 14
2 Admin 5 12
15 2 Adv_Cap 5 7
16 2 CE 5 8
17 2 CMD 5 11
18 2 CX 5 1
19 3 AdvProj 1 28
20 3 ARES 1 15
21 4 ARES_Eng_Support 15
424 22 4 ARES_FITO
15 54 23 5
ARES_FITO_Avionics_Intg 54 407
24 5 ARES_FITO_Flt_Test_Intg 54
411 25 5
ARES_FITO_GVT 54 55 26
5 ARES_FITO_Orion_I 54 406
27 5 ARES_FITO_Propulsion_Test_Intg
54 410 28 5
ARES_FITO_SEVT 54 409 29
5 ARES_FITO_Veh_Sys_Assembly_Test 54
408 30 4 ARES_I
15 56 31 5
ARES_I_US 56 57 32
6 ARES_I_LIS 57 144
33 6 ARES_I_M_A 57 145
34 6 ARES_I_MPS 57 137
35 6 ARES_I_US_Avio 57
141 36 6
ARES_I_US_RCS 57 139 37
6 ARES_I_US_SEI 57 422
38 6 ARES_I_US_Struct_Therm 57
136 39 6
ARES_I_US_Test 57 143 40
6 ARES_I_US_TVC 57 140
41 6 ARES_US_Sm_Solids 57
423 42 5 ARES_I_USE
56 104 43 4
ARES_I_FS 15 106 44
5 ARES_I_FS_Avio_Ctrl 106 125
45 6 ARES_I_FS_Avio 125
428 46 6
ARES_I_FS_Ctrl 125 429 47
5 ARES_I_FS_Flt_Test 106 132
48 5 ARES_I_FS_RSRM_V 106
126 49 6
ARES_I_FS_Balli 126 420
50 6 ARES_I_FS_Insul 126
417
