# Any progress on the DBTreeView Bean? **URL:** \ **Category:** Classic Servoy\ **Created:** [October 19, 2005, 4:57pm UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918 "2005-10-19T16:57:22Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![JerryR](https://avatars.discourse-cdn.com/v4/letter/j/ad7895/32.png) [@JerryR](https://forum.servoy.com/u/JerryR)\ **Post date:** [October 19, 2005, 4:57pm UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/1 "2005-10-19T16:57:22Z")
Still _really_ need ability to select nodes, expand/collapse tree, etc. programatically. Any movement in that direction? Also, given that the order of sub-nodes in the tree is determined by the node\_id to parent\_id relationship, does anybody know of a way to change the sort order of the sub-nodes without resetting all the primary key values for the tree table? ---
**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\ **Post date:** [October 20, 2005, 1:23pm UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/2 "2005-10-20T13:23:12Z")
> Still _really_ need ability to select nodes, expand/collapse tree, etc. programatically. Any movement in that direction? Oh yes, count me in for that one! Also, if I want to add or remove a node, the whole tree collapse! ![:x]( "Mad") ---
**Author:** ![hpmxxx](https://avatars.discourse-cdn.com/v4/letter/h/ec9cab/32.png) [@hpmxxx](https://forum.servoy.com/u/hpmxxx)\ **Post date:** [October 21, 2005, 8:30am UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/3 "2005-10-21T08:30:18Z")
> Still _really_ need ability to select nodes, expand/collapse tree, etc. programatically. Count me in for that one too. Also a cool feature would be drag and drop support. Gruss Hans-Peter ---
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [October 21, 2005, 8:47am UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/4 "2005-10-21T08:47:32Z")
Me too ![:lol:]( "Laughing") And please don’t show a checkbox if there is no sub-entries. Right now you have to open all nodes to see where there is relevant information underneath… ---
**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\ **Post date:** [October 21, 2005, 3:47pm UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/5 "2005-10-21T15:47:20Z")
Me three! ![:lol:]( "Laughing") Or give us a faster (bundled) HTML render engine that also can use DHTML (thus javascript support INSIDE the HTML) and we can make really use of the HTMLtree module I made. (and I could make it faster by using the DHTML support, which we don’t have right now) See [http://forum.servoy.com/viewtopic.php?t=3847](http://forum.servoy.com/viewtopic.php?t=3847) ---
**Author:** ![Rene](https://avatars.discourse-cdn.com/v4/letter/r/7cd45c/32.png) [@Rene](https://forum.servoy.com/u/Rene)\ **Post date:** [October 29, 2005, 12:56pm UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/6 "2005-10-29T12:56:08Z")
O, yeah (I believe we are at four) With (sorted) foundset support A context menu is also a desired gadget for adding, deleting or whatever action/method. For the sorting question this is what I do I now have two PK`s. One is used by the Bean the other is the actual PK (used in the relation). When I want to sort them, I have to sort, then loop through all the records adding Bean PK + 1.000.000, and finally loop throug it again setting the Bean PK in a nice sequene. And then … The tree collapses. Very irratating and time consuming (I feel this is a FMP way. brrr…). It is a great feature with a lot of potential but it just doesn`t have the X factor. It is simply not “really” usable. I just hope it makes it to become a Open source project soon. > **[DBTreeView Source](https://forum.servoy.com/viewtopic.php?t=4048&highlight=treeview)** > > Any chance you would consider sharing the source of the DBTreeView bean? Rene ---
**Author:** ![Karel\_Broer](https://avatars.discourse-cdn.com/v4/letter/k/bcef8e/32.png) [@Karel\_Broer](https://forum.servoy.com/u/Karel_Broer)\ **Post date:** [April 26, 2006, 5:09pm UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/7 "2006-04-26T17:09:41Z")
Count me in for this feature, too! ---
**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\ **Post date:** [April 26, 2006, 7:13pm UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/8 "2006-04-26T19:13:57Z")
Just so I get an idea about the urgency of this dbtreeview enhancements. Do you need this because you think it’s cool? Or to quote one of our sales guys: how many extra Servoy licenses will you sell after getting this feature? ps. Have you all had a look at the tree bean in 3b2? It contains already some of the questions listed here. ---
**Author:** ![Karel\_Broer](https://avatars.discourse-cdn.com/v4/letter/k/bcef8e/32.png) [@Karel\_Broer](https://forum.servoy.com/u/Karel_Broer)\ **Post date:** [April 26, 2006, 7:31pm UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/9 "2006-04-26T19:31:32Z")
> jaleman: > Just so I get an idea about the urgency of this dbtreeview enhancements. Do you need this because you think it’s cool? The results would be cool indeed! ![:)]( "Smile") > Or to quote one of our sales guys: how many extra Servoy licenses will you sell after getting this feature? I need it allready for a few customers who want to have this HTML Tree functionality. > ps. Have you all had a look at the tree bean in 3b2? It contains already some of the questions listed here. No, I didn’t, but can we use this bean also in Servoy 2.2.4.? ---
**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\ **Post date:** [April 26, 2006, 9:15pm UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/10 "2006-04-26T21:15:01Z")
I agree with Karel, the dbtreeview is really a nice bean, but misses some key features, (like sorting and some others) what is preventing us from using it a lot in Servoy. More licenses? I don’t think we sell more licenses by such a feature, but it would indeed finish the bean and make it more usable. ---
**Author:** ![Rene](https://avatars.discourse-cdn.com/v4/letter/r/7cd45c/32.png) [@Rene](https://forum.servoy.com/u/Rene)\ **Post date:** [May 4, 2006, 7:22pm UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/11 "2006-05-04T19:22:46Z")
Hello > or do you need this because you think it’s cool? Excuse me saying this but in case you have forgotten. **Servoy is supposed to be cool[/b]** **Rene** ---
**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\ **Post date:** [May 4, 2006, 7:34pm UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/12 "2006-05-04T19:34:41Z")
> Rene: > Hello > > > or do you need this because you think it’s cool? > > Excuse me saying this but in case you have forgotten. > > **Servoy is supposed to be cool[/b]** > **Rene[/quote]** > **It get’s even better: Servoy IS cool.** ---
**Author:** ![Robert\_Huber](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@Robert\_Huber](https://forum.servoy.com/u/Robert_Huber)\ **Post date:** [May 29, 2006, 9:15am UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/13 "2006-05-29T09:15:34Z")
Hi All Sorry not to sing the hype song, but instead of this and that IS cool I would prefer if things work instead of loosing a lot of time if something is not working (I do though agree that I am aware of using a Beta version, i. e. 3B3). In my opinion, for a tool Servoy wants to be it’s not extraorinary that a functionality as offered by the DBTreeView exists, is it? To make a real world application such functionality is (for quite a lot of applications) needed. I found several problems using this bean (in above mentioned Servoy developer version): - The name property is not displayed and if one enters a name, it’s not taken by the bean - I am also not able to set no border as in the BookStudy example, the bean is always embossed (but I need it without borders) - I can’t set a background color - There are still triangle on the leaf level, where they should not be, only when I click the triangle (on the leaf level) the triangle disappears and the (correct) file icon appears (see appended picture) Best regards, Robert PS: I also would like to have some docu about the properties and the bean in general (I can click many of the bean properties without having any effect, or at least I can’t find out what the effect is). I know there is the docu on Sun’s side, but what is valid of that within Servoy? > jaleman: > > > Rene: > > Hello > > > > > or do you need this because you think it’s cool? > > > > Excuse me saying this but in case you have forgotten. > > > > **Servoy is supposed to be cool[/b]** > > **Rene[/quote]** > > **It get’s even better: Servoy IS cool.[/quote]** ![Picture 8.png](https://canada1.discourse-cdn.com/flex010/uploads/servoy/original/2X/3/39d9e2c9a9eba7cd10b660112ee4bb4cc9a98c8c.png) ---
**Author:** ![Robert\_Huber](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@Robert\_Huber](https://forum.servoy.com/u/Robert_Huber)\ **Post date:** [May 29, 2006, 9:18am UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/14 "2006-05-29T09:18:52Z")
Hi Jan Please see my later post. I think this bean is very welcome to have (actually a need for many applications), I think it just doesn’t work that well (or for some properties at all) in Servoy developer 3.0B3. Best regards, Robert > jaleman: > Just so I get an idea about the urgency of this dbtreeview enhancements. Do you need this because you think it’s cool? Or to quote one of our sales guys: how many extra Servoy licenses will you sell after getting this feature? > > ps. Have you all had a look at the tree bean in 3b2? It contains already some of the questions listed here. ---
**Author:** ![Robert\_Huber](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@Robert\_Huber](https://forum.servoy.com/u/Robert_Huber)\ **Post date:** [May 29, 2006, 9:23am UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/15 "2006-05-29T09:23:16Z")
Hi Harjo? (Is that your name?) You can sort the data in your table (like with an attribute sortOrder, i. e. column sort\_order) as you wish to display it, because the bean is displaying the data the same way as it is sorted in the table. May be that helps for the sort issue. Of course it would be much better to be able to define it on the bean level. Best regards, Robert > HJK: > I agree with Karel, > > the dbtreeview is really a nice bean, but misses some key features, (like sorting and some others) what is preventing us from using it a lot in Servoy. > > More licenses? I don’t think we sell more licenses by such a feature, but it would indeed finish the bean and make it more usable. ---
**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\ **Post date:** [May 29, 2006, 10:09am UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/16 "2006-05-29T10:09:32Z")
> Robert Huber: > Hi All > Sorry not to sing the hype song, but instead of this and that IS cool I would prefer if things work instead of loosing a lot of time if something is not working (I do though agree that I am aware of using a Beta version, i. e. 3B3). In my opinion, for a tool Servoy wants to be it’s not extraorinary that a functionality as offered by the DBTreeView exists, is it? To make a real world application such functionality is (for quite a lot of applications) needed. Hi Robert, I was referring to Servoy when I said it is cool, not to the free treeview bean. The bean has limited functionality and as I mentioned it can be extended. You can also build your own version in Java with any functionality desired: this would cost about the same effort as treeview elements offered in other environments so I don’t think your complaint is very fair. ---
**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\ **Post date:** [May 29, 2006, 10:49am UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/17 "2006-05-29T10:49:10Z")
> Robert Huber: > Hi Harjo? (Is that your name?) > > You can sort the data in your table (like with an attribute sortOrder, i. e. column sort\_order) as you wish to display it, because the bean is displaying the data the same way as it is sorted in the table. May be that helps for the sort issue. Of course it would be much better to be able to define it on the bean level. > > Best regards, Robert > > > HJK: > > I agree with Karel, > > > > the dbtreeview is really a nice bean, but misses some key features, (like sorting and some others) what is preventing us from using it a lot in Servoy. > > > > More licenses? I don’t think we sell more licenses by such a feature, but it would indeed finish the bean and make it more usable. HI Robert, yes I found that out, 2 weeks ago, thanks for the tip the issues you are mention, I don’t have them > The name property is not displayed and if one enters a name, it’s not taken by the bean You have to refresh the bean, before the bean sees the changes! > - I am also not able to set no border as in the BookStudy example, the bean is always embossed (but I need it without borders) you can do this in design-mode! > - I can’t set a background color how are you doing this? in design-mode or by method? > - There are still triangle on the leaf level, where they should not be, only when I click the triangle (on the leaf level) the triangle disappears and the (correct) file icon appears (see appended picture) You have to play with the setNodeVisible function. first open everything 5 levels deep for example en than close it. now the bean ‘knows’ the entries and levels. Hope this helps. ---
**Author:** ![Robert\_Huber](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@Robert\_Huber](https://forum.servoy.com/u/Robert_Huber)\ **Post date:** [May 29, 2006, 2:40pm UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/18 "2006-05-29T14:40:42Z")
Hi Jan I did not want to complain about the bean or to be unfair. But, as we are (at least most of us, I think), if something useful is there (and Servoy gave it to us), one would like to use it ![:-)]( "Smile") and I was just spending a lot of time finding out how these bean is intended to work (yes, I read the BookStudy example, but … ok, I don’t say anything). And it’s quite a bit of a problem with the Servoy documentation, I think. I also would immediatly buy a good book about Servoy, but as far as I know there is none. Please correct me if I’m wrong. I am just feeling that we, as developers, could speed up development quite a lot with more documentation and yes, I know from my daily work, it’s very hard (and time conuming) to create good docu. Best regards, Robert > jaleman: > > > Robert Huber: > > Hi All > > Sorry not to sing the hype song, but instead of this and that IS cool I would prefer if things work instead of loosing a lot of time if something is not working (I do though agree that I am aware of using a Beta version, i. e. 3B3). In my opinion, for a tool Servoy wants to be it’s not extraorinary that a functionality as offered by the DBTreeView exists, is it? To make a real world application such functionality is (for quite a lot of applications) needed. > > Hi Robert, > I was referring to Servoy when I said it is cool, not to the free treeview bean. The bean has limited functionality and as I mentioned it can be extended. You can also build your own version in Java with any functionality desired: this would cost about the same effort as treeview elements offered in other environments so I don’t think your complaint is very fair. ---
**Author:** ![Robert\_Huber](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@Robert\_Huber](https://forum.servoy.com/u/Robert_Huber)\ **Post date:** [May 29, 2006, 2:56pm UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/19 "2006-05-29T14:56:53Z")
Hi Harjo All my mentioned problem points are in design mode. You really can do all the points I mentioned in design mode? I can’t. For example: I can’t name the bean, so I had (for the moment, until it’s fixed), to use bean\_63 as name. If I enter a name, it’s lost as soon as I reopen the solution again and the name is never taken by the bean. In design mode, there is no bean refresh, is it? My config: Servoy Developer Version 3.0b3-build 364 Java version 1.5.0\_06-64 (Mac OS X) Best regards, Robert > HJK: > > > Robert Huber: > > Hi Harjo? (Is that your name?) > > > > You can sort the data in your table (like with an attribute sortOrder, i. e. column sort\_order) as you wish to display it, because the bean is displaying the data the same way as it is sorted in the table. May be that helps for the sort issue. Of course it would be much better to be able to define it on the bean level. > > > > Best regards, Robert > > > > > HJK: > > > I agree with Karel, > > > > > > the dbtreeview is really a nice bean, but misses some key features, (like sorting and some others) what is preventing us from using it a lot in Servoy. > > > > > > More licenses? I don’t think we sell more licenses by such a feature, but it would indeed finish the bean and make it more usable. > > HI Robert, > > yes I found that out, 2 weeks ago, thanks for the tip > > the issues you are mention, I don’t have them > > > The name property is not displayed and if one enters a name, it’s not taken by the bean > > You have to refresh the bean, before the bean sees the changes! > > > - I am also not able to set no border as in the BookStudy example, the bean is always embossed (but I need it without borders) > > you can do this in design-mode! > > > - I can’t set a background color > > how are you doing this? in design-mode or by method? > > > - There are still triangle on the leaf level, where they should not be, only when I click the triangle (on the leaf level) the triangle disappears and the (correct) file icon appears (see appended picture) > > You have to play with the setNodeVisible function. first open everything 5 levels deep for example en than close it. now the bean ‘knows’ the entries and levels. > > Hope this helps. ---
**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\ **Post date:** [May 29, 2006, 2:59pm UTC](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918/20 "2006-05-29T14:59:52Z")
ah oke, I’m using the dbtree-bean of Servoy 3.0b in Servoy 2.2.5 There it is no problem. I have not used it in Servoy 3.0 [Next page](https://forum.servoy.com/t/any-progress-on-the-dbtreeview-bean/4918.md?page=2)