You can navigate to the Create Query page by selecting the Query row icon from the Personalization Properties table in the Personalize page when you personalize a table region. This page allows you to specify sort information and search criteria for a table region to filter the data that displays in that table.
Note: Any search criteria that a user enters for a field from the table's Search panel overrides any search filter on that field that you create from the Create Query page. For example, suppose you specify the following data filter for a table using the Create Query page:
Name contains Jason
Email contains Oracle
If a user then displays the page containing the table and enters the value 'Peter%' for the Name field in the Search panel, the table returns query results for:
Name like 'Peter%'
Email like 'Oracle%'
In the Data Filter region, 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 or Show table data when any condition is met = Match Any.
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.
You can also select a column from the Add Another poplist and choose Add to add more search criteria to your filter.
Additional Information: Only columns whose Search Allowed property is set to True are displayed in the Add Another poplist. If this property is initially set to false and you want to be able to search on this column, you must first create an admin-level personalization of the table region that updates the Search Allowed property for the column (item) to True.
If you leave the search criteria blank for a column, the filter does not search on that column.
In the Sorting region, 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.
Additional Information: Only columns whose Sort Allowed property is set to Yes are displayed in the Column Name poplist. If this property is initially set to no and you want to be able to sort on this column, you must first create an admin-level personalization of the table region that updates the Sort Allowed property for the column (item) to yes.
For each sort column, you must specify whether to sort in ascending or descending direction.
When you are done creating the data filter and specifying your sort settings, choose Apply to apply your changes and return to the Personalize page. The Query row of the Personalization Properties table should now display a Personalize icon (pen). The change in icon indicates that a data filter now exists at that personalization level and you can select the icon to view or update the existing data filter again.
Additional Information: When you personalize a table region at various personalization levels and for each of those levels, specify search criteria for different columns in the table region, the search criteria are combined with a logical AND for the cumulative personalizations. The same is true if you personalize a table region at various personalizations levels, with search criteria for the same columns in the table region. The search criteria defined in all levels are AND-ed together.
Additional Information: If the page metadata is shipped with the table containing first, second and third sort sequence columns already set, administrators may have to perform an additional step before changing the sort sequence of the table.
If any of the seeded first, second and third sort columns are not going to be used again as in personalized sort columns (either as first, second or third sort) each of these columns should be made non-sortable columns. This can be done by personalizing individual items and setting the "Sort Allowed" property to "no".
For Example, if the table is shipped with -
| Column / Attribute | Sort Sequence | Sort Order |
| EmpNo | First | Ascending |
| Ename | Second | Ascending |
| Sal | Third | Descending |
And an Administrator would like to personalize to
| Column / Attribute | Sort Sequence | Sort Order |
| Mgr | First | Ascending |
| Sal | Second | Ascending |
| Desg | Third | Descending |
Then the EmpNo and Ename columns should be personalized to "Sort Allowed - no".