Imagine that you have 3 different folders for a "news" content, two of them with "Public" SecurityGroup but the last one with "Secure" SecurityGroup.
Usually you will create only one profile, so users will select the folder during check-in process (if they can see them) and depending of the folder, the metadata dSecurityGroup will be filled.
Here are the steps to achieve this:
Modify "Folders" View
- Log into Configuration Manager Applet

- Go to "Tables" tab, and select "Collections" table.

- Click on "Edit Table", if you cannot see the columns, click on "syncrhonize definition" close again the windows and try again (sometimes it tooks a while until the columns information appears)

- Now move to "View" Tab and Edit the "Folders" View.

- Edit it and select the "Change Columns" to include the dSecurityGroup


- Move to the "Security" Tab and check the option "Publish view data".

Creating the Rule
- Create a new rule and check it as "global"

- Go to fields, and add "Security Group"


- Edit "Derived field information" and in custom tab add this code:


<$nuevoValor=getViewValue("Folders",#active.xCollectionID,"dSecurityGroup")$>
<$if nuevoValor$>
<$dpPromote("dSecurityGroup",nuevoValor)$>
<$endif$>
Few things to remember
If the metadata from the parent that you want to "derive" is custom (like xDepartment) you should create a view from table "COLMETA" with the columns dCollectionID and xDepartment, for more info check on metalink this note: 780979.1