Go to primary content
Oracle® Application Express Application Builder User's Guide
Release 5.0
E39147-04
  Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
 
Next
Next
 

7.7 Using the Find Icon

This section describes how to use the Find icon in Component View.

7.7.1 About the Find Icon

The Find icon resembles a flashlight and displays on many pages in Application Builder including Application home page, Component View, Shared Components, and the Edit Application Definition.

Description of find_icon.png follows
Description of the illustration find_icon.png

Clicking the Find icon displays a dialog that enables you to search for items, pages, queries, tables, PL/SQL code, or images, view debug reports, view session state, and view errors.

7.7.2 Using the Find Icon

To use the Find icon.

  1. Click the Find icon.

    Description of find_icon.png follows
    Description of the illustration find_icon.png

    The Items Finder appears.

  2. Click one of the following tabs:

7.7.3 Searching for Items

In Application Builder, an item can be a text field, text area, password, select list, check box, and so on. You can use the Item Finder to search for items within the current application or within the schema associated with the workspace.

To search for items:

  1. Click the Find icon.

    Description of find_icon.png follows
    Description of the illustration find_icon.png

    The Items Finder appears.

    Description of find_icon2.png follows
    Description of the illustration find_icon2.png

    A search bar displays at the top of the page and contains the following controls:

    • Select columns to search icon - Resembles a magnifying glass. Click this icon to narrow your search to specific columns. To search all columns, select All Columns.

    • Text area - Enter case insensitive search criteria (wildcard characters are implied) and click Go.

    • Go button - Executes a search.

    • Actions menu - Clicking the icon displays the Actions menu. Use this menu to customize an interactive report. See "About the Actions Menu."

  2. To edit a specific item, navigate to the appropriate item. See "Understanding Page-Level Items."

7.7.4 Searching for Pages

A page is the basic building block of an application. You can use the Pages Finder to search for pages within the current application or within the schema associated with the workspace.

To search for a page:

  1. Click the Find icon.

    Description of find_icon.png follows
    Description of the illustration find_icon.png

  2. Click the Pages tab.

    The Pages Finder appears. A search bar displays at the top of the page and contains the following controls:

    • Select columns to search icon - Resembles a magnifying glass. Click this icon to narrow your search to specific columns. To search all columns, select All Columns.

    • Text area - Enter case insensitive search criteria (wildcard characters are implied) and click Go.

    • Go button - Executes a search.

    • Actions menu - Clicking the icon displays the Actions menu. Use this menu to customize an interactive report. See "About the Actions Menu."

  3. To link to the Items page, click the page number.

7.7.5 Searching for Queries

You can use the Queries Finder to locate a query within your application or within the schema associated with the workspace.

To search for a query using the Queries Finder:

  1. Click the Find icon.

    Description of find_icon.png follows
    Description of the illustration find_icon.png

  2. Click the Queries tab.

    The Queries Finder appears. A search bar displays at the top of the page and contains the following controls:

    • Select columns to search icon - Resembles a magnifying glass. Click this icon to narrow your search to specific columns. To search all columns, select All Columns.

    • Text area - Enter case insensitive search criteria (wildcard characters are implied) and click Go.

    • Go button - Executes a search.

    • Actions menu - Clicking the icon displays the Actions menu. Use this menu to customize an interactive report. See "About the Actions Menu."

  3. To link to the Items page, click the page number.

7.7.6 Searching for Tables

You can use the Tables Finder to view tables within the schema associated with the workspace.

To view tables associated within the current schema:

  1. Click the Find icon.

    Description of find_icon.png follows
    Description of the illustration find_icon.png

  2. Click the Tables tab.

    The Tables Finder appears. A search bar displays at the top of the page and contains the following controls:

    • Select columns to search icon - Resembles a magnifying glass. Click this icon to narrow your search to specific columns. To search all columns, select All Columns.

    • Text area - Enter case insensitive search criteria (wildcard characters are implied) and click Go.

    • Go button - Executes a search.

    • Actions menu - Clicking the icon displays the Actions menu. Use this menu to customize an interactive report. See "About the Actions Menu."

  3. Select a table name.

    A table definition appears.

    This report displays the column names, data type, length, precision, and scale and the SQL necessary to re-create the table appears at the bottom of the page.


See Also:

"Managing Tables" in Oracle Application Express SQL Workshop Guide

7.7.7 Using the PL/SQL Finder

You can use the PL/SQL Finder to locate and view details about stored procedures, functions, and packages associated with each object within the schema associated with the workspace.

To search for PL/SQL code in the current schema:

  1. Click the Find icon.

    Description of find_icon.png follows
    Description of the illustration find_icon.png

  2. Click the PL/SQL tab.

    The PL/SQL Finder appears. A search bar displays at the top of the page and contains the following controls:

    • Select columns to search icon - Resembles a magnifying glass. Click this icon to narrow your search to specific columns. To search all columns, select All Columns.

    • Text area - Enter case insensitive search criteria (wildcard characters are implied) and click Go.

    • Go button - Executes a search.

    • Actions menu - Clicking the icon displays the Actions menu. Use this menu to customize an interactive report. See "About the Actions Menu."

  3. To view additional details, select the procedure, function, or package name.

    The procedure, package, or function name appears and additional information including the owner, source name, source type, return type, argument names, data types, and IN/OUT parameters.


See Also:

"Managing Database Objects with Object Browser" in Oracle Application Express SQL Workshop Guide

7.7.8 Searching for Images

You can use the Images Finder to identify images available to the current application.

To view available images:

  1. Click the Find icon.

    Description of find_icon.png follows
    Description of the illustration find_icon.png

  2. Click the Images tab.

    The Images Finder appears.

  3. From Show, select the type of images to view. Options include:

    • Standard Images

    • Workspace Images

    • Application Images


See Also:

"Managing Database Objects with Object Browser" in Oracle Application Express SQL Workshop Guide