6.7 Using the Find Icon

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

Description of GUID-2F120F48-A127-4E83-B6BD-A57AE9E83297-default.png follows
Description of the illustration GUID-2F120F48-A127-4E83-B6BD-A57AE9E83297-default.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.

Topics:

6.7.1 Using the Find Icon

To use the Find icon:

  1. Click the Find icon.
  2. Click one of the following tabs:

6.7.2 Searching for Items

In App 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 GUID-2F120F48-A127-4E83-B6BD-A57AE9E83297-default.png follows
    Description of the illustration GUID-2F120F48-A127-4E83-B6BD-A57AE9E83297-default.png

    The Items Finder appears.

    Description of GUID-A5101A8E-9DF6-4AC9-BDB9-6E4BCE36B0E1-default.png follows
    Description of the illustration GUID-A5101A8E-9DF6-4AC9-BDB9-6E4BCE36B0E1-default.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.

  2. To edit a specific item, navigate to the appropriate item.

See Also:

"Understanding Page-Level Items"

6.7.3 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.
  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.

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

6.7.4 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.
  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.

6.7.5 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.
  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.

  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

6.7.6 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.
  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.

  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

6.7.7 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.
  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