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.TreeDescendants.Where(IsIC = False)

Is there a workaround to remove just the IC accounts while still retaining the indents from tree descendants?

  • 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)…

  • Bierenbroodspot's avatar
    Bierenbroodspot
    New Contributor II

    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)…