Create mappings (optional)

If a resource attribute has a set of valid values, you can map those to meaningful words that will appear in Personalization rule editors. This facilitates the creation of a rule, as it is possible to select from a list of the words rather than the values. For example, if a column in the database held the integer values of 1, 2, or 3 indicating Yes, No, or Maybe, you could map the integer values to words.

  1. Click the Mappings tab.

  2. Select the column that will be mapped.

  3. Click Edit.

  4. Click Add.

  5. In the window, enter the Description and the Value. A single description cannot be mapped to more than one value.

  6. When finished, click OK.

To automatically map values based upon database values:

  1. Click the column that will be mapped.

  2. Click Populate.

  3. Select a column for descriptions.

  4. Select a column for values. These columns must come from the same table.

  5. Click OK.

For example, a column in the EMPLOYEE table is named WORKDEPT (EMPLOYEE.WORKDEPT). There are two columns in the DEPARTMENT table named DEPTNO (DEPARTMENT.DEPTNO) and DEPTNAME (DEPARTMENT.DEPTNAME). Using the Populate button, you can map the values (DEPARTMENT.DEPTNO) and descriptions (DEPARTMENT.DEPTNAME) of the DEPARTMENT table to the EMPLOYEE.WORKDEPT column.



 

Back