Retrieving a list of members in a parameter in Excel including both Name and Description
Hi,
I’ve had an issue trying to use parameters to retrieve both names and descriptions of entities in Excel using a parameter.
I use a Member List parameter with a filter of entities.
In Excel, if I tick ‘Description’, sometimes I get only descriptions; and sometimes I get both names and descriptions, which is the desired behavior (the client wants to be able to choose entity by their names, and I need the code in the parameter to make the XFGetCell formulas work).
Is there any option here I’m not aware of?
I’ve found a solution, which is to create a XFBR rule that feeds a Delimited List parameter with strings including both name and description. It works fine. But I’d like to make sure I didn’t miss something obvious here.
