Prompting for parameters for Tableview

Cosimo
Contributor II

I've got a Tableview embedded in an Excel workbook and would like to be able to prompt the user to select an entity and period that is then used to filter records. Is this possible?

1 ACCEPTED SOLUTION

LeeB
Contributor II

Yes, this is possible.

You define your parameters in a list.  "SelectEntity" could be a normal parameter i.e., Member List, Member Dialog etc. 

LeeB_0-1670429669758.png

Then retrieve them in your Table View rule using the strings in your SQL query.

LeeB_1-1670429682359.png

You'll then get prompted for these parameters on refreshing the Table View.

 

View solution in original post

3 REPLIES 3

LeeB
Contributor II

Yes, this is possible.

You define your parameters in a list.  "SelectEntity" could be a normal parameter i.e., Member List, Member Dialog etc. 

LeeB_0-1670429669758.png

Then retrieve them in your Table View rule using the strings in your SQL query.

LeeB_1-1670429682359.png

You'll then get prompted for these parameters on refreshing the Table View.

 

Cosimo
Contributor II

Thanks Lee. It works! What threw me off is that the documentation describes that you can create a list of parameters but fails to include that we should be returning the list back to the table view i.e. missing the "Return list" line in the code. 

Cosimo_0-1670437963857.png

 

 

LeeB
Contributor II

No problem, happy it's working.