submit_search procedure

Related topics

Contained in package wwsbr_search api.

Call this procedure to generate content area search screens with a custom look and feel.

Results are returned in the form of an HTML page of results. These results will appear in the same format and layout as the Oracle Portal Content Area default search results screens.

procedure submit_search
(
p_search_terms in varchar2 default null,
p_search_operator in varchar2 default FIND_ANY,
p_caid in number default 0,
p_current_caid in number default null,
p_language in varchar2 default null,
p_folder_id in number default null,
p_folder_caid in number default null,
p_item_type_id in number default null,
p_include_child_folders in number default NO,
p_category_id in number default null,
p_perspective_id in number default null,
p_search_for_type in varchar2 default ALL_OBJECTS,
p_attribute_id wwsbr_type.array default wwsbr_type.empty,
p_attribute_name wwsbr_type.array default wwsbr_type.empty,
p_attribute_caid wwsbr_type.array default wwsbr_type.empty,
p_attribute_data_type wwsbr_type.array
default wwsbr_type.empty,
p_attribute_operator wwsbr_type.array
default wwsbr_type.empty,
p_attribute_value wwsbr_type.array
default wwsbr_type.empty,
p_style_id in number default null,
p_style_caid in number default null
);

Version: Oracle Portal 3.0.8
(Not available Oracle9iAS Portal 9.0.2)

Parameters:

p_search_terms

The terms to search for in the content area.

Datatype: in varchar2

p_search_operator

The type of search. Enter FIND_ANY or FIND_ALL.

Datatype: in varchar2
Default: FIND_ANY

p_caid

The ID of the content area to be searched.

Note: If you enter the value 0, all content areas are searched.

Datatype: in number
Default: 0

p_current_caid

The ID of the content area to be linked to, from the 'Content Area Home Link' which is displayed in the search results screen.

Datatype: in number

p_language

The language to search.

Datatype: in varchar2

p_folder_id

The ID of the folder to be searched.

Datatype: in number

p_folder_caid

The content area ID for the folder specified by the parameter p_folder_id .

Datatype: in number

p_item_type_id

An item type ID. When specified, only items of this item type are included in the search.

Note: The content area ID is assumed to be p_caid.

Datatype: in number

p_include_child_folders

If searching in a specific folder, this parameter specifies whether any child folders are also included in the search.

Datatype: in number
Default: NO

p_category_id

A category ID. When specified, only objects within this category are included in the search.

Note: The content area ID is assumed to be p_caid.

p_perspective_id

A perspective ID. When specified, only objects with this perspective are included in the search.

Note: The content area ID is assumed to be p_caid.

Datatype: in number

p_search_for_type

Specifies the type of objects to be included in the search, i.e. ALL_OBJECTS, ITEMS or FOLDERS.

Datatype: in varchar2
Default: ALL_OBJECTS

p_attribute_id

Specifies an array of attribute IDs. This allows you to search for specific attributes with specific values.

Datatype: in wwsbr_type.array
Default: wwsbr_type.empty

p_attribute_name

An array of attribute names.

Datatype: wwsbr_type.array
Default: wwsbr_type.empty

p_attribute_caid

An array of attribute content area IDs (for items based on custom type which has attributes).

Note: The values must either match p_caid or be 0.

Datatype: wwsbr_type.array
Default: wwsbr_type.empty

p_attribute_data_type

An array of attribute type values (such as 'url','text' etc.). Values for this can be found in WWSBR_ATTRIBUTES.DATA_TYPE

Datatype: in wwsbr_type.array
Default: wwsbr_type.empty

p_attribute_operator

An array of search operators The available options are CONTAINS_ALL, GREATER_THAN, LESS_THAN and EQUAL_TO.

Datatype: in wwsbr_type.array
Default: wwsbr_type.empty

p_attribute_value

An array of attribute values to search for, in the corresponding attribute.

Datatype: in wwsbr_type.array
Default: wwsbr_type.empty

p_style_id

The style ID used to render the search results.

Datatype: in number

p_style_caid

The content area ID for the style used to render the search results.

Datatype: in number

Version: Oracle Portal 3.0.8 (Not available Oracle9iAS Portal 9.0.2)
Parameters:
p_search_terms	The terms to search for in the content area. Datatype: in varchar2
p_search_operator	The type of search. Enter FIND_ANY or FIND_ALL. Datatype: in varchar2 Default: FIND_ANY
p_caid	The ID of the content area to be searched. Note: If you enter the value 0, all content areas are searched. Datatype: in number Default: 0
p_current_caid	The ID of the content area to be linked to, from the 'Content Area Home Link' which is displayed in the search results screen. Datatype: in number
p_language	The language to search. Datatype: in varchar2
p_folder_id	The ID of the folder to be searched. Datatype: in number
p_folder_caid	The content area ID for the folder specified by the parameter p_folder_id . Datatype: in number
p_item_type_id	An item type ID. When specified, only items of this item type are included in the search. Note: The content area ID is assumed to be p_caid. Datatype: in number
p_include_child_folders	If searching in a specific folder, this parameter specifies whether any child folders are also included in the search. Datatype: in number Default: NO
p_category_id	A category ID. When specified, only objects within this category are included in the search. Note: The content area ID is assumed to be p_caid.
p_perspective_id	A perspective ID. When specified, only objects with this perspective are included in the search. Note: The content area ID is assumed to be p_caid. Datatype: in number
p_search_for_type	Specifies the type of objects to be included in the search, i.e. ALL_OBJECTS, ITEMS or FOLDERS. Datatype: in varchar2 Default: ALL_OBJECTS
p_attribute_id	Specifies an array of attribute IDs. This allows you to search for specific attributes with specific values. Datatype: in wwsbr_type.array Default: wwsbr_type.empty
p_attribute_name	An array of attribute names. Datatype: wwsbr_type.array Default: wwsbr_type.empty
p_attribute_caid	An array of attribute content area IDs (for items based on custom type which has attributes). Note: The values must either match p_caid or be 0. Datatype: wwsbr_type.array Default: wwsbr_type.empty
p_attribute_data_type	An array of attribute type values (such as 'url','text' etc.). Values for this can be found in WWSBR_ATTRIBUTES.DATA_TYPE Datatype: in wwsbr_type.array Default: wwsbr_type.empty
p_attribute_operator	An array of search operators The available options are CONTAINS_ALL, GREATER_THAN, LESS_THAN and EQUAL_TO. Datatype: in wwsbr_type.array Default: wwsbr_type.empty
p_attribute_value	An array of attribute values to search for, in the corresponding attribute. Datatype: in wwsbr_type.array Default: wwsbr_type.empty
p_style_id	The style ID used to render the search results. Datatype: in number
p_style_caid	The content area ID for the style used to render the search results. Datatype: in number

Related topics
Content area API package	PDK PL/SQL API Reference - Home