AnsweredAssumed Answered

Multivalue Lookups - convert to column

Question asked by matpj on Feb 25, 2013
Latest reply on Feb 25, 2013 by matpj
hi all,

has anyone developed a function (Oracle) or SQL that will convert multi value lookups into a comma separated list of values within a single field (for reporting etc.)

e.g. our version field in the system is capable of containing multiple values.
We want to display these in a comma separated list on one of our project reports.

Obviously they are stored as separate rows in the odf_multi_valued_lookups table with a common pk_id.

any ideas/suggestions?

thanks in advance
Regards,
Matt

Outcomes