Forum Discussion
JackLacava
Honored Contributor
XFMemberProperty is just a lookup: it will return the value of a property for a specific member (in your case, the currently expanded Account).
What you're after is an expansion filter, a .Where; e.g. A#BS.Base.Where(FlowConstraint DoesNotContain 'MVT_GEN')
Unfortunately, I don't think .Where supports filtering on FlowConstraint - but I might be wrong, try it yourself.
Workarounds:
- duplicate the FlowConstraint on a Text property, for example Text8, so you can use A#BS.Base.Where(Text8 DoesNotContain 'MVT_GEN')
- Generate the list of accounts, turn it into excel formulas, and add a column that reports the FlowConstraint for each of them, using XFMemberProperty, then add Excel filtering.
- Write a custom Member List in a Finance Business Rule. Then you can use it anywhere like this:
A#Root.[MyBRRuleName,MyListName]
tedetherington
2 years agoNew Contributor II
Thanks Jack - I think you're right. I have ended up using Text8 and building it from there. A shame the FlowConstraint can't be used for filtering!
Related Content
- 5 months ago
- 26 days ago
- 3 years ago
- 8 months ago