AnsweredAssumed Answered

How do I return values from a multi-valued look up?

Question asked by DarleneEvanoff1312021 on May 19, 2015
Latest reply on May 20, 2015 by navzjoshi00

Hi all; I have created a multi-valued look up (MVL) for selecting one or more Business Sponsors for a project.  Works great on the project page but I need to retrieve and display the data in a Portlet; for each business sponsor selected (my attribute is called ahs_bus_sp_mv_lu) I want to show LAST NAME, FIRST NAME (e.g. DOE, JANE); and separate each value by -  whatever will work.  From what I've read I think I need a function and some kind of loop?  I think I need last name, first name from SRM_RESOURCES which will equal the sponsor resource IDs chosen; and the mvl.pk_id needs to equal the project_id.  I am having a heck of a time adding such a select or function or whatever I need to the existing query my portlet is based on.  Can anyone please help??!!  Thanks.

Outcomes