(Sorry if this has already been covered elsewhere - I searched but I can't follow VB well...)
Due to a recent reorg, we now have two org charts: Org2020 and Org2019. Most, but not all of the base entities are the same, and of course some parents are different.
Once the close ends, we'd like the divisions to promote their part of both org charts to Level 4.
We're running into issues where they promote one org, but can't promote the other because of that "can't promote a parent entity higher than its child..." error.
One fix is to only promote the base entities - as the admin, that's my preference. It sure makes the inevitable demotion process easier.
But HQ prefers to promote everything, so I'm being asked to provide to each division a single grid with all descendants of both of their division orgs, i.e., Division1_2020[Descendants] and Division1_2019[Descendants]
Such a grid allows everything to be promoted in one step (it'll also make demotion easier). Unfortunately, I can't set up a grid that has, for rows, both:
Division1_2020[Descendants] and Division1_2019[Descendants] - the grid designer selection box won't allow both. So I'm thinking that an entity list might be the way to display the rows I need in the grid.
My question is what's the easiest way to add some entity lists that consist of the [Descendants] of two parents.
I was hoping to avoid a looping VB routine, such as the many examples shown in other discussions. Too bad it's not as simple as:
....Elseif HS.MemberListID = 3 Then
HS.AddMemberToList "Division1_2020[Descendants]"
HS.AddMemberToList "Division1_2019[Descendants]"
Elseif HS.MemberListID = 4 Then...
...but that doesn't work (I tried!). So I suppose I have to get fancier but I was not able to find an appropriate example in other discussions that I can adapt for my purposes.
Down the road, I'll probably need to also create an entity list consisting of all descendants of a single parent, as well, so if such an example could be included, that would also be appreciated.