Pages H

Description

Displays the name of the page used to identify the page in menus and lists. Any alpha-numeric string may be used.

Displays the page type of the selected record.

• Chart — Pages of this type display data in a visual format for easier interpretation. Some types include Line, Bar, and Pie.
• Dashboard — Pages of this type contain Layouts which allow the Designer to render several Chart pages at once depending on the configured layout.
• Dynamic — Pages of this type are the standard pages of the framework that allow for configured column controls and data manipulation.
• Header Detail — Pages of this type display two linked pages in parent and dependent panes.
• Report — Pages of this type are used as read-only renderings of data similar to Dynamic pages. With this page type, an automatic “Reports” link is added to the applications switchboard and each report page is shown as a page link.
• Service — Pages of this type are configured to run events on a pre-defined interval. Both unit of measurement and quantity of measurement can be defined. These run in the background.
• Static — Pages of this type allow the Designer to embed an external resource, whether a file, .aspx page, or other web resources.

Displays the name of the table or view where changes will be stored.

A table must be defined on all Dynamic pages.

A view can be used to update a table in another database. When using this advanced method, the key field(s) for the foreign table must be defined in Column properties.

Refer to Assign Column Properties for more information.

Click to display the Page Columns page where Control Properties are used to control the behavior of columns within a page. By default, all controls are text boxes, but you can override this behavior using column properties. All standard browser controls are available.

Refer to Assign Column Properties for more information.

Click to open the Page Events page to add and view business rules, workflow views and validation rules for the page.

Click to open the Page Groups page to set page security for WebApp groups. This includes which Groups can view, edit, delete, and insert records.

Click to open the Security Definition Pages page to add and view the security definitions integrated into this page. These definitions are bound on page columns and are used to restrict the availability of data through Role Security. Refer to Register Security Definitions to Components (WebApps) for more information.

Click to open the Catalog Page Help page, where the user can set the Dynamic Subtitle which appears when the page is loaded. These are defined per language.

Description

Displays the page name.

Displays the page type, in this case Dynamic.

Basic Properties

Displays the name of the table where the data for the page is stored.

Displays the SQL View that determines what fields from the table are to display on the Horizontal View of the page, in what order.

Displays the name of the column on the Horizontal View that is the default sort on the page. The column sorts in either ascending or descending order. Sorting must be done in the Stewardship Tier, not in the SQL view.

NOTE: When a field name is entered in Order By field, the default order is ascending. To sort in descending order, enter the field name followed by a space and desc, for example, lastname desc. Separate entries by a comma. If the page is sorted by multiple columns, a number displays next to each column header indicating the order of the sort.

Displays the SQL View that determines what fields from the table are to display on the Vertical View of the page, in what order.

Displays the menu that displays to the left of the page when the page is accessed. The standard menu is {component name} : Switchboard.

This field is not used.

Displays the page behavior when adding a new record. Options are:

• Not Supported — No records can be added to the page. The Add icon on the Page toolbar does not display.
• Horizontal Insert — Once a record is added and saved the current Horizontal View persists.
• Horizontal Insert/Switch to Vertical — Once the record is added and saved, the Vertical View displays. The Vertical View must be saved to save any information on the Vertical View only. If the Vertical View is not saved, the data entered on the Horizontal View persists and still displays.
• Horizontal/Switch to Vertical — Once the record is added and saved, the Vertical View displays. The Vertical View must be saved to save any information on the Horizontal and Vertical Views. If the Vertical View is not saved, the data entered on the Horizontal View is not saved.
• Switch to Vertical Immediately — Upon adding a record, the Vertical View displays.

Displays the page behavior when editing a record. Options are:

• Not Supported — No records can be edited. The Edit icon on the Page Toolbar does not display.
• Horizontal Update — Once a record is edited and saved the current Horizontal View persists.
• Horizontal Update/Switch to Vertical — Once the record is edited and saved, the Vertical View displays. The Vertical View must be saved to save any information on the Vertical View only. If the Vertical View is not saved, the data edited on the Horizontal View persists and still displays.
• Horizontal/Switch to Vertical — Once the record is edited and saved, the Vertical View displays. The Vertical View must be saved to save any information on the Horizontal and Vertical Views. If the Vertical view is not saved, the data edited on the Horizontal View is not saved.
• Switch to Vertical Immediately — Upon editing a record, the Vertical View displays.

Description

Status Control Views

Displays the User Control View applied to this page, which sets the control status of page columns based on the current user’s information. The default naming convention for user Control Views is web*Ucv.

Refer to User Control Views for more information.

Displays the Page Control View applied to this page, which sets the control status of page columns based on the criteria inherited from child pages (or any pages linked from). The default naming convention for Page Control Views is web*Pcv.

Refer to Page Control Views for more information.

Displays the Data Control View applied to this page, which sets the control status of page cells based on the data currently rendering on the page. The default naming convention for Data Control Views is web*Dcv.

