# Administrator Guide

# Creating Studio Portlets

The portlets that you can create with Studio include a user interface, application logic, and a database. Portlets are modular applications that users can add to their My Pages or community pages. All Studio portlets, except the Report Summary portlet, include an entry form for typing in data and a report that shows a summary of data.

Studio portlets store their data in a database. You can configure each portlet to point to its own database table, or you can have multiple portlets point to one database table. Records added, modified, or deleted in one portlet will affect other portlets that point to the same database table. Once you assign a database table to a portlet, you cannot change the assignment; the portlet will always point to that particular database table. For more information on Studio database, see Creating Studio Database Tables and Managing Studio Database Tables.

You must have Edit access to an administrative folder in the portal in order to create new Studio portlets. Authoring privileges for administrative folders are set in the portal.

This chapter describes the different Studio portlets available, helps you determine what types of Studio portlets to create, and instructs you on how to create each portlet. It includes the following sections:

- Choosing Appropriate Studio Portlets
- Creating Portlets
- Designing Your Record Entry Forms
- Sending Notifications
- Designing Portlet Reports
- Designing the Portlet Window
- Creating Studio Portlet Templates

## Choosing Appropriate Studio Portlets

All Studio portlets either collect or display data. Studio provides seven portlet templates for different business needs, with an eighth one that you can customize. The table below provides an overview of features of the portlets as well as the objects that the portlets use.

Table 3-1 Studio Portlets and Their Features and Objects
| Poll Portlet | Survey Portlet | Calendar Portlet | Data Submission Portlet | Record Browser Portlet | Record Lookup Portlet | Record Summary Portlet
--- | --- | --- | --- | --- | --- | --- | ---
Database |  |  | X | X | X | X | X
Entry Form |  |  | X | X | X | X |
Email Notification |  |  | X | X | X | X |
Reports |  |  | X | X | X |  | X
Filtering |  |  | X | X | X |  |
Sorting |  |  |  | X | X |  |
Search Records |  |  |  |  | X | X |
Polling | X | X |  |  |  |  |
Survey Options |  | X |  |  |  |  |

### Polls

Two Studio portlets let you solicit the opinions of your users: the Poll portlet and the Survey portlet. Both portlets are the simplest portlets and neither one requires you to create a database.

#### Poll Portlet

If you want users to cast their votes for a choice, create a poll portlet. After your users select their choices, they can see the aggregated results, but they will not be able to go back and change their vote. Users will not be able to vote more than once. This portlet includes a ballot and a poll results page.

Poll portlets are suitable for gathering for-or-against votes or votes for preferences or options, such as the most valued benefit or the favorite employee lunch plan.

For instructions on how to create a Poll portlet, see Creating Poll Portlets.

Figure 3-1 Poll Portlet: Ballot and Poll Result

#### Survey Portlet

To solicit opinions or comments from your users, create a Survey portlet. Unlike the Poll portlet, users who answer the survey cannot see the results; instead, they see a thank-you page. While the Poll portlet is ideal for most single-choice voting, you can use a Survey portlet as a blind poll that lets your users cast votes without seeing the results. You can also set the Survey portlet to allow users to take the survey more than once.

Survey portlets are suitable for customer surveys and feedback questionnaires. This portlet includes a welcome page, a survey page, and a thank-you page. For instructions on how to create a survey portlet, see Creating Survey Portlets.

Figure 3-2 Survey Portlet: Welcome Page and Survey

Users with administrator privileges can view the survey results summary as well as all individual responses. For information on administrator privileges, see Security.

Figure 3-3 Survey Portlet for Administrators: Survey Summary Report and All Submitted Survey Report

### Calendar

The Calendar portlet lets your users create a calendar for events or scheduling. The portlet includes a calendar and an event entry form that lets your users add an event to the calendar. Your users can view a daily, weekly, or monthly format of the calendar. The portlet includes a calendar, an event details pane, and an event entry form.

To populate the calendar, you can either create new events in the Calendar portlet itself or you can import existing events from a database. Events added and deleted from the Calendar portlet are immediately reflected in the information displayed on every portlet that points to the same database table.

Calendar portlets are suitable for depicting chronological data, such as calendar of events, holidays, seminars and conferences, and vacation plans.

