Any progress on the DBTreeView Bean?

Classic Servoy
21

I am currently fighting these same issues. I am unable to affect the dbtreeview bean’s name and I am unable to affect its border, regardless of the entered values in the respective properties. This used to work, because a year ago when I placed a dbtreeview bean on my form, I named it ‘dbtreeview’ and gave it no border. I don’t remember what version that was, most likely a later build of 2.0. Now this is broken in both 2.2.5 and 3.0rc4. If I place a JTree bean, I can change the border and give it a name, but I lose the ease of use that dbtreeview provides. Please help!

22

Issue confirmed, will be corrected in Servoy 3.0 rc6

23

Is it also possible to allow the setting of the font color? If using fgcolor, that has currently no affect… The font is always black, no matter what I try.

24

Is also corrected in this fix

25

Jan

If possible, could you also look at DBTreeView leaves, as they contain erranously always triangles and show a folder symbol, although it should show no triangle and a file symbol. As soon as one clicks a leave (lowest element), the triangle disappears and the file symbol is shown.

Thanks a lot and best regards, Robert

Jan Blok:
Issue confirmed, will be corrected in Servoy 3.0 rc6

26

Please, Jan, could you also make the background colour work?

Thanks a lot!

Robert

patrick:
Is it also possible to allow the setting of the font color? If using fgcolor, that has currently no affect… The font is always black, no matter what I try.

27

Robert Huber:
If possible, could you also look at DBTreeView leaves, as they contain erranously always triangles and show a folder symbol, although it should show no triangle and a file symbol. As soon as one clicks a leave (lowest element), the triangle disappears and the file symbol is shown.

This is on purpose, the tree is lazy loading, so it does not know the if a node has childeren unless you click on it to expand.

28

You can show 10 levels and hide them again. Then the bean “knows” for those 10 levels if there are children. That’s at least what I do to overcome this problem. You can even see it as a “flexibility”. All depends on the amount of data that you expect…

29

Hello Jan,

I have tried to use the bean that came with 3.0rc6 in Servoy 2.2.xx. When using setRoots, I get a

java.lang.NoSuchMethodError: com.servoy.j2db.dataprocessing.IFoundSet.copy(Z)Lcom/servoy/j2db/dataprocessing/IFoundSet;

Do I need a Servoy 3 j2db.jar?

I have also tried to change the font color via bean.fgcolor. That doesn’t seem to work (at least not in 2.2.xx). I couldn’t manage to change the font color via property or method…

Thanks
Patrick

30

The dbtreeview from 3.0 will only work with 3.0

31

I see. Could you give us the possibility of setting the font in 2.2x? I currently can’t use the bean for navigation because we use a dark background…

32

Hi Patrick

I have no success in reaching the desired result. Could you explain a bit more in detail how you show and hide 10 levels (5 would be ok for me .-) to make the DBTreeView display the leafs correctly, i. e. as files.

Thanks a lot in advance, Robert

patrick:
You can show 10 levels and hide them again. Then the bean “knows” for those 10 levels if there are children. That’s at least what I do to overcome this problem. You can even see it as a “flexibility”. All depends on the amount of data that you expect…

33

patrick:
You can show 10 levels and hide them again. Then the bean “knows” for those 10 levels if there are children. That’s at least what I do to overcome this problem. You can even see it as a “flexibility”. All depends on the amount of data that you expect…

In my current case, there is a lot of data. I simply cannot show 3 levels and hide them, because it takes a minute and it’s unacceptable. Flexibility would be for example to show x levels starting from a given node… so that I could load only parts of the tree and not the entire tree… dev team, what do you think, would this be hard to do? or another solution would be to have a property ‘lazy’ that could be turned on or off - in the case lazy=false, the tree checks the current level to see which nodes don’t have any children (I believe this would not take that much time)

Best,
Adrian

34

Adrian, I think you are trapped. You want the bean to know if a certain node has children but you don’t give it the time to figure out, because it takes too long. And as long as your request is concerned:

the tree checks the current level to see which nodes don’t have any children (I believe this would not take that much time)

You can do that yourself with the way I described. Just don’t show 10 levels but only 2. Then you have what you asked for.

35

Patrick,

if you do that, you indeed have ONLY the children of 2 levels.
If you click the the second-level,after that, you don’t know (see) if there are children in that level.

So I think (and I wish! ;-) ) what Adrian means, that the tree automaticly, search for children, one level deep, if you click on a node!

36

Ah, ok, got it!