User interface defaults enables you to assign default user interface properties to a table, column, or view within a specified schema. When you create a form or report using a wizard, the wizard uses this information to create default values for region and item properties. Utilizing user interface defaults can save you valuable development time and has the added benefit of providing consistency across multiple pages in an application.
Because user interface defaults are associated with a table, you can use them with applications created using the form and report wizards.
Topics in this section include:
You can view tables or views utilizing user interface defaults by either navigating to the User Interface Defaults page or viewing the UI Defaults report in Object Browser.
Topics in this section include:
You can access the User Interface Defaults page:
Click the Application Builder icon on the Workspace home page.
Select an application.
On the Application home page, click Shared Components.
The Shared Components page appears.
Under User Interface, select User Interface Defaults.
The User Interface Defaults page appears.
The current schema displays to the right of the breadcrumb menu.
To select a new schema, make a selection from the Schema list.
To narrow the display, use the following controls at the top of the page and click Go:
Table/View - Enter a case insensitive query for a table or view name within the current schema.
View - Make a selection to filter the view:
Icons (default) displays each table or view as large icon.
Details displays each table or view as a line in a report, identifying the table or view name, the object type, and whether or not user interface defaults currently exist.
Display determines the number of items that display in the report.
Select a specific table or view by selecting the name.
The Table Defaults page appears.
If no user interface defaults exist, click Create User Interface Defaults.
To view the User Interface Details Report in Object Browser:
Navigate to Object Browser:
Click the SQL Workshop icon on the Workspace home page.
Click Object Browser.
Object Browser appears.
From the Object list, select either Tables or Views.
From the Object Selection pane, select an object.
Select the UI Defaults tab.
The User Interface Defaults report appears displaying the following information:
Column Name - Indicates the name of the column.
Label - Specifies the default label text for items in a form and the heading for columns in reports.
Report Sequence - Specifies the sequence of items in a report.
Report Display - Specifies how the column should be displayed in a report.
Tabular Form Display - Specifies how an item should display in a tabular form.
Form Sequence - Specifies the sequence of items in a form.
Form Display - Specifies how items in a form display.
To edit the user interface defaults, click Edit.
The Table Defaults page appears.
If no user interface defaults exist, click Create Defaults.
You define user interface defaults for a specific column by editing column attributes.
To edit column attributes:
Navigate to the Table Defaults page as described in "Viewing Tables or Views Utilizing User Interface Defaults".
The Table Defaults page appears. The following information displays at the top of the page:
Table/View Name identifies the name of the selected table or view.
Report Region Title and Form Region Title become the default title for all report or form regions. These names are modified versions of Table/View Name in which the first letter is capitalized and any underscores are replaced with spaces.
Column-level User Interface Defaults appear next. By default, a short report displays.
To view a complete report, click Detailed Report.
To edit select attributes for all displayed columns, click Grid Edit.
To edit a specific column, select the column name.
The column defaults appear. Column defaults are divided into two pages:
Column Definition
List of Values
The topics that follow describes how to edit specific attributes on these pages.
Column Definition is the default page that displays when you edit column attributes. The top of the page displays the selected schema, table or view name, and column name. Click View Database Column Definition to view details about a specific column.
This attribute is used in report and forms. Use Label to specify default label text for items in a form and the heading for columns in reports.
Available attributes include:
Display - Indicates if the column displays in a report. The default is Yes.
Display Sequence - Specifies the display sequence of items in a report. The default value is based on the column ID, which is based on the order of the columns in the table.
Display As - Specifies how the column should be displayed in a report.
Mask - Indicates if a mask should be applied against the data. This attribute is not applicable for character- based items.
Alignment - Specifies report alignment (left, center, or right). If the column is a number, the default is Right. Otherwise, the default is Left.
Searchable - Indicates whether or not the column should be searchable in reports. If the column is VARCHAR2 or CHAR, the default is Yes. If not, the default is No.
Group By - Indicates whether or not the column should be used for Group By and then the sequence of the grouping. The default is Yes.
Aggregate By - Indicates whether or not the column should be used for aggregation in reports and charts.
Available attributes include:
Display - Indicates if the column displays in a form. The default is Yes.
Display Sequence - Specifies the sequence of items in a form. The default is based on the column ID, which is based on the order of the columns in the table.
Display As - Indicates how items in a form display. The default selection is Text Field.
Mask - Indicates if a mask should be applied against the data in a form. Not used for character-based items.
Default Value - Specifies the default value associated with this column.
Width - Specifies the display width.
maxWidth - Specifies the maximum string length a user is allowed to enter in this item.
Height - Specifies the display height of an item.
Required - Used to generate a validation in which the resulting item must not be null. If resulting item is not null, select Yes.
Help Text - Becomes Item help. By default, this text is pulled from the column hint (if applicable).
You access the List of Values page by clicking the List of Values tab. The top of the page displays the selected schema, table or view name, and column name. Click View Database Column Definition to view details about a specific column.
The top of the page displays the selected schema, table or view name, and column name. Use the List of Values Type list to specify if the selected column will include a static or dynamic list of values. Once you select the type, you are prompted to enter either display value and return value pairs, or a list of values query.
You can view details about a specific column by accessing the Column Definition report. The Column Definition report displays the schema, table name, column name, data type, data length, and nullable, as well as any check constraints, primary and unique keys, and foreign keys that reference the column. A link to this report appears on both the Column Definition and List of Values pages.
To view the Column Definition report:
Navigate to the Table Defaults page as described in "Viewing Tables or Views Utilizing User Interface Defaults".
The Table Defaults page appears.
Select the column name.
Select View Database Column Definition.
Use the Compare Defaults report to monitor consistency in user interface design across all pages in a single application or multiple applications in the current workspace. Running the Compare Defaults report compares currently defined user interface defaults (or column attributes) against the item attributes set for forms, reports, and tabular forms.
To run the Compare Defaults report:
Click the Application Builder icon on the Workspace home page.
Select an application.
On the Application home page, click Shared Components.
The Shared Components page appears.
Under User Interface, select User Interface Defaults.
The User Interface Defaults page appears.
From the Tasks list, select Comparison Report.
The current schema displays to the right of the breadcrumb menu.
To select a new schema, make a selection from the Schema list.
Make selections from the following lists:
Table/View - Restricts the comparison to the selected table or view.
Column - Select a column in which to search for form, reports, and tabular forms.
Display - Select an attribute category.
Application - Select an application.
Click Go.
A report appears containing the following sections:
Form Pages Referencing the Selected Column
Report Regions Referencing the Selected Column
Tabular Form Regions Referencing the Selected Column
You export user interface defaults in the same way you export any related application file. Exporting user interface defaults from one Oracle HTML DB development instance to another involves the following steps:
Export the user interface defaults using the Export User Interface Defaults utility.
Import the exported file into the target Oracle HTML DB instance.
Install the exported file from Export Repository.
When you export user interface defaults, all user interface defaults for the selected schema are exported to a single script. The file contains an API call to create table hints by making calls to the application PL/SQL API. You can use this file to import user interface defaults to another database and Oracle HTML DB instance.