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.
It's interesting to read blog about punchout cxml.
ReplyDeletePunchout CXML
Thank You.!
ReplyDeletecXML Punchout
Usually I never comment on blogs but your article is so convincing that I never stop myself to say something about it. You’re doing a great job Man Oracle course
ReplyDeleteThanks My Dear !
ReplyDelete