Forum Discussion

aricgresko's avatar
aricgresko
Contributor III
4 years ago

Where clause in Member Filter Builder

Source:   Migrated from Champions I’m trying to use the below member filter to remove only the intercompany accounts. This works, but I lose the indents from using Tree Descendants. A#410000.Tree...
  • Bierenbroodspot's avatar
    4 years ago

    Yes, you can by going down level by level. Per level, you only include the members where the condition IsIC = False. Example:

    A#410000.Children.Where(IsIC = False).Children.Where(IsIC = False).Children.Where(IsIC = False)…