Get the member list from a parameter in a spreadsheet BR

dcadenas
New Contributor II

Hi all,

 

I need to call this parameter to get the results in a member List of a BR:

dcadenas_0-1695727952084.png

In this case, I would need to get a list with the values 6620 and 7610 in a Business rule of type spreadsheet

Please, could you help me with any function to call this parameter and get this values?

Thank you so much in advance!

 

2 REPLIES 2

MikeG
Contributor III

Hi @dcadenas, if your Dashboard component is a Combo Box - there is a property on the Combo Box where you should add p_Acc_Interses as the Bound Parameter.

MikeG_0-1695734377128.png

If you're looking for a way to make that Member Filter more dynamic, consider using a Where Clause, you could use a Text Property filter like such to get to a list of Accounts you want to appear in your Combo Box.

MikeG_1-1695734515551.png

Hope this helps,

 

 

dcadenas
New Contributor II

Hi Mike, 

Thank you for your anwser!

I need to get the member list in a business rule of type spreadsheet which would return the parameters accounts in the next way:

Dim accountList As List(Of Member) = ....