Visualizations plug-ins from apex-plugin
.com, the community plug-in site. This set
of dynamic-action, region-type plug-ins
includes one that generates an organization
chart from the EMP table.
To install the plug-ins, follow these steps:
From Application Builder, select the
1.
Employees application.
Click
2. Shared Components. Under User
Interface, click Plug-Ins.
Click
3. Import, click Browse, navigate to the
location where you unzipped the Masked
Text plug-in, and select item_type_
plugin_com_oracle_apex_masked_field
.sql. Click Next, click Next, click Install
Plug-In, and then click Apply Changes.
Click
4. Import, click Browse, navigate to
the location where you unzipped the Star
Rating plug-in, and select item_type_
plugin_com_oracle_apex_star_rating
.sql. Click Next, click Next, click Install
Plug-In, and click Apply Changes.
Click
5. Import, click Browse, navigate
to where you unzipped the Google
Visualizations plug-ins, and select
region_type_plugin_com_logica_apex_
googlevis_orgchart.sql. Click Next, click
Next, click Install Plug-In, and click
Apply Changes.
number you entered appears as Allen’s
phone number.
USING PLUG-INS
Now you’ll replace standard Oracle
Application Express components with the
item-type plug-ins and define a plug-in
region. To implement the item-type
plug-ins, follow these steps:
Click the
1. Employees application in
Application Builder, and click 2-Emp to
navigate to Page 2.
In the Page Rendering section, double-
2.
click the P2_PHONE_NUMBER item.
Under
3. Name, change the Display As
value to Masked Field [Plug-in]. Note
that the Settings section changes to show
custom attributes for Input Mask and
Placeholder. Click Apply Changes.
Double-click the
4. P2_RATING item.
Under Name, change the
5. Display As value
to Star Rating [Plug-in]. Under Settings,
CONCLUSION
Oracle Application Express plug-ins enable
you to extend your applications easily with
customizable components. Once you’ve
imported and installed plug-ins, you use
them in much the same way as you use standard Oracle Application Express components.
You can choose among plug-ins developed
by the Oracle Application Express team or
the community. And you can build your own
plug-ins by using PL/SQL. For information
on building plug-ins, see Patrick Wolf’s blog
posting “Oracle APEX 4.0: How to create a
Plug-in” at bit.ly/cJapC2.
David Peake (david
. peake@oracle.com)
is a principal product
manager in Oracle’s
Server Technologies
division. He has been
with Oracle since 1993.
NEXT STEPS
DOWNLOAD Oracle Application Express
oracle.com/technetwork/developer-tools/apex/
downloads
enter
5 for Number of Stars, and then
click Apply Changes.
To implement the region-type plug-in,
follow these steps:
From Application Builder, click the
1.
Employees application and navigate to
Page 1.
Click
2. Create, and select Region on this
page.
Select
3. Plug-ins, select Google OrgChart,
and then click Next.
Enter
4. Organization Chart for Title,
and click Next.
Select
5. Small for Size, select Yes for Allow
HTML, and click Next.
Click Examples. Copy the second block of
SQL code, paste it into Region Source, and
then click Create Region.
Click the Run button to run the application.
You can see the organization chart, shown in
Figure 1, at the bottom of the report page.
In the tabular portion of the report page,
click the edit link (the pencil icon) for the
employee named Allen to modify his record.
Click in the Phone Number field in the form,
and enter a phone number (including area
code) by typing its 10 digits. Note that the field
will not accept any nonnumeric characters;
the parentheses that surround the area code
and the hyphen that separates the phone
number’s first three digits from the last four
are supplied by the plug-in. Now hover the
cursor over the star icons in the Rating field
and click the fourth icon from the left to give
Allen a four-star rating. Figure 2 shows data
being entered into the Phone Number field
and a star being selected from the star icons.
Click Apply Changes. In the report, you can
now see 4 as Allen’s rating, and the phone
READ more Browser-Based
bit.ly/b4rudD
GET plug-ins
bit.ly/cov4Lv
apex-plugin.com
LEARN how to create an Oracle Application
Express plug-in
“Oracle APEX 4.0: How to create a Plug-in”
bit.ly/cJapC2
VISIT the Oracle Application Express
discussion forum
bit.ly/cfken4
