Search Bar in Tabular Form
PURPOSE: The search button in tabular form is helpful to identify the exact data in the tabular form, that will act like a filter in interactive report shows the particular values what we enter in that search field. Steps To Follow: Step 1: Create Text Field in the Label of Search with Search Button on above Tabular Form. Step 2: Create a Tabular Form where we need to search record. Step 3: Add the following query in region source of the Tabular Form based on the columns need to search Region source: Select Column1, Column2, Column3, Column4, . . . FROM table_name WHERE upper(Column1) = upper(:PXX_SEARCH) or upper(Column2) = upper(:PXX_SEARCH) or upper(Column3) = upper(:PXX_SEARCH) upper(Column4) = upper(:PXX_SEARCH) or :PXX_SEARCH is null . . . Step 4: In that search field item modify ‘Submit when enter pressed ==> YES’ for quick access of values in tabular form.
Read More