Treeview widget (control)

[zoltan]

Hi everybody,

I'm a new member, and I've just experimented these days with this platform and must tell you, so far it seems, at least, very interesting.
Now, what I was looking for (even on this forum) and I couldn't find it: it was the infamous treeview widget on the control palette. Am I missing something or it is not implemented yet ? Is there any other possibility to present a tree structure on a form ?
What I need is a static and dynamic treeview control which offers maintenance (create, update, delete nodes) features with minimal coding.
In case of dynamic treeview the underlying data source would be a table with a parent - child field pair.

Thanks!

[Dave]

Hi Zoltan,

You're right, we don't have an out-of-the-box control for this functionality. What we can do though is easily plug in jQuery controls to implement this sort of thing, e.g. the http://jquery.bassistance.de/treeview/demo/ plugin.

We've used this on projects before - if it helps I'll find an example of how to set it up and make it available to the forum? Think we have an example using MySQL for the parent-child table, so we'll provide the SQL processing too for generating the hierarchy of <LI> tags that the jQuery plugin requires.

Will aim to get an example posted asap.

Regards,
Dave

[zoltan]

Hi Dave,

That would be helpful, thanks in advance.

All the best,
Zoltan

[Dave]

Hi zoltan - just to say we haven't forgotten about this. Delay is because we decided to create an example that takes database differences out of the equation - otherwise the SQL to generate the hierarchy from the parent-child table will vary depending on the DB vendor.

Better, we thought, to simply read in the parent-child data via a simple select and do the recursion (tree walk) in server-side javascript. Is done now so will be publishing a sample shortly.

Regards,
Dave

[zoltan]

Hi Dave,

Thanks for keeping me up to date with the progress. I'm waiting patiently

Regards,
Zoltan

[Dave]

Hi Zoltan - sorry for the delay. You can download the treeview widget sample from here:

http://www.ebaseftp.com/download/sample ... eeview.zip

Hopefully it's pretty clear how it works but any questions please feel free.

Sample courtesy of Ian Bramford, btw.

Regards,
Dave

[zoltan]

Hi Dave/Ebase team,

Thanks a lot for your help. It is more than I expected.
I will look at the sample more thoroughly, but so far it looks very helpful.

All the best!
Zoltan