Can someone help me with how to implement picklist in Framework Manager? I have created a new namespace added a calculation item and in the expression i chose 'promptmany'. My user has a list of names that he uses, he wants me to display all the names in the list and he will select any names he wants based on his needs. How can this be accomplished?
Thank You!!
1. Create a QS: PickList_Names with two columns for Shown and Filter
.. in Where-Clause apply a filter that cuts down the picklist to user allowed
e.g.
SELECT PicklistShowID, PicklistFilterID FROM names n
WHERE
upper(n.USERID) = UPPER(#sq($account.personalInfo.userName)# )
2. in any "picked" QS have a Where-Clause:
WHERE ...
NAME in ( #promptmany ( 'Your names','character','','','[your_datasource].[PickList_Names].[PicklistFilterID]')# )