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?

Best answer by Bierenbroodspot

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

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

Perfect - this is exactly what I was hoping for!

Can you mark Bierenbroodspot ‘s reply as solution? Thanks

Sign up