News in versions: FastGrid 1.0, TreeGrid 17.0
FastGrid FastSheet ExamplesSamples DocumentationDoc Download Licensing Prices Buy Development
services
References References Contacts
TreeGrid Gantt chart SpreadSheet ExamplesSamples DocumentationDoc Download Licensing Prices Buy Contacts

3. Filtering in tree

Various ways to filter rows in parent / child relation

  • Cfg

    FilterTree


    The attribute Cfg FilterTree specifies how the rows or columns will be filtered in tree, if the parents and children of the found rows will shown, hidden or filtered.
    • 0 - Show only found. Shows only rows that fulfill the condition, regardless on tree.
    • 1 - Show only found, with all children. If some row fulfills the condition, all its children are shown too and not iterated.
    • 2 - Show all found. If some row fulfills the condition, all its parents are shown too.
    • 3 - Show all found, with all children. If some row fulfills the condition, all its parents and all its children are shown too. The children are not iterated.
    • 4 - Hide all not found. If some row does not fulfill the condition, it hides all its children and does not iterate them.
    • 5 - Hide all not found, with all children. If row does not fulfill the condition, it hides all its children. If row fulfills the condition, it shows all its children. The children are not iterated.
  • FilterTree setting


    The Cfg FilterTree attribute can be changed by users by toolbar combo cell D:

    FilterTree

    .
    It shows popup list with all the available options.
  • Filter only specified defaults


    It is possible to apply the filter set in the Filter cell to only particular rows, set their default row id(s) to cell

    FilterD

    . Rows with other default rows will not be affected by this filter and will be always shown.
    To let users to choose the FilterD, define cell attribute

    FilterDList

    to add these options to the filter operators menu.