Hi Chadg

I have experienced the same issue using a list method from a custom service broker. I created a smartbox table with the exact same data the list method was returning and used that as a datasource and it works fine. Change it to the custom broker list and I get similar issues to you.

It seems that the tree control doesn't like getting data from anything other than a Smartbox list method. I would raise this with K2 support.

I would suggest changing your SP to accept a parameter of "parentid" that has a default value such as:

REATE PROCEDURE dbo]..TreeSP]
@parentId INT = 0,

...

Then in your sql you should make sure that it uses that parameter

SELECT * FROM TreeViewTable WHERE parentId = @parentId

Then your related SmartObject List method would accept that optional parameter.

Lastly in your tree control you would have it pass in the parent ID on each level of the tree.  This should also increase performance as it is doing the filtering of the tree records on the server rather than on the K2 server.  Note, you may have to configure the passing of the Parent Id in the rules section and not in the properties of the control.  I experiences some "strange" behavior when I try to do too much reconfiguring with the tree control  So there definetly must be some bugs in there also .

@NathanBrown, 

I am attempting to use the solution you provided. I have ran into more errors attempting to pass parameters to the smartobject in the tree control. 

1) If I use the line @parentId INT = 0

The Smartobject does not a place for an input to be placed. 

instead I used Declare @ParentID INT

Which solved the that issue. 

2) When I attempted to Configure the Data Source in the tree control, I would enter data in the  Mapping Destination, but it would not save. 

Can you show me the rules in which you are  reffering to, "Note, you may have to configure the passing of the Parent Id in the rules section and not in the properties of the control."

Where can I pass that in the rules section?

Thanks for you help. 

Chad

Not sure if this will help (considering how old this thread is), but I've attached a mail thread for proposed solutions on how to configure the tree using sproc data sources.

we also struggled with this and managed to solve it. 

A few considerations. 

- All nodes should have a parentID. All root items should return 0

- The tree control expects to call data branch by branch (one level deep). For this the stored procedure should be able to return only the child nodes of a certain Parent ID,

- The tree control should be configured with 2 datasources (both refering to the same smart object). The first level data source is not recursive, the second  level data source should be recursive and should  refer to the first level as the parent (parentID = ID)

- Make sure you first do the configuration as mentioned here above, and then adjust the configuration of your datasource levels to add extra input parameters if your stored procedure requires more input. I experienced that changing the settings on parentID emptied these other configurations. 

Hope this helps. If you need any screenshots, let me know what you're struggling with. 

Any solution for this in K2 five ??