Oracle WebCenter Content (MOSC)

MOSC Banner

Option list generated though 2 relations and a dependent variable

edited Jul 6, 2020 5:13PM in Oracle WebCenter Content (MOSC) 2 commentsAnswered

So I was modifying some code recently to generate an option list based on alias groups and a dependent field. I managed to accomplish this functionality but it works by displaying the persons username. There is a table that contains both username and full name, but I've been unsuccessful at utilizing it to convert the usernames generated into the list to their real name counterpart.

Tables:

ASSET

  - AssetName

  - AliasGroupName

ALIASUSER

   - dAlias (same as AliasGroupName in ASSET)

   - dUserName

USER

   - dName (same as username for ALIASUSER)

   - dFullName

My current setup is having the option list field populated with a view based on the ALIASUSER table.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center