For instructions on how to create a Calendar portlet, see Creating Calendar Portlets.

Figure 3-4 Calendar Portlet: Calendar (Monthly View), Event Details, and Event Entry Form

### Data Entry

Two Studio portlets provide means for your users to enter data: the Data Submission portlet and the Record Browser portlet. Both portlets let users add entries to the database and view data, but the Record Browser portlet provides more functionality. The Data Submission portlet only lets users create and view data; while the Record Browser portlet lets users add, modify, and delete records. They can even export the contents of the portlet to Excel. Both portlets can point to the same database table.

#### Data Submission Portlet

A Data Submission portlet lets your users create records. It is designed primarily for collecting data, and it can accommodate all types of data that the Poll, Survey, and Calendar portlets can. Users can submit a new record through a record entry form, as well as view and edit records they have created. Records added and deleted from the Data Submission portlet are immediately reflected in the information displayed on every portlet that points to the same database table. This portlet includes a form for adding new data and a report of submitted records.

Data Submission portlets are suitable for service requests, work orders, and detailed questionnaires that includes chronological data.

For instructions on how to create a Data Submission portlet, see Creating Data Submission Portlets.

Figure 3-5 Data Submission Portlet: Record Entry Form

Figure 3-6 Data Submission Portlet: Report

#### Record Browser Portlet

A Record Browser portlet displays a list of records, presented as table rows of data. The data in the portlet is updated whenever your users create, edit, or delete records. Users can also search for a particular record and view other reports that the administrator has made available to them. Users can even export the contents of an entire report and the search results into an Excel spreadsheet.

Record Browser portlets are suitable for a bookmark list (that points to different white papers across projects and teams). This portlet includes a report in a tabular form, a detail form, and a record entry form for editing or adding information. It can also have multiple reports. For instructions on how to create a Record Browser portlet, see Creating Record Browser Portlets.

Figure 3-7 Record Browser Portlet: Report, Detail Form, and Record Entry Form

### Reports and Record Lookup

Two Studio portlets provide reports that display data: the Record Lookup portlet and the Record Summary portlet. The Record Lookup portlet allows your users to search for a piece of data in the database; the Record Summary portlet simply displays a summary of collected data. Unlike all other Studio portlets, the Record Lookup and the Report Summary portlets do not provide means for users to add entries (although the Record Lookup allows users to edit pre-existing entries); therefore, you either have to point the portlets to a pre-existing database table that is already populated with data or create a different portlet (such as a Data Submission portlet) that allows your users to add entries into the database table. The data-entry portlet is the means by which your users can populate the database table, and the Record Lookup portlet can search for the entered data.

#### Record Lookup Portlet

The Record Lookup portlet lets your users search for records based on a set of criteria you specify, and then edit those records. This portlet includes a record search form, a search results page, and a detail pane. The detail pane is launched when your user clicks an item in the search results page.

This portlet is suitable for company directory, inventory catalog, and phone number lookup.

For instructions on how to create a Record Lookup portlet, see Creating Record Lookup Portlets.

Figure 3-8 Record Lookup Portlet: Record Search Form, Search Results Page and Detail Pane

#### Record Summary Portlet

The Record Summary portlet lets your users view a report of aggregated records. You can control the layout of the report and select the data to display. This portlet includes a summary report.

The Record Summary portlet is suitable for any summary report, such as a sales report that displays sales totals for each region of your company or an annual expense report for a department.

For instructions on how to create a Record Summary portlet, see Creating Record Summary Portlets.

Figure 3-9 Record Summary Portlet

## Creating Portlets

Studio lets you create portlets. Because various wizards guide you through the creation of your portlet's user interface, application logic, and database, you do not need to know how to program. All portlets are created in the Administration area of the portal.

To create any portlet:

1. Log in to the portal as an administrator.
2. Click Administration.
3. Navigate to the folder that the portal administrator has created for storing Studio portlets.
4. In the Create Object menu, select Portlet.

The Choose Template or Web Service dialog box appears.

5. Select a Studio portlet template, and then click OK.

Each portlet template provides a different portlet structure, interface, and functionality. For more information on which type of portlet to create, see Choosing Appropriate Studio Portlets.

