1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to create a Dependent Choice list in Oracle UCM (Stellent)

Discussion in 'Oracle Development General' started by Sadik, Nov 19, 2008.

  1. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    How to create a Dependent Choice list in Oracle UCM (Stellent)

    When creating custom metadata fields, creating dependent choice lists is a very common requirement. For first timers this may be a little confusing. Basically to cr

    1. create two tables from configuration manager-> tables. The first table is to hold the independent values and the second table should have at least two columns. One column should be same as the column in the independent table and the second column is to hold dependent values
    2. create two views from configuration manager->views based on these two table you just created.
    3. create a relationship from configuration manager ->relations. Select the first table in parent and it's column and the second table in child and make sure you select the column which is the same as independent table's column.
    4. Now first create the independent metadata field, field1. Make Field1 an optionlist and use view table1 (the independent table)
    5. create the dependent field, Field2, enable option list, use the view on table2. Tick "Dependent Field", select the Field1 from drop-down menu and select the relationship you just defined and click ok.​

    That's it, your Dependent Choice List is done. Make sure you goto Views and add values to both your views. Open a new Browser window and login. You should now see the two new custom metadata fields and also the dependency.

    if this seems confusing, let's take an example

    Step 1:

    Independent Table->Projects
    Column1->ProjectCode

    Dependent Table->Proposal
    Column1->ProjectCode
    Column2->ProsalCode

    Step 2:

    View1 ->ProjectsView
    View2 ->ProposalView

    Step 3:

    Relation -> Project2Proposal
    Parent Info -> Projects
    column -> ProjectCode
    Child Info -> Proposals
    column -> ProjectCode

    step 4:

    Custom Metadata Field1 -> Project
    View to select -> ProjectsView

    step 5:

    Custom Metadata Field2 -> Proposal
    View to select -> ProposalView
    Relation ->Project2Proposal

    Cheers! :D
     
  2. guliflower

    guliflower Active Member

    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Ettlingen, Germany
    Great help! Thanks a lot!!!
    Do you know how to update a default value of the field 2 if field 1 is updated upon check in?
    Thanks!:hurray
     
  3. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    I didn't really get you, you should explain your problem in the forums.
     
  4. guliflower

    guliflower Active Member

    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Ettlingen, Germany
  5. guliflower

    guliflower Active Member

    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Ettlingen, Germany
    You don't mention that one should Publish Schema after creationg the DCL, while in the UCM help they say, that schema publishing is necessary. Could you please explain, when schema should be published and when not and when schema base should be published.

    Thaks a lot!