Any progress on the DBTreeView Bean?

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?

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

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

Me too :lol: 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…

Me three! :lol:

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

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.

Rene

Count me in for this feature, too!

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.

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! :)

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.?

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.

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

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.

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]

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.

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.

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.

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.

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 :-) 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.

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.

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