6. Under the Web Service section in the Portlet Editor, click Edit.

The Studio Portlet Wizard appears.

7. Create a new portlet through the wizard. For specific instructions on how to create each kind of portlet through the wizard, see the following sections:

- Creating Poll Portlets
- Creating Survey Portlets
- Creating Calendar Portlets
- Creating Data Submission Portlets
- Creating Record Browser Portlets
- Creating Record Lookup Portlets
- Creating Record Summary Portlets

8. Click Save.

The Studio Portlet Wizard closes.

9. In the Portlet Editor, click Finish.
10. In the Save As text box of the Save In page, type the name of your portlet.
11. Click Save.
12. Click Close.

After you set the portlet security to allow users and groups to access the portlet, the portlet can be added to a portal page. It also becomes available in the Studio administrative portlets—Studio Administrator and Studio Database Manager.

For more information about portlet security, see Securing Portlets; for more information about Studio Administrator, see Managing Studio Portlets; for more information about Studio Database Manager, see Managing Studio Database Tables.

### Creating Poll Portlets

After you select the Studio Poll template and click Edit in the Portlet Editor page, the Studio Poll Builder displays. Create a poll with one question, and define a set of answers. For instructions on how to navigate to Studio Studio Poll Builder, see steps 1 to 5 described in Creating Portlets.

1. In the Question Text text box, type your question.
2. In the Answer Options text box, type all the various choices you want your users to vote on. Press ENTER after each choice. Each new line in the text box represents a choice for portal users to select in a poll.
3. In the Answer Style drop-down list, select Select Menu or Radio Button.
4. Click Save.

The Studio Poll Builder closes.

After you close the Studio Poll Builder, do not forget to save your portlet through the Portlet Editor by following steps 8 to 11 described in Creating Portlets.

### Creating Survey Portlets

After you select the Studio Survey template and click Edit in the Portlet Editor, the Studio Survey Builder appears. Create a question for your survey. For instructions on how to navigate to the Studio Survey Builder, see steps 1 to 5 described in Creating Portlets.

1. In the Question Text text box, type your survey question.
2. In the Question Type drop-down list, select the answer format.

   Table 3-2 Question Types: Each survey question can be answered in different ways
   Question Type | Purpose
   --- | ---
   Text Input, Single-line Text Box | Typing brief text; for example, typing names or cities of birth.
   Text Input, Multiple-line Text Box | Typing long answers with formatting; for example, writing comments, complaints, or suggestions. You can configure the question type to allow only plain-text answers or answers with formatting, such as with bold, red words to highlight important text.
   Single Choice, Radio Buttons | Selecting a preference from a defined selection list; for example, voting for the best solution.
   Single Choice, Select Menu | Selecting a preference from a defined selection list; for example, identifying the operating system one is using from a list of operating systems.
   Multiple Choice, Check Boxes | Identifying multiple preferences or answers from a defined list; for example, the cars one has driven in a lifetime.
   Rating Scale, Matrix | Rating various subjects on a defined list; for example, rating the restaurants on the list.
   Yes/No | Voting for or against an option, or voting for a single option out of many; for example, agreeing or disagreeing with the latest lunch policy.
   Date Input Field | Entering dates and times; for example, the best time to call.
   Text Heading | Explains the survey or gives further instructions to your survey participants; for example, you might want to introduce subsections in a long survey with subject headings or introductory notes.

3. If you want the person taking the survey to answer the question and not skip it, select the Is the user required to answer this question check box.
4. If you want to add this question and create another one, click Add and New; if this is your last question, and you want to end the survey creation, click Add.

The Studio Survey Builder displays a preview of your survey.

5. If you want to change the order of the questions, modify the question types and their options, edit the text of the question, add a new question, or delete the question, change the preview page.

For more information on the buttons and tools in the preview page, see the online help for Studio.

6. To set the introductory and completion text and allow users to submit multiple surveys, click Edit Survey Properties.
7. Type the introductory and thank-you text.
8. Select whether or not you want the Survey portlet to allow users to submit multiple surveys.
9. Click << Previous.
10. Click Finish.
11. Click Save.

The Studio Survey Builder closes.

After you close the Studio Survey Builder, do not forget to save and name your portlet through the Portlet Editor by following steps 8-11 described in Creating Portlets.

