Skip Headers
Oracle® Application Express Application Builder User's Guide
Release 3.2

E11947-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

Using the Find Icon

You can search for items, pages, queries, tables, PL/SQL code, images, or cascading style sheets by clicking the Find icon on numerous pages within Application Builder.

This section contains the following topics:

About the Find Icon

The Find icon resembles a flashlight and often displays to the right of the Run Page and Edit Page icons as shown in the following illustration. The Find icon displays on many pages in Application Builder, including the Application Home page, the Page Definition, application attribute pages, and numerous pages for creating and managing shared components.

Description of find_icon.gif follows
Description of the illustration find_icon.gif

About the Item Finder

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 an item using the Item Finder:

  1. Click the Find icon.

    The Item Finder appears.

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

    • Search. Search for an item name. Enter case insensitive keywords in the Search field and click Go. To view all items, leave the Search field blank and click Go.

    • Page. Search for pages that contain items. Enter a page number in the Page field or select a page number from the list and click Go. To view all pages containing items, leave the Page field blank and click Go.

    • Display. Determine how many rows display in the resulting report. To change the number of rows that display, make a selection from the Display list and click Go.

    A Item Finder report appears, displaying the item name, label, item type, and associated page number.

    Description of item_finder.gif follows
    Description of the illustration item_finder.gif

  2. To restrict the report to display just items on a specific page, click the appropriate page number in the far right column.

    Note the page number you select appears in the Page field at the top of the page. To expand the view to all pages, delete the page number in the Page field and click Go.

  3. To edit a specific item, navigate to the appropriate item. See "Understanding Page-Level Items" and "Using the Edit All Icon to Edit Multiple Items".

Using the Page Finder

A page (or Page Definition) is the basic building block of an application. You can use the Page 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. Select the Pages tab.

    The Page Finder appears.

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

    • Search. Search for a page name. Enter case insensitive keywords in the Search field and click Go. To view all pages, leave the Search field blank and click Go.

    • Display. Determine how many rows display in the resulting report. To change the number of rows that display, make a selection from the Display list and click Go.

    The Page Finder report appears, displaying the page number, page name, page alias, title, tab set, and counts of the number of items and regions on the page.

    Description of pages_finder.gif follows
    Description of the illustration pages_finder.gif

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

Using the Query Finder

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

To search for a query using the Query Finder:

  1. Click the Find icon.

  2. Select the Queries tab.

    The Query Finder appears.

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

    • Search. Search for query statements. Enter case insensitive keywords in the Search field and click Go. To view all queries, leave the Search field blank and click Go.

    • Display. Determine how many rows display in the resulting report. To change the number of rows that display, make a selection from the Display list and click Go.

    The Query Finder report appears, displaying the page number, page name, the region containing the query, and the query source.

    Description of query_finder.gif follows
    Description of the illustration query_finder.gif

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

Using the Table Finder

You can use the Table 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. Select the Tables tab.

    The Table Finder appears.

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

    • Search. Search for a table name. Enter case insensitive keywords in the Search field and click Go. To view all tables, leave the Search field blank and click Go.

    • Display. Determine how many rows display in the resulting report. To change the number of rows that display, make a selection from the Display list and click Go.

    • Views. Select the Views check box and click Go to include views in the resulting report.

    The Table Finder report appears displaying the table name, the number of rows, and the object type.

  3. Select a table name.

    A table definition appears on the right side of the page.

    Description of table_finder.gif follows
    Description of the illustration table_finder.gif

    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 and Utilities Guide

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. Select the PL/SQL tab.

    The PL/SQL Finder appears.

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

    • Search. Search for procedure, function, or package names. Enter case insensitive keywords in the Search field and click Go. To view all, leave the Search field blank and click Go.

    • Display. Determine how many rows display in the resulting report. To change the number of rows that display, make a selection from the Display list and click Go.

    • Procedures, Functions, or Packages. Select at least one check box and click Go to include procedures, functions, and packages in the report. You must select at least one check box to return results.

    The PL/SQL Finder report appears.

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

    Description of plsql_finder.gif follows
    Description of the illustration plsql_finder.gif

    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 and Utilities Guide

Using the Images Finder

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

To view available images:

  1. Click the Find icon.

  2. Select the Images tab.

    The Images Finder appears.

    Description of image_finder.gif follows
    Description of the illustration image_finder.gif

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

    • Search. Search for image names. Enter case insensitive keywords in the Search field and click Go. To view all, leave the Search field blank and click Go.

    • Icon Size. Select the size of icon you want to search for and click Go.

    • Display. Determine how many rows display in the resulting report. To change the number of rows that display, make a selection from the Display list and click Go.

    • Columns. Select the number of columns to view per row and click Go.

  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 and Utilities Guide

Using the CSS Finder

You can use the CSS Finder to view cascading style sheets that are available to any application regardless of theme.

To view available cascading style sheets:

  1. Click the Find icon.

  2. Select the CSS tab.

    The CSS Finder appears.

    Description of css_finder.gif follows
    Description of the illustration css_finder.gif

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

    • Search. Enter case insensitive keywords in the Search field and click Go. To view all, leave the Search field blank and click Go.

    • Category. Select a CSS category and click Go. Available options include:

      • Absolute Sizes

      • Anchor Tags

      • Relative Sizes

    • Display. Determine how many rows display in the resulting report. To change the number of rows that display, make a selection from the Display list and click Go.