aricgresko
4 years agoContributor III
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)…