### Creating Calendar Portlets

After you select the Studio Calendar template and click Edit in the Portlet Editor, the Studio Portlet Wizard displays. For instructions on how to navigate to the Studio Portlet Wizard, see steps 1 to 5 described in Creating Portlets.

1. Create a database table to store information associated with your Calendar portlet. You need to create at least one Date data column (date and time data type) and one event column (text data type) for the database table.

- For instructions on creating a new database table for the portlet, see Creating a New Database Table.
- For instructions on using an existing database table for the portlet, see Using an Existing Database Table.

2. Design how the form by which users enter data should appear.

For instructions, see Designing Your Record Entry Forms.

3. If you want to notify certain users about records that are created, modified, or deleted, set up an e-mail notification.

For instructions, see Sending Notifications.

4. In the Calendar Display page, do the following:

1. In the Calendar Name text box, enter the calendar name.
2. In the Start Date Column drop-down list, select the column that contains the dates marking the beginning of events.

If you have created only one Date data column, the Studio Portlet Wizard will automatically select the only Date data column you have created. It will not have a drop-down list.

3. If you want to include an end date, in the End Date Column drop-down list, select the column that contains the dates marking the end of events.

If you have not created a Date data column to hold information about dates marking the end of the events, click << Previous in the Studio Portlet Wizard until you return to the Database Columns page of the wizard. Create a Date data column for end dates (For more information on creating data columns, see Defining the Columns in the Database Table). After you create the column, click Next >> until you return to the Calendar Display page of the wizard.

4. In the Event Text Column drop-down list, select the column that contains the descriptive text for the events.
5. In the Display Start Time for Each Event drop-down list, select Yes if you want the start time to be displayed; otherwise, select No.
6. To change the appearance of your calendar, click Edit Calendar Layout.

This launches the Studio Page Layout Editor. For more information on the Page Layout Editor, see the online help for Studio.

7. When you are finished, click Next >>.

5. If you want the Calendar portlet to display only a subset of events, create filters.

Suppose you have a master database of company events. If you want to create a Marketing Calendar portlet, you would create filters that display only events that relate to Marketing. For instructions, see Creating Filters.

6. In the Portlet General Info page, click Next >>.
7. Click Save.

The Studio Portlet Wizard closes.

After you close the Studio Portlet Wizard, do not forget to save and name your portlet through the Portlet Editor by following steps 8 to 11 described in Creating Portlets.

### Creating Data Submission Portlets

After you select the Studio Data Submission template and click Edit in the Portlet Editor, the Studio Portlet Wizard displays. For instructions on how to navigate to the Studio Portlet Wizard, see steps 1 to 5 described in Creating Portlets.

1. Create a database table to store information associated with your Data Submission portlet.

- For instructions on creating a new database table for the portlet, see Creating a New Database Table.
- For instructions on using an existing database table for the portlet, see Using an Existing Database Table.

2. Design how the form by which users enter data should appear.

For instructions, see Designing Your Record Entry Forms.

3. If you want to notify certain users about records that are created, modified, or deleted, set up an e-mail notification.

For instructions, see Sending Notifications.

4. Design how you want the reports of your portlets to appear.

For instructions, see Designing Portlet Reports.

5. If you want your report to display only a subset of records, create filters.

Suppose you have a master database of company sales. If you want to create a Western Region Sales report, you would create filters that select only sales information that relates to your Western regional offices.

For instructions on how to create a filter, see Creating Filters.

6. If you want to specify the order in which records display in your portlet's report page, add sort criteria.

For instructions, see Adding Sorting to Reports.

7. In the Report Portlet General Info page, click Next >>.
8. Click Save.

The Studio Portlet Wizard closes.

After you close the Studio Portlet Wizard, do not forget to save and name your portlet through the Portlet Editor by following steps 8 to 11 described in Creating Portlets.

### Creating Record Browser Portlets

After you select the Studio Record Browser template and click Edit in the Portlet Editor, the Studio Portlet Wizard displays. For instructions on how to navigate to the Studio Portlet Wizard, see steps 1 to 5 described in Creating Portlets.

1. Create a database table to store information associated with your Record Browser portlet.