Refer to Data Control Views for more information.

Page Views

Displays the Toolbar View applied to this page, which is used to create buttons on the page toolbar. The default naming convention for Toolbar Views is web*Tbv.

Refer to Toolbar Views for more information.

Displays the Parameter View applied to this page. The results from the Parameter View are stored with the other environmental variables (for example, boaUserID). These variables are used in places like substituting ## variables in list Where clauses and passing arguments to events. The default naming convention for Parameter Views is web*PV.

Refer to Parameter Views for more information.

Displays the Hover View applied to this page, which controls hover text that displays to the user in the Information pane when the cursor hovers over a page title. The default naming convention for Hover Views is web*Hov.

Refer to Hover Views for more information.

Column Views

Description

Displays a short description of the page for documentation purposes.

If checked, when a user adds a record on the page and clicks Save, the page remains in Add mode. This feature is useful when a user adds several records, one after the other.

If checked, a user can enable or disable a check box on this page without having to edit the page (as in., click the Edit button). This feature is useful when there is a check box(es) on the page, and updating the check box(es) is commonly the only change that a user makes on the page. Uncheck this setting if it is expected that the user will update additional information on the page besides the check box(es).

If checked, Excel integration is available on the page.

Excel Integration is the ability, at the framework level, to enable end-users to import data from Excel into Stewardship Tier pages.  

Refer to Enable Excel Integration and Use Excel Integration for more information.

If checked, when the user adds or edits a record and the page switches to Vertical View, it remains in Vertical View after the user saves the record.

If unchecked, the page returns to the Horizontal View when a record is saved, which is the standard behavior.

If checked, the page allows a user to download data to an Excel spreadsheet, a Word document or other formats.

Use this feature depending on the type of data the page displays, for example, a metric-related page may be useful to download, while a page containing sensitive information may not.

NOTE: Exclude fields, such as images and buttons, in the downloaded file if needed. Refer to Set Column Control Status for more information.

NOTE: In a case where fields should be included on the Download page that are not visible on the Horizontal or Vertical View, hide fields using the page columns All Views view type, but then enable them on the Download for this level of control.  Refer to Enable File Upload/Download for more information.

Displays the amount of time in seconds that passes before the page is automatically refreshed. If the value is 0, the page is not automatically refreshed.

This field is not used.

Displays the name of the catalog used for translations for this page, if needed.

Refer to Manage Catalogs for more information.

If checked, this page can be linked to using the Quick Links feature. Refer to Quick Links for more information.

If this page requires binding to function correctly (Page Control View for example), then this setting must be disabled.

Description

Displays text that is included in downloaded Excel templates as an additional 'Instructions' sheet.

Technical Column Name Row

Displays the background color for the header row containing the original, untranslated column name.

Displays the foreground color for the header row containing the original, untranslated column name.

Translated Column Name Row

Displays the background color for the header row containing the translated column name.

Displays the foreground color for the header row containing the translated column name.

Data Type Row

If checked, a header row is included in downloaded Excel templates that displays data type and length details for each column.

Displays the foreground color for the header row containing column data type details.

Help Text

When checked, in the downloaded Excel template, the column help text is displayed in comments when hovering over the second row.

See Add Column Help Text for more information

When checked, a header row is included in downloaded Excel templates that contains a text-only representation of the column's help text (without HTML markup).

Displays the background color for the header row containing column help text.

Description

If checked, the Report option is available on the Page Options drop-down for the page.

Displays the report view used for the report.

Description

Displays the Search ID for the page. The Search ID is the table containing the index used for search.

Search ID is the ID of a predefined Search set. They are defined in the Admin > Data Sources > Index icon > Index (Specification) page.

See Create an Index for more information.

Displays the Duplicate Detection Search ID for the page. The Duplicate Detection Search ID is the table containing the index used for bulk duplicate detection.

Duplicate Detection Search ID is the ID of a predefined search set to use when looking for duplicates. They are defined in the Admin > Data Sources > Index icon > Index (Specification) page.

A page may use different searches for regular searching and duplicate detection. For instance, you may allow users to search the customer table by both name and street address, but when detecting duplicates, you may want to restrict the search to name only.

See Build Indices for a Data Source for Search and Duplicate Detection for more information.

Description

If checked, records on the Horizontal View of the page can be edited. If unchecked, editing for a record can only be performed on the Vertical View.

Displays the column name of the page's underlying table or view containing the data that displays in the title bar on the Horizontal view.

Displays the column name of the page's underlying table or view containing the data that displays in the title bar on the Vertical view.

Displays how pages are initially displayed when records can be added on the page but no records have been added yet.

Options are:

• Display — The user must use buttons to add and edit records on the page, even if no records exist.
• Insert — The page displays in Add mode, ready to accept data without the user having to select an Add or Edit button. The Save button is active.

Contains an alias for the Horizontal View of the page that displays in the breadcrumbs.

Description

Displays the page name.

Displays the page type, in this case Static.

Basic Properties

Displays the text that displays on the page.

Displays the name of the menu that displays in the Navigation pane when the page is accessed. The standard menu is {component name} : Switchboard.

Description

Displays a short description of the page for documentation purposes only.

Displays the amount of time in seconds that passes before the page is automatically refreshed. If the value is 0, the page is not automatically refreshed.

If checked, this page can be linked to using the Quick Links feature. Refer to Quick Links for more information.

If this page requires binding to function correctly (Page Control View for example) then this setting must be unchecked.

Displays the name of the catalog used for translations for this page, if needed.

Refer to Manage Catalogs for more information.

This field is not used.

Description

Displays the page name.

Displays the page type, in this case Header Detail.

Displays how the header detail pages open by default. If the partition is horizontal, the header page displays in the upper frame and the details page displays in the lower frame. If the partition is vertical, that header and detail pages display side by side.

Click the icon to open the Layout Frames page to set the pages that are used for the Header and Detail pages.

Displays the name of the menu that displays in the Navigation pane when the page is accessed. The standard menu is {component name} : Switchboard.

Description

Displays a short description of the page.

If checked, this page can be linked to using the Quick Links feature. Refer to Quick Links for more information.

If this page requires binding to function correctly (Page Control View for example) then this setting must be unchecked.

Click to open the Copy Page page to create a copy of the selected page to use as a basis for a new page. When a page is copied, the column properties, events, validations and other settings are copied.

NOTE: This button is disabled if the page is in Edit mode.

Refer to Copy a Page in a WebApp for more information.

Displays the title for the header detail page, which is the [component name]: [page name].

Description

Displays the page name.

Displays the page type, in this case Chart.

Basic Properties

Displays the name of the SQL view upon which the chart is based.

Displays the name of the menu that displays in the Navigation pane when the page is accessed. The standard menu is {component name} : Switchboard.

This field is not used.

Displays the type of chart, such as Bar or Line.

Description

Displays a short description of the page for documentation purposes only.

Displays the field to sort by. Sorting must be done in the Stewardship Tier, not in the SQL view.

For example, a bar chart with labels can be sorted by the field that contains the label names. The bars would appear in that order when the chart displays.

NOTE: When a field name is entered in Order By field, the default order is ascending. To sort in descending order, enter the field name followed by a space and desc, for example, lastname desc. Separate entries by a comma.

Displays the amount of time in seconds that passes before the page is automatically refreshed. If the value is 0, the page is not automatically refreshed.

This field is not used.

Displays the name of the catalog used for translations for this page, if needed.

Refer to Manage Catalogs for more information.

If checked, this page can be linked to using the Quick Links feature. Refer to Quick Links for more information.

If this page requires binding to function correctly (Page Control View for example) then this setting must be unchecked.

This field is not used.

This field is not used.

Description

Displays the page name.

Displays the page type, in this case Dashboard.

Displays the layout that is used for the dashboard. Layouts that are installed with the Stewardship Tier can be viewed on the Layouts page. A user can also add a layout. Refer to Create a Dashboard for more information.

Basic Properties

Displays the name of the menu that displays in the Navigation pane when the page is accessed. The standard menu is {component name} : Switchboard.

Description

Displays a short description of the page for documentation purposes only.

Displays the name of the catalog used for translations for this page, if needed.

Refer to Manage Catalogs for more information.

If checked, this page can be linked to using the Quick Links feature. Refer to Quick Links for more information.

If this page requires binding to function correctly (Page Control View for example), then this setting must be unchecked.

This field is not used.

This field is not used.

Description

Displays the page name.

Displays the type of page, in this case, Service.

Basic Properties

Displays the table where the data for the page is stored.

Description

Displays the queue ID that determines which Service Queue is used during execution. This can be used to serialize certain operations or load balance.

Displays the next service date and time the service page will run.

Displays the frequency that the service page will run and used in conjunction with the UOM (Unit of Measure) field. For example, if the Service Qty field displays 2 and the Service UOM field is Day(s) the service page runs every two days starting from the date displayed in the Next Service Date field.

Displays the service UOM (Unit of Measure) that is used in conjunction with the number in the Service Qty field to set the frequency that the service page will run.

If checked, the service page will run. If unchecked, the service page will not run but can be activated at a later date to run again. .

Description

Displays the page name.

Displays the type of page, in this case, Report.

Basic Properties

Displays the view used to generate report.

Displays a SQL Order By clause used to sort the page.

NOTE: Do not include "ORDER BY" in the clause

Displays the order the reports are listed on the page.

Displays the Report Groups used to customize the layout of the report.

Displays the name of the horizontal menu. If left blank, the horizontal menu is not used for this page.

Description

Displays a short description of the page for documentation purposes only.