@SmartListFromValue
@SMARTLISTFROMVALUE returns a Smart List member based on the ID of the member in the SmartList.
DTP Type:
@SMARTLISTFROMVALUE can be assigned to a DTP of type string,, password, member, or members if only one member is entered.
Syntax:
@SMARTLISTFROMVALUE(SmartList,Value)
Parameters:
| Parameter | Description |
|---|---|
Smartlist |
Design-time prompt or dimension. The dimension shows the Smart List dimensions in the application. |
Value |
Design-time prompt or number |
Example:
[sl_val_Str]=@SmartListFromValue([String1],[value_ST])
Where:
-
[sl_val_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. -
[value_ST]is a DTP of type numeric that is a checked prompt.
Assume that the parameters are as follows:
-
Smart List: "CreditRatings"
-
Value: "5"
In this example, the SmartList "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_A22 |
| 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_val_Str] returns "AMinus" because that is the name of the SmartList member with the ID of 5.