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.GetMembersUsi...
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

     

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.