Skip to main content
aricgresko
Veteran
Nov 22, 2021 9:34 PM UTC
Solved

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?

Newcomer
Nov 22, 2021 9:37 PM UTC

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

3 replies

Newcomer
Nov 22, 2021 9:37 PM UTC

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

aricgresko
Veteran
Nov 22, 2021 9:38 PM UTC

Perfect - this is exactly what I was hoping for!

ChristianW
Employee - Advisor
Employee - Advisor
Dec 4, 2021 12:19 PM UTC

Can you mark Bierenbroodspot ‘s reply as solution? Thanks