Database Reference
In-Depth Information
Figure 6-49.
Specifying process options
5. Ensure that
Scope
is set to
Current Page
, and click
Create Process
.
6. Run the application.
The search function should work when the user presses Enter and when the user
clicks the Go button. But let's go one more step and alter the Subject column so the
search term is highlighted in red:
1. Edit
Page 200
of the application.
2. Edit the
Report Attributes
again by right-clicking the
Tickets
re-
gion and selecting
Edit Report Attributes
.
3. Edit the
Subject
column by clicking the
Edit
icon.
4. In the
Column Formatting
region, enter
&P200_SEARCH.
in the
Highlight Words
element. Make sure you include the period (
.
) at the
end. If you forget it, the variable won't be parsed correctly and therefore
the value won't be highlighted.
This process uses APEX session state to indicate that the value the
user entered into
P200_SEARCH
should be used to highlight that same
text in the Subject column. Continue as follows:
5. Click
Apply Changes
.
6. Run the application, and test the search-highlight capability.
Now, when you enter a Search value, the matching rows are returned with the search
term highlighted in red. In just a few minutes, you've created a sortable, searchable re-
port for your Help Desk system. Let's look at what the report looks like behind the
scenes.
Figure 6-50
shows the components as seen from the Application Builder.