- For instructions on creating a new database table for the portlet, see Creating a New Database Table.
- For instructions on using an existing database table for the portlet, see Using an Existing Database Table.

2. Design how the form by which users enter data should appear.

For instructions, see Designing Your Record Entry Forms.

3. If you want to notify certain users about records that are created, modified, or deleted, set up an e-mail notification.

For instructions, see Sending Notifications.

4. Design how you want the reports of your portlets to appear.

For instructions, see Designing Portlet Reports.

5. If you want your report to display only a subset of records, create filters.

Suppose you have a master database of company sales. If you want to create a Western Region Sales report, you would create filters that select only sales information that relates to your Western regional offices.

For instructions on how to create a filter, see Creating Filters.

6. If you want to specify the order in which records display in your portlet's report page, add sort criteria.

For instructions, see Adding Sorting to Reports.

7. In the Portlet General Info page, click Next >>.
8. Click Save.

The Studio Portlet Wizard closes.

After you close the Studio Portlet Wizard, do not forget to save and name your portlet through the Portlet Editor by following steps 8 to 11 described in Creating Portlets.

### Creating Record Lookup Portlets

After you select the Studio Record Lookup template and click Edit in the Portlet Editor, the Studio Portlet Wizard displays. For instructions on how to navigate to the Studio Portlet Wizard, see steps 1 to 5 described in Creating Portlets.

1. Set the Record Lookup portlet to use an existing database.

The portlet does not provide your users a way to enter data, so you need to either use a database table already populated with data or create another portlet that allows users to add records to the database table (such as the Data Submission portlet). For instructions on using an existing database table for the Record Lookup portlet, see Using an Existing Database Table.

2. Design how you want the portlet's search form to appear.

This is where users type entries in search fields (such as the "first name" and "last name" fields in a phone directory). For instructions, see Designing Your Record Entry Forms.

3. If you want to notify certain users about records that are created, modified, or deleted, set up an e-mail notification.

For instructions, see Sending Notifications.

4. In the Portlet General Info page, click Next >>.
5. Click Save.

The Studio Portlet Wizard closes.

After you close the Studio Portlet Wizard, do not forget to save and name your portlet through the Portlet Editor by following steps 8 to 11 described in Creating Portlets.

### Creating Record Summary Portlets

After you select the Studio Record Summary template and click Edit in the Portlet Editor, the Studio Portlet Wizard displays. For instructions on how to navigate to the Studio Portlet Wizard, see steps 1 to 5 described in Creating Portlets.

1. Set the Record Summary portlet to use an existing database.

The portlet does not provide your users the means to enter data, so you need to either use a database table already populated with data or create another portlet that allows users to add records to the database table (such as the Data Submission portlet). For instructions on using an existing database table for the portlet, see Using an Existing Database Table.

2. In the Summary Report Display page, design your portlet's summary report page, which is available in Record Summary portlets, by doing the following:

1. Select the columns you want displayed in your summary report by selecting the check box next to the search field.
2. To change the layout of your search form, click Edit Summary Report Layout.

The Studio Page Layout Editor appears. For more information on Studio Page Layout Editor, see the online help for Studio.

3. When you are finished, click Next >>.

3. In the Portlet General Info page, click Next >>.
4. Click Save.

The Studio Portlet Wizard closes.

After you close the Studio Portlet Wizard, do not forget to save and name your portlet through the Portlet Editor by following steps 8 to 11 described in Creating Portlets.

## Designing Your Record Entry Forms

Some portlets—including the Calendar portlet, Data Submission portlet, and Record Browser portlet—include record entry forms that allow your users to create new records. You can design the appearance of your portlet's record entry form, which is the user interface that enables your users to enter data. The form lets users submit data to be stored as a record in the database table.

### Defining the Content of the Record Entry Form

To control what form fields appear in your record form, do the following in the Form Display page of the Studio Portlet Wizard (for information on how to access the wizard, see steps 1 to 5 in Creating Portlets):

1. Type a name for your entry form.
2. Select the input type where necessary.

The input type is the HTML input device (such as select menu and text box) that determines what each field will look like on your portlet's record entry form. Some data types have more than one input type available.

3. Select the fields you want to display in your entry form. A field with a check mark to the right of the field's input type will display in your record entry form.

