Forum Discussion

Samwise's avatar
Samwise
New Contributor II
24 days ago
Solved

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
  • rhankey's avatar
    rhankey
    24 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

     

2 Replies

  • rhankey's avatar
    rhankey
    Contributor III
    24 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

     

    • Samwise's avatar
      Samwise
      New Contributor II
      21 days ago

      I was able to get it working from this, thank you.