@SmartListFromIndex

@SMARTLISTFROMINDEX returns a Smart List member based on the order of the members in the SmartList.

DTP Type:

@SMARTLISTFROMINDEX can be assigned to a DTP of type string, password, member, or members .

Syntax:

@SMARTLISTFROMINDEX(SmartList,Index)

Parameters:

Parameter Description
SmartList Design-time prompt or dimension. The dimension shows the Smart List dimensions in the application.
Index Design-time prompt or text

Example:

[sl_ind_Str]=@SmartListFromIndex([String1],[index_ST])

Where:

  • [sl_ind_Str] is a DTP of type string that is not a checked prompt.

  • [String1] is a DTP of type string that is a checked prompt.

  • [index_ST] is a DTP of type numeric that is a checked prompt.

Assume that the parameters are as follows:

  • SmartList: "CreditRatings"

  • Index: "2"

In this example, the Smart List "CreditRatings" has the following data:

Name Label
AA ID_ENUMNETLABEL_AA
AAA ID_ENUMNETLABEL_AAA
AAMinus ID_ENUMNETLABEL_AA22
A ID_ENUMNETLABEL_A
AMinus ID_ENUMNETLABEL_AA22
AAPlus ID_ENUMNETLABEL_AA11
APlus ID_ENUMNETLABEL_A11
B ID_ENUMNETLABEL_B
BPlus ID_ENUMNETLABEL_B11
BMinus ID_ENUMNETLABEL_B22
BB ID_ENUMNETLABEL_BB
BBPlus ID_ENUMNETLABEL_BB11
BBMinus ID_ENUMNETLABEL_BB22
BBB ID_ENUMNETLABEL_BBB
AAAMinus ID_ENUMNETLABEL_AAA-
BBBPlus ID_ENUMNETLABEL_BBB+
BBBMinus ID_ENUMNETLABEL_BBB-
CCCPlus ID_ENUMNETLABEL_CCC+
CCC ID_ENUMNETLABEL_CCC

[sl_ind_Str] returns "AAMinus", because that is the name of the Smart List member at the second index position.