Forum Discussion

Samwise's avatar
Samwise
New Contributor II
3 days ago

Get list of base members where text = in vb

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.

Finance

1 Reply

  • rhankey's avatar
    rhankey
    Contributor III
    3 days ago

    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