Edit Item Type: Attributes

Select the attributes that you want to add to the item type, and click to move them to the Selected Attributes list.

To move all attributes to the Selected Attributes list, click .

Lists the attributes that have been added to the item type.

Click to change the order in which the attributes are displayed for item creation and editing.

To remove attributes from the item type, select them in the Selected Attributes list and click . To remove all attributes, click .

Enter the value to give to the attribute if users do not specify their own value when they add an item of this type. The attribute's default value is used for all items created of this item type. You can allow users to modify this value by including the attribute in the add and edit item wizards.

You can use PL/SQL expressions and function calls to determine the default value for an attribute. You must precede the expression or function call with a # character. The function being called must already exist in the database and must be prefixed with its owning schema.

Examples:

To set the default value of the Author attribute to the current user, enter:

• #USER

To set the default value of the Publish Date attribute to the first day of the next month, enter:

• #TO_CHAR(LAST_DAY(SYSDATE)+1, 'DD-MON-YYYY HH12:MI PM')

To set the default value of a custom Project ID attribute to the current project to which the current user is assigned, you would first need a function that returns the id of the project. The function might be something like the following (presuming that a user is assigned to only one project for any specified date):

create function GET_CURRENT_PROJECT return VARCHAR2 as
  project_id VARCHAR2 (30);
begin
  select pa.id
  into project_id
  from project_asignments pa
  where SYSDATE between pa.start and pa.end --selects the current assignment
  and pa.assignee = WWCTX_API.GET_USER; --gets the name of the current user
  return project_id;
end;

If this function has been created in the PROJECTS schema, enter the following in the Default Value field for the Project ID attribute:

• #PROJECTS.GET_CURRENT_PROJECT

Notes:

• You cannot pass attribute values as parameters to a function when it is called from an attribute default value. You can however pass PL/SQL expressions as parameters.
• You can use expressions and function calls only for the default values of attributes, not for the actual values of attributes.
• If you are using an expression to determine the default value of a date attribute, you must make sure that the date value is converted to the DD-MON-YYYY HH12:MI PM date format as shown in the second example above.