| 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

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

Back to top
The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio