DBTreeview with multiple table

Classic Servoy
1

hi all,

here i would like to ask a question about DBTreeview.

For now i use following code to creat my DBTreeview.

=========================================

  • var Binding = elements.dbtreeview.createBinding(controller.getServerName(), controller.getTableName());*
  • //Replace X with the name of the relation that supplied the childNodes for a Node*
  • Binding.setNRelationName(“house_to_housepart_parent_childs”);*
  • //Replace X with the name of a dataprovider that returns the text for the node*
  • Binding.setTextDataprovider(“displaynode”);*
  • //Sets the global method that gets called when the node is clicked and replace X with the name of a dataprovider will be send as an argument into the globals.XXX method (note: no “()” behind “globals.XXXX”)*
  • Binding.setMethodToCallOnClick(globals.glb_node_selected, “housepart_id”);*
  • controller.find();*
  • //column_x = “someValueHere”;*
  • housepart_parent_id =‘^’;*
  • controller.search(false,true);*
  • //set the root node(s) and set the name of dataprovider to use for text display on a node*
  • elements.dbtreeview.addRoots(foundset);*
    ============================================

previously the data (parent nodes and child nodes) with display in DBTreeview is belong to only 1 table .

but now i want to make the DBTreeview with the 3 level data which belong to 3 table - 2 relations (top level node is from one table, second level node is from one table, lowest level is from one table) that 3 tables have relationship.

But i have no idea with this method

elements.dbtreeview.addRoots(foundset);

how to add data from 3 different tables with this addRoots method.

HELP ME!

Dennis

2

Have you checked the DBTreeView sample solution on the forum? It’s shows you how to do so.

You only need to add roots once and just specify over which relation to get the childNodes.

Paul