I've another issue with this tree, unfortunatelyI have 4 tables in my bound dataset as follows: -1) Root level projects table - The data member 2) Root level sub-tasks - FK relation to root table on ProjectID3) Mid level projects - Recursive self referencing - Also has a FK to the root level table4) Mid level / leaf level sub-tasks table - has a FK to Mid level projects table on ProjectIDI have a number of ColumnSets to represent each relation. These do seem to be applied to their associated node levels.The issue now have is that it does not show all levels as expected. But it is obviously attempting to show the recursive table as I can see some nodes represented.I have a simple example of this issue available @ http://www.smartdata.co.uk/downloads/test_bind.zipThe dataset in the demo should create a tree structure as follows: -*01 - Test Additional Props *Projects (band) *lvl1 *Projects (band) *lvl2 *Projects (band) *lvl3 *Projects (band) lvl3 *Tasks (band) *Accounts *Admin *Tasks (band) *Accounts *Admin *lvl2b *Projects (band) *Tasks (band) *Accounts *Admin *Tasks (band) *Tasks (band) *Accounts *AdminBut what I get is: -*01 - Test Additional Props *Projects (band) *lvl1 *Projects (band) *lvl2 *lvl2b *Tasks (band) *Tasks (band) *Accounts *AdminAs you can see this is missing everything from level 2 down. Any reason for this?
Thanks for any help in advance!
You're a star! that was the issue exactly!
That was so frustrating, I would have been pluing my hair out, if I had any!
Thanks again Mike!
Ahhh, I did create some myself as it seemed to randomly choose which it would auto generate. I'll try that modification now. Thanks Mike!
Did you create the ColumnSets yourself? Or did the tree generate them for you automatically?
I took a quick look at your sample and your ColumnSet for the "MidLevelRecursive_Projects" band has no child bands defined. A child band is just a special type of column with IsChaptered set to true. Since your MidLevelRecursive_Projects ColumnSet includes no chaptered columns, it shows no child data.
This is somehow related to the defined column sets. I have not set any other properties apart from cell click action. A test confirmed (with fresh copy of the tree) that if I'm happy to have all the id columns shown, I get all the levels, otherwise I only get some levels. I.e no column sets = all levels and all data shownI can't use the pointers provided in a previous thread (http://community.infragistics.com/forums/p/30911/170561.aspx#170561) as this is more than just a self referencing data table. There are 2 kinds of tables Projects and tasks. So the idea of using tree.Override.ColumnSet along with tree.NodeLevelOverrride.0 isn't going to cut it, as this again hides some levels. I have configured the keys of the pre-defined column sets to match that of the relations in the bound dataset. This does work to hide columns but this seems to have the additional and unwanted effect of hiding levels.
Could this be a bug or is it something obvious that I've missed?
Any help would be much appreciated
Thanks in advance!