To specify general properties:The Create Saved Search page is identical to the Update Saved Search and Duplicate Saved Search pages, except that the fields in the latter pages are pre-populated with settings from the selected saved search.
When you save a saved search of a query region that is a shared region (that is, the query region was actually defined in some other base region, and the current region shares or extends that base region), the saved search is saved on the current instance of the region you are using, and not on the base region. So if another page extends the same base region, you will not see your saved search on that other page.
In addition to the default behavior, developers can set a property on the query region that allows a saved search that you create to be stored directly on the shared region, rather than as a per instance saved search. This allows you to see the personalized saved search in all pages where the query region is shared.
Note: This option applies only to new query regions that are created with OA Framework Release 12. Your application documentation will indicate when this behavior has been enabled for a given Release 12 query region.
Attention: Administrators should refrain from creating a per instance saved search on a shared query region that has this feature enabled. In other words, when you create a personalization, you should set the scope of the personalization context to the shared region and not to the page itself.
Administrators are able to seed user-level saved searches that apply to either the base region of a shared region, or to a specific instance of a shared region (per-instance saved search).
As a user, you can see the list of all Admin-seeded per-instance saved searches for a region in the Saved Searches poplist of the Saved Search panel, as well as all your own personalized saved searches. Although you cannot modify an Admin-seeded saved search, you can always create a duplicate of any Admin-seeded per-instance saved search and mark the duplicate as your default saved search.
To specify general properties:Enter a user-friendly Saved Search Name to identify your personalization.
Select the number of rows of data you wish to display in the table in your personalized saved search.
Check Set as Default if you wish to make this saved search your default saved search. There can only be one default saved search at any time. If you check Set as Default for the current saved search, than any saved search that you previously marked as the default becomes unmarked.
Additional Information: If you wish to mark a predefined seeded personalized saved search as your default, create a duplicate of the seeded saved search, and check Set as Default for the duplicate search.
Additional Information: If an "Oracle-seeded" end user saved search and an "Admin-seeded" end user saved search of the same region are both marked as defaults, the "Admin-seeded" end user saved search takes precedence and is displayed as the default. If, however, you also create your own personalized saved search of the same region and set it as the default, then your personalized saved search takes precedence over both levels of seeded saved searches and becomes your default. See Saved Searches for additional information.
Enter a description for this personalized saved search.
To specify column properties:The columns of the table region appear in the Available Columns list. Edit the Column Properties to specify the columns you wish to display and the order in which to display them.
Select an item from the Available Columns or Columns Displayed list and use the buttons between these lists to shuttle the selected item between the two lists.
Note: Columns that are required fields in a page appear with an asterisk (*) and cannot be removed from the Columns Displayed list.
Following is an example of an advanced table with two levels of column spans:
Each of the columns in the top row (labeled "Group X" and "Group Y") spans two columns in the second row (labeled "Group A" and "Group B" in both cases). Each "Group A" column in turn spans "Column 1" and "Column 2" below it, while each "Group B" column spans "Column 3" and "Column 4."
If the region you are personalizing is an Advanced Table that displays column spans, as shown in the example, the columns listed in the Available Columns and Columns Displayed shuttle will have the entire hierarchy of column group names appended to each column name. This ensures that you hide/show the correct column, especially in the case where multiple columns of the same name may exist within different column groups. For the example, the columns shown in the Available Columns and Columns Displayed lists would be:
Group X: Group A: Column 1 Group X: Group A: Column 2 Group X: Group B: Column 3 Group X: Group B: Column 4 Group Y: Group A: Column 1 Group Y: Group A: Column 2 Group Y: Group B: Column 3 Group Y: Group B: Column 4
Once you are satisfied with the items to display, select an item from the Columns Displayed list and use the buttons to the right of the list to reorder the sequence in which the item appears.
Choose Rename Columns / Totaling to alter other settings for your columns.
To specify sort settings:You can specify up to three levels of sorting for your data. Select a column from the Column Name poplist for each level of sorting you wish to perform.
For each column to sort, you must specify whether to sort in ascending or descending order.
Additional Information: Only columns whose User Personalization property is set to True by the developer or administrator, appear in the Column Name poplist.
To filter data in the table:You can filter the data that is displayed in the table based on criteria that you specify.
Indicate how you want the filter to match your search conditions by selecting one of the following radio buttons:
Show table data when all conditions are met = Match All.
Show table data when any condition is met = Match Any.
The first four columns of the table are listed for you to specify search criteria. Using the poplist following the column name, choose a search condition and enter a value to search for in that column.
As of Release 12.2.4, in addition to the search conditions, "greater than", "is", "is not" or "less than", you can now specify "is not (include blanks)" to also return null values from a search.
Select a column from the Add column poplist and choose Add to add more search criteria to your filter.
Additional Information: Only columns whose Search Allowed property is set to True by the developer or administrator, appear in the Add Another poplist.
If you leave the search criteria blank for a column, the filter will not search on that column.
To save your personalized saved search:When you are done personalizing your saved search of the table, choose Apply or Apply and View Results. Choosing Apply saves the personalized saved search and returns you to the Personalize Saved Searches page. Choosing Apply and View Results saves the search you just created or updated, and returns you to the application page where the saved search you just created is set as the current personalized saved search.
If you choose Revert to revert to default settings, the following occurs depending on the page you are using:
Create Saved Search page - the page defaults to the pre-seeded display settings and no query options are set.
Update Saved Search or Duplicate Saved Search page - the page defaults to the display settings and query options of the saved existing saved search you are trying to update or duplicate.