Concatenate Multi-Value Lookup into One Field for Display Purposes – Oracle

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.

Want access to our solutions?

Register for a free theBasiX™  account and upgrade to theWorX to gain access to all of the content available on RegoXchange™.

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.