search in TreeGrid

[karlaesponda01]

Hi!

I was wondering if there´s any way where you can search records in a TreeGrid, or where you can filter the results in the TreeGrid.

Or any recomendations to do that.

Thanks!

[barrymavin]

Hi Karla

Seeing that a treegrid is a canvas component you can clear() the grid and use addItems() with a sql select statement that has a where condition.

Build a where condition that uses the LIKE operator e.g

// in the interactivechange of a textbox field
m_text = Lianja.get(“field1”).text
lianja.get(“yourtreegrid”).clear()
Lianja.get(“yourtreegrid”).additems(“select * from yourtable where yourfield like m_text+’*’”)