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!
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!
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+’*’”)
Last edited by barrymavin; 2022-05-12 at 13:27.
Principal developer of Lianja, Recital and other products
Follow me on:
Twitter: http://twitter.com/lianjaInc
Facebook: http://www.facebook.com/LianjaInc
LinkedIn: http://www.linkedin.com/in/barrymavin
Bookmarks