DBtreeview search

Classic Servoy
1

Hello Everbody

This has been asked in another post, but with no answer.

I use a DBTREEVIEW in Servoy 6.0.6 webclient to show structured records from a table(rbobjekte).
All records have an ID and a PARENTID. (objektid, oberobjektid)

v_binding.setNRelationName("objektid_oberobjektid"); 
v_binding.setTextDataprovider("rbobjekteid"); 
v_binding.setMethodToCallOnClick(m_akt_objekt,"rbobjekteid"); 
v_binding.setMethodToCallOnDoubleClick(m_doubleKlick,"rbobjekteid");
elements.objtreeview.removeAllColumns();
//width of first column wg. x levels
elements.objtreeview.setTreeColumnPreferredWidth(300);
//label first column
elements.objtreeview.setTreeColumnHeader("Piepenbrock ObjektID");
		
elements.objtreeview.createColumn('maxdb','rbobjekte', 'Bezeichnung', 'objektbezeich',300);
elements.objtreeview.createColumn('maxdb','rbobjekte', 'Ort', 'ort',170);
elements.objtreeview.createColumn('maxdb','rbobjekte', 'Strasse', 'strasse',170);

The levels can be up to 10!!!

Now i’m looking for a way to search for an objectname (objektbezeich).

Example:
The user looks at the treeview and is searching an objekt with objektbezeich = “COOLING UNIT”
Until now he has to expand all notes until he finds an rbobjectid with objektbezeich = “COOLING UNIT”

But he wants a search field where he types in “COOLING UNIT” and treeview shows this object ??? May be in building,cellar,cellarroom4

No idea :-(

Any help welcomed.

Best regards
Albert

2

The tree is based on a foundset, just search the foundset, once you find your record you can walk up the hierarchy until level zero saving the pks in an array, revert the array and use the expand node fuction to open the tree.