Your path must be Path: Page Groups > <YourName> Oracle By Example > Pages .

Click the Edit link to the right of the <YourName> OBE Home Page link.

Note: If you are not using the OmniPortlet that is readily available and have installed the OmniPortlet in another OracleAS Portal instance, then you can locate your OmniPortlet in the Portlet Staging Area. By default, all newly registered providers and portlets are available in the Portlet Staging Area in the Portlet Repository.

Create a new connection by using the details given in the following table:

Note: You must specify appropriate values in the Connection String field to connect to a database.

You see the Connection Successful message in the Connection Test Result window.

Click OK to return to the OmniPortlet wizard page.

The new Connection Name now appears in the Connection section.

In the SQL section, enter the following statement:

select * from scott.dept

Click Close to close the Query Results window.

Click Next.

You can use this page to filter and order the data that appears in your portlet. An OmniPortlet supports filtering of data in two areas:

Filtering at the data source itself by specifying the details on the Source page

Filtering at the middle tier by using the conditions specified on the Filter page

Note: It is always more efficient to filter and sort the data at the data source because you can streamline the process by retrieving only the necessary data. The best practice to use the middle-tier filtering is when the data source does not support any filtering or sorting capability (for example, a spreadsheet).

In the Layout Style section, select the Form layout for the portlet data.

In the Caching section, select the Don’t Cache the Portlet Content option button. When you select this option, the OmniPortlet does not cache the portlet content and displays dynamic content.

In the Column Layout section, enter the details as shown in the following table:

The OmniPortlet displays the results of your SQL query on your portal page.

In the Column Layout section, define an action for the DEPTNO column.

Select Event1 from the Action list.

This setting triggers a predefined event called Event1 for the Department Number field.

OmniPortlet events enable you to generate interportlet communication. Now, when Event1 is raised, the department value is passed to the page parameter, Param1, on the target page. Later, you pass this page parameter, Param1, to another OmniPortlet on the same page

Later in this lesson, you configure another instance of the OmniPortlet to receive a value from a public portlet parameter and send this value to its data source. You personalize this OmniPortlet by mapping its portlet parameter to the page parameter, Param1, so that the second OmniPortlet responds to this raised event.

You use this page to filter the data that appears in your OmniPortlet. You configure this page later in the lesson.

Click Next.

In the Layout Style section, select the Tabular layout for the portlet data.

Click Next.

In the Column Layout section, enter the details as shown in the following table:

Click Finish.

Access the Source tab. In the Portlet Parameters section, enter the following details:

You can use the Portlet Parameters section to add interactivity to the OmniPortlet. You can also parameterize the credential information used to access secure data.

Enter the following filter condition in the Conditions section:

By specifying the filter value to ##Param1##, you set the portlet to use the value of Param1 for the value of the DEPARTMENT_NO column. For example, if Param1 is 10, then the filter condition evaluates to DEPARTMENT_NO Equals 10.

In the Order Section, select EMPLOYEE_ID as the first column to order the results by.

Select Ascending for the sort order.

Click the View tab.

Enter Employee Details in Department ##Param1## in the Header Text field.

Ensure that the Show Header Text check box is selected and the Show Footer Text is deselected.

Click OK.

You have specified 10 as the default value for the portlet parameter, Param1. The OmniPortlet uses the value of portlet parameter to filter the data. Now, you see the details of employees in Department 10.

Note: The Parameters and Events tabs show for all pages that are owned by a page group that has parameters and events enabled. Parameters and events are enabled by default in OracleAS Portal.

You use page parameters to declare a public data input interface to a page. This interface can then be used to transmit data from a page to one or more portlets residing on the same page or on different pages.

In the Default Value field, enter 30. Enter This is a page param. in the Description field.

Later in this lesson, you see how parameter values that are passed from the page override the default values of the portlet parameter for the Employee Details OmniPortlet.

In the Portlet Parameter Values section, click the Key Indices: OmniPortlet link that contains the portlet parameters. If you created a new page specifically for the steps in this lesson, then this portlet is the second instance of Key Indices: OmniPortlet in the list.

When defining the XML OmniPortlet, you created a public portlet parameter, Param1 . You can use this portlet parameter to receive a value from the page.

Next to Param1, select Page Parameter from the list. This renders another list.

Select department.

The portlet parameter Param1 is now mapped to the department page parameter you created in the previous steps.

Note: If you are not able to access the OmniPortlet event in the Page Properties, refresh your OmniPortlet Provider. To refresh your OmniPortlet Provider, access the Navigator in Portal. Click the Providers tab. Click the Locally Built Providers link. You should be able to see OmniPortlet Provider. Click the Refresh link.

You specified this event in the Department Details OmniPortlet. Now, you have to specify what should happen when this event is raised. In this lesson, you refresh the OBE Home Page with the new parameter value.

The right side of the page refreshes where you can set the event information.

Click the List of Values icon on the right of the Go to page field.

Click the plus icon to expand your page group.

When you select your portal page, the page parameters are displayed in the Page Input section.

Next, you must specify the values that must be passed to the page from the output of the portlet.

In the Page Input section, select Event Output in the list.

Select Event1Param1 from the second list.

This maps the event output to the department page parameter. You have now set the Department page parameter to display the contents of the OmniPortlet event parameter, Event1Param1.

Click the View Page link in the upper right corner to preview the page and test your changes.

Click the browser’s Back button, or the Edit smart link to return to Edit mode on the page.

Click Show Methods to see what methods are available from this Web service.

Note: The methods exposed in a Web service enable you to interact with the Web service. Some methods expose parameters.

Click Show Parameters to check whether the OTNDeptEmp.getEmpXML method accepts any parameters.

You could note that the selected method does not accept any parameters.

Now, click Next to filter the data returned from the data source. In this lesson, you restrict the returned data to only one department from the Employee table.

In the Conditions section, select DEPTNO from the Column list, Equals from the Operator list, and enter 20 for the Value field.

Deselect the Show Header Text check box.

Enter OmniPortlet using Web services as data source in the Show Footer Text field.

Ensure that the Show Footer Text check box is selected.

In the Tabular Style section, select the Alternating option button.

In the Column Layout section, enter the details as shown in the following table:

You can see the details of all the employees in department 20 being dispalyed in a tabular format.