Skip to main content
S
Samwise
August 20, 2025
Solved

Get list of base members where text = in vb

  • August 20, 2025
  • 1 reply
  • 0 views

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.

Best answer by rhankey

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

 

1 reply

R
rhankeyAnswer
August 20, 2025

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

 

S
SamwiseAuthor
August 23, 2025

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

Terms & ConditionsAccessibility statement