Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1833
Recursive bound dataset - Missing levels
posted

I've another issue with this tree, unfortunately
I 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 ProjectID
3) Mid level projects - Recursive self referencing - Also has a FK to the root level table
4) Mid level / leaf level sub-tasks table - has a FK to Mid level projects table on ProjectID

I 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.zip

The 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
    *Admin

But what I get is: -

*01 - Test Additional Props
  *Projects (band)
    *lvl1
      *Projects (band)
        *lvl2
        *lvl2b
      *Tasks (band)
  *Tasks (band)
    *Accounts
    *Admin

As you can see this is missing everything from level 2 down. Any reason for this?

Thanks for any help in advance!

Parents Reply Children
No Data