Concatenate Multi-Value Lookup into One Field for Display Purposes – SQL
The Concatenate Multi-Value Lookup into One Field for Display Purposes technical trick provides an overview of how to group or concatenate the various levels and values of a Multi-Value lookup into one field in both Oracle and SQL Server environments. This allows the lookup values to be more easily displayed in a portlet. The function concatenates the values together using a choice of delimiter, which then allows the multi-value lookup to be viewed as one portlet column, in the same manner as any other object attribute.
Download Details
RegoXchange Content ID: EX0979
Submission Date:
Submitter:
Content Type: Technical Tricks
Related Modules: Administrative Support
Company: Rego Consulting
Version Support
Versions Supported: 15.x, 16.x
Special Instructions
Special Instructions: Included in this Tech Trick are two example portlets that pull in an example Multi-Valued Lookup called “Impacted Applications.” The lookup ties to an Investment attribute and has the Lookup ID of ‘impacted applications’ – If the example portlet is used, simply swap “Impacted Applications” for another Investment MVL field.
