Results 1 to 2 of 2

Thread: search in TreeGrid

  1. #1

    search in TreeGrid

    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!

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,731
    Blog Entries
    18
    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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us