Get list of base members where text = in vb

Question

I am having difficulties getting either the member ID or member name into a list using GetMembersUsingFilter.

I have got this so far.

Dim members As List(Of MemberInfo) = api.Members.GetMembersUsingFilter(api.Pov.AccountDim.DimPk, "A#BalanceSheet.Base.Where(Text2 = RF_Debt)", Nothing)

However, this gives me neither the member ID or member name.

rhankey · Accepted Answer

GetMembersUsingFilter() returns a list of zero or more members matching the filter. Perhaps the following will get you going in the right direction:

Dim members As List(Of MemberInfo)=api.Members.GetMembersUsingFilter(api.Pov.AccountDim.DimPk,"A#BalanceSheet.Base.Where(Text2 = RF_Debt)")

For Each MemberItem As MemberInfo In members

Dim MemberItemId As Integer=MemberItem.Member.MemberId

Dim MemberItemName As String=MemberItem.Member.Name

Next MemberItem

Sign up

Login with SSO

Login to the OneStream Community

Login with SSO