The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
JonKunert
1 year agoContributor III
XFget to retrieve name from description
Is there a function to lookup the name of a member from description. I've been looking at the functions for a couple hours and cant find anything
There is no api function that directly returns a member name from a description. However you can use api.Members.GetMembersUsingFilter() with a filter of something like "A#Root.DescendantsInclusive.Where(Description = Equity)", which will return a list of Members matching that filter. You would need to figure out what to do if you got zero or more than one matches, as Descriptions are not required to be unique.
"
6 Replies
- rhankeyContributor III
There is no api function that directly returns a member name from a description. However you can use api.Members.GetMembersUsingFilter() with a filter of something like "A#Root.DescendantsInclusive.Where(Description = Equity)", which will return a list of Members matching that filter. You would need to figure out what to do if you got zero or more than one matches, as Descriptions are not required to be unique.
"
- JonKunertContributor III
That will work. We dont use the description in multiple places. Thank you for this
- SimonHesfordContributor II
I would venture no as Member Descriptions do not need to be unique so they couldn't be guaranteed to return a specific member.
- JonKunertContributor III
Thats what i figured, but was hoping I was wrong
- SimonHesfordContributor II
Yeah, the hours of searching was probably your biggest clue š
Related Content
- 3 years ago
- 3 years ago