Caution: | If you have already customized the layout of your entry form, do not add a field to your form by selecting the check box on this page. If you do so, your entry form will revert to the default layout. Instead, add new fields to your form in the Page Layout Editor.

4. If you selected more than one field to display in your entry form, click or , to change the order of the fields.

The entry form displays the fields in the same order that they appear on this page.

5. To change the layout of your form, click Edit Form Layout.

The Studio Page Layout Editor appears. For more information on the Studio Page Layout Editor, see the online help for Studio.

6. When you are finished, click Next >>.

### Designing the Appearance of the Record Entry Form

After you are done selecting which form fields should appear in the record entry form, you can design its appearance. The Studio Page Layout Editor, which you can access by clicking Edit Form Layout in the Form Display page of the Studio Portlet Wizard (for information on how to access the wizard, see steps 1 to 5 described in Creating Portlets), lets you change the appearance and content of the form. You can resize, add, and delete rows and columns; change the input type; add, delete, and rearrange fields; and format text. Use the toolbar to change the font, font size, font color, and text format. For more details on how to use the Page Layout Editor, see the Studio online help.

After you have finished designing your page layout, click Save and Close. If you want to cancel your changes and not save it, click on the upper right corner of the window. You cannot undo your actions. If you do not want to accept the changes you make, close the Page Layout Editor and launch it again.

Caution: | Do not make changes in the Form Display page of the wizard after you have made changes in the Studio Page Layout Editor. If you do, your entry form will revert to the default layout, and you will lose all the work that you have done in the Page Layout Editor. If you want to make changes, such as adding new fields, do so in the Page Layout Editor.

## Sending Notifications

You can set up your portlet to e-mail one or more recipients each time a record is created, modified, or deleted through a record entry form.

To set up e-mail notification, do the following in the Form Email Notification page of the Studio Portlet Wizard (for information on how to access the wizard, see steps 1 to 5 described in Creating Portlets):

1. Click + Add Email Notification Rule.

The notification rules appear.

2. In the Send Email When section, select which events you want your users to be notified of.

For example, if you want your users to know that a new record was created through the form, select New Record Created.

3. In the Send Email To section, select the recipients of the e-mail notification.

- To enter specific e-mail addresses, select Email Addresses, then enter the e-mail addresses.

Separate one e-mail address from another with commas.

- To send e-mail notifications to the creators or editors of the form, or all members of a data column, select Value of Column, then, from the drop-down list, select the column that contains users that should be notified.

For example, if you select an e-mail column (database field that contains e-mail data) that you created in the Database Column page of the wizard, all addresses within that data column will receive a notification e-mail.

4. When you are finished, click Next >>.

## Designing Portlet Reports

Some portlets—including Data Submission, Record Browser, and Record Lookup—have reports that allow your users to view records. You can design the appearance of your portlet's report, which is the user interface that lets your users view a collection of data at a glance.

### Designing the Portlet Report Display

To define the content in the portlet report, the portlet appearance, and the buttons displayed in the action bar, peform the following steps in the Report Display page of the Studio Portlet Wizard (for information on accessing the wizard, see steps 1 to 5 in Creating Portlets):

1. In the Report Name text box, type a name for the report page of your portlet.
2. If you want the report title to display on the title bar of the portlet, select Display Title Bar on Report.
3. Specify how many rows you want to display per page in your report. In the Rows Per Page text box, type a value.
4. Select action bar buttons that you want enabled on the portlet. The buttons enable your users to do the following:

- Show New Record Button: create a new record
- Show Export to Excel Button: save the report into an Excel file
- Show Delete Button: remove a record
- Show Search Button: search records.

5. Select the report columns you want displayed in your report. A report column with a check mark to its right will display in your report.
6. If you selected more than one field to display in your report, click or , to change the order of the fields.

The report displays the fields in the same order that they appear on this page.

7. To change your report layout, click Edit Report Layout.

This Studio Page Layout Editor displays. For more information on Studio Page Layout Editor, see the online help for Studio.

8. When you are finished, click Next >>.

### Creating Filters

Suppose you have a master database of company sales. If you want to create a Western Region Sales report, you could create filters that select only sales information that relates to your Western regional offices.

All portlets, except for polls and surveys, can be filtered.

To display only a subset of records or events in the report page of your portlet, create filters. Do the following in the Filters page of the Studio Portlet Wizard (for information on how to access the wizard, see steps 1 to 5 in Creating Portlets):

1. Click + Add Filter.

A filter rule appears.

2. In the Database Column drop-down list, select the column with the information that you want to appear in the portlet.
3. In the Comparison Operator drop-down list, select the comparison operator.

The comparison operator lets you select the relationship between the content of the database column and the comparison value. The comparison operator and the comparison value restrict what is filtered. For example, you can set the filter to apply to all the data in the "Date" database column that falls on or after ("on or after" is one of the comparison operators for the Calendar portlet) today ("today" is one of the comparison values available for the Calendar portlets).

For more information on comparison operators, see the online help for Studio.

4. In the Comparison Value text box, enter a value for this filter.

In the example above, where we set the comparison value to "Today," the filter will display all events that occur today and all days after that in the Calendar portlet.

5. If you have more than one filter, you must also specify how the filters work with each other, that is, if all the conditions defined in the rule should be met ("and") or if only one condition needs to be met ("or").

The filters are not nested, so they will be applied in the order displayed.

6. In the drop-down list between the check box and the Database Column drop-down list, select the operator (either "and" or "or").
7. When you are finished, click Next >>.

### Adding Sorting to Reports

You can specify the order in which records appear in your portlet's report page by adding sort criteria. Do the following in the Sorts page of the Studio Portlet Wizard (for information on how to access the wizard, see steps 1 to 5 in Creating Portlets):

1. Click + Add Sort.
2. In the Database Column drop-down list, select the column for which you want to apply a record display order.
3. In the Sort Direction drop-down list, select whether you want the records to be displayed in an ascending or descending order.
4. When you are finished, click Next >>.

## Designing the Portlet Window

After you create a Studio portlet, you can define and modify certain aspects of the portlet, such as its width, name, and description in the Portlet Editor. The Portlet Editor displays after you create a portlet object in the administration page. For step-by-step instructions, see steps 1 to 4 in Creating Portlets.

### Setting the Width of the Portlet

Under the Portlet Type/Size section of the Main Settings page of the Portlet Editor, select the width of the Studio portlet:

- Narrow: Narrow portlets can be added to narrow or wide columns in a portal page. Columns in a portal page extend to fit portlet content; therefore, if you choose narrow for a portlet that produces wide content, your portal might look awkward.
- Wide: Wide portlets can be added only to wide columns.

### Restricting the Distribution of the Portlet

You can allow the portlet to be added to both community pages and My Pages or you can restrict the portlet to community pages only. The security settings of a portlet also determines whether or not a portlet can be added to a portal page; for more information, see Securing Portlets.

To select how you want the portlet to be distributed, select one of the following options under the Portlet Type/Size section of the Main Settings page of the Portlet Editor:

- For My Pages or community pages: Allow users to add the portlet to My Pages or community pages.
- For community pages only: Allow users to add this portlet only to community pages.

### Suppressing Title Bars

If you do not want to display the title of the portlet when it is added to a page (that is, you want to keep title bars from appearing over the portlet), select Suppress Portlet's title bar under the Portlet Type/Size section of the Main Settings page of the Portlet Editor.

## Creating Studio Portlet Templates

You can create a Studio portlet template that other portlet creators can use as a model. The Studio wizards will guide you through the process.

To create a portlet template:

1. Create a portlet as you would like the template to be, and save the portlet in the folder that the portal administrator has created for storing Studio portlets. For instructions, see Creating Portlets.
2. Navigate to the folder where you saved the portlet you just created.
3. Click the portlet that you want to make into a portlet template.

The Studio Portlet Wizard displays.

4. In the navigation pane on the left side of the Studio Portlet Wizard, click Save Portlet.

The Finished page displays.

5. Click Save as Template.
6. Type a name for the Studio portlet template, and click OK.
7. In the Portlet Editor, click Finish.
8. In the Save into the selected folder below section of the Save In page, navigate to the folder that the portal administrator has created for storing Studio portlet templates.
9. In the Save As text box of the Save In page, type the name of your portlet template.
10. Click Save.
11. Click Close.