id integer,
provider_id
integer,
name varchar2
(30),
title varchar2
(200),
short_title
varchar2(80),
description
varchar2 (200),
image_url
varchar2(1024), -- not used
thumbnail_image_url
varchar2(1024), -- not used
help_url
varchar2(1024), -- not used
timeout
integer,
timeout_msg
varchar2(200),
implementation_style
integer, -- not used
implementation_owner
varchar2(2000), -- not used
implementation_name
varchar2(2000), -- not used
content_type
integer,-- deprecated
api_version
integer, -- not used in 3.0
has_show_edit
boolean,
has_show_edit_defaults
boolean,
has_show_preview
boolean,
call_is_runnable
boolean,
call_get_portlet
boolean,
accept_content_type
varchar2(2000),
has_show_link_mode
boolean,
mobile_only
boolean,
show_behaviour_style
integer,
language
varchar2(30),
preference_store_path varchar2(2000),
created_on
date,
created_by
varchar2(256),
last_updated_on
date,
last_updated_by
varchar2(256),
pass_all_url_params
boolean
|
Version: Oracle Portal 3.0.6.6.5 or
later
|
|
Field names and definitions
|
|
id
|
A unique identifier used to locate the portlet in the provider
domain.
Note: A null value is not permitted.
Datatype: integer
|
|
provider_id
|
The ID of the provider that implements the portlet.
Datatype: integer
|
|
name
|
A unique identifier used to locate the portlet in the provider
domain. The name should not contain any spaces.
Note: A null value is not permitted.
Datatype: varchar2
|
|
title
|
The title string displayed when the portlet is displayed.
Notes:
-
This is the same as the title returned when the list of portlets
is requested.
-
The description returned is responsive to the language parameter
used when obtaining the wwpro_api_provider.portlet_record.
- A null value is not permitted.
Datatype: varchar2
|
|
short_title
|
A shorter version of the title (above). A maximum 80 characters
is allowed. If this parameter is not set, the long title is used
instead.
This field is available with
Oracle9iAS Portal version 9.0.2 or later.
Datatype: varchar2
|
|
description
|
A short description of the portlet.
Notes:
Datatype: varchar2
|
|
image_url
|
This field is not used by Oracle Portal 3.0 or later.
|
|
help_url
|
This field is not used by Oracle Portal 3.0 or later.
|
|
thumbnail_image_url
|
This field is not used by Oracle Portal 3.0 or later.
|
|
timeout
|
The number of seconds that should be spent attempting to execute
the portlet before a timeout operation occurs.
Notes:
Datatype: integer
|
|
timeout_msg
|
The message string to be presented when an execution timeout occurs.
The timeout message may not contain mobile (mobileMXL) or
desktop (HTML) markup.
Note: A null value indicates that the timeout message of the
provider should be used.
Datatype: varchar2
|
|
implementation_style
|
This field is not used by Oracle Portal 3.0 or later.
|
|
implementation_owner
|
This field is not used by Oracle Portal 3.0 or later.
|
|
implementation_name
|
This field is not used by Oracle Portal 3.0 or later.
|
|
content_type
|
The type of data the portlet produces, i.e. one of:
- wwpro_api_provider.CONTENT_TYPE_HTML
- wwpro_api_provider.CONTENT_TYPE_XML
- wwpro_api_provider.CONTENT_TYPE_MOBILE.
...or a combination of the above (by adding any of the above together).
This field is now deprecated.
Datatype: integer
|
|
api_version
|
The version of the API to which the portlet conforms.
Note: For Oracle Portal 3.0, this value must be wwpro_api_provider.API_VERSION_1.
Datatype: integer
|
|
has_show_edit
|
Indicates if the portlet implements an Edit (or Customize) page.
See show_portlet procedure.
Datatype: boolean
|
|
has_show_edit_
defaults
|
Indicates if the portlet implements an Edit Defaults page that
can be used by administrators to establish default display options
for all users.
See show_portlet procedure.
Datatype: boolean
|
|
has_show_preview
|
Indicates if the portlet implements a Preview portlet, i.e. one that
can be viewed from the Add Portlet screen and the Portlet Repository.
See show_portlet
procedure.
This field is available with
Oracle Portal version 3.0.9 or later.
Datatype: boolean
|
|
call_is_runnable
|
Indicates whether the portal must make calls to the provider's
is_portlet_runnable function for the portlet.
The provider's is_portlet_runnable function is called prior to
displaying a portlet in the Portlet Repository. For a public portlet
this function will always return true so there is no need to contact
the provider. In this case the provider should set the value for
call_is_runnable to false so that the provider's is_portlet_runnable
function is not called.
The default for this flag is true.
This field is available with Oracle Portal version 3.0.9 or later.
Datatype: boolean
|
|
call_get_portlet
|
Indicates whether the portal can use the portlet record data stored
in the Portlet Metadata Repository (PMR) instead of contacting the
provider for the portlet record. If the portlet record (specified
by provider id, portlet id, and language) returned by a provider
does not change, then the provider should set the value for call_get_portlet
to false.
This tells the portal to use the PMR instead of making calls to
the provider's get_portlet and get_portlet_list functions.
An example of when a provider would not want the
portal to use portlet metadata from the PMR, is when the value of
the portlet records is different for logged on users.
The default for this flag is true.
This field is available with Oracle Portal version 3.0.9 or later.
Datatype: boolean
|
|
accept_content_type
|
This is a comma delimited list of content_types whose values are
the types of content that the portlet produces.
For example, if a portlet can produce both HTML and MOBILEXML the
string would be: 'text/html,text/vnd.oracle.mobilexml'
This field is available with Oracle Portal version 3.0.9 or later.
Datatype: varchar2(2000)
|
|
has_show_link_mode
|
This portlet implements a Menu Link Label, SHOW mode method. If
the value is false, the portlet title is used for the Menu Link
Label.
This field is available with Oracle Portal version 3.0.9 or later.
Datatype: boolean
|
|
mobile_only
|
Indicates whether the portlet is available only to mobile devices.
If set to true, the portlet is only available for mobile devices,
i.e. it cannot be added to standard Web pages.
If set to false (default) the portlet can be displayed on both
Web pages and mobile devices (if the portlet can produce at least
mobilexml).
This field is available with
Oracle9iAS Portal version 9.0.2 or later.
Datatype: boolean
|
|
show_behaviour_style
|
Set to one of the SHOW behavior style constants.
Currently,
the only one defined is EXTERNAL_PORTLET.
When set to EXTERNAL_PORTLET (1) this indicates that the mobile
portlet's SHOW mode links outside of Oracle Portal, to a different
location.
This can be used in mobile devices for existing OracleiAS
Wireless applications that have not been fully converted to portlets.
Only the LINK mode needs to be implemented, specifying the URL for
the actual portlet content without going via Oracle Portal.
Although this is not recommended, it does allow current OracleiAS
Wireless applications to be integrated with Oracle Portal with minimum
effort.
Normally this parameter is set to 0 to indicate normal operation,
i.e. that the mobile portlet has a SHOW mode.
This field is available with
Oracle9iAS Portal version 9.0.2 or later.
Datatype: integer
|
|
language
|
The language in which the strings are returned.
Note: A null value is not permitted.
Datatype: varchar2
|
|
preference_store_path
|
The base preference store path where the provider has stored the
portlet customization information.
Notes:
-
This path is used when exporting portlets.
-
When exporting a page, the reference path for the portlet is
appended to the preference_store_path to reconstruct the preference
path for portlet customizations.
- If the value of this field is null, no preference store data
is exported.
Datatype: varchar2
|
|
created_on
|
The date the record was created.
Datatype: date
|
|
created_by
|
The user who created the record.
Datatype: varchar2
|
|
last_updated_on
|
The most recent date the record was changed.
Datatype: date
|
|
last_updated_by
|
The user who most recently changed the record.
Datatype: varchar2
|
|
pass_all_url_params
|
Indicates parameter passing behavior in the portlet.
If true, the portlet passes all parameters on the URL to the portlet
(as per Oracle Portal 3.0.9).
If false, the portlet is only passed parameters intended for that
portlet. This is the default behavior in Oracle9iAS Portal
9.0.2 (V2 PDK-Java).
Note: The default value for database providers is true,
since there is no V2 provider API.
This field is available with
Oracle9iAS Portal version 9.0.2 or later.
Datatype: boolean
|
| |
|
The portlet table structure is returned after calling the portlet listing
functions. It contains a table of portlet_records.