Page Columns

Description

Displays the Page ID for the WebApp.

Displays:

• The name of the column from the view or table associated with the page,

• The name of the tab or label, or

• The name of the toolbar button.

Displays the context in which the control appears as configured.

All Views can be used in most cases. However, column properties can be applied to other views as needed. For example, a field can be a Combo Box on the Horizontal View, but can be a display only field on the Vertical View. In this case, set the field as a Combo Box for the View Type of All Views. Add another record for the field and select a View Type of Vertical, and set the CONTROL STATUS to Disabled.

Displays the behavior of columns within a page. By default, all controls are text boxes but can be overridden by assigning a column property. A column can have one control per view. Refer to Add a Control Type to a Column for more information.

Displays the source of the data when the Control Type is Combo Box or List Box. The value can either be:

• SQL object (Table or View) or

• List Data Provider plugin.

Refer to Add List Boxes and Combo Boxes for more information.

Displays the Page Name/ID the Syniti Construct navigates to when a page link is performed.

This option can be set for Control Types:

• Text Box

• Date time

• Combo Box

• Numeric

• List Box

• Image

• Button

• Toolbar

• Text Area

Refer to Link to a Page Using Buttons and Images for more information.

Displays whether the column should be enabled (displayed), disabled (display-only), or hidden in the associated View Type.

Control Status can be overridden using:

• Page properties,

• UserControlView,

• PageControlView, or

• DataControlViews.

Refer to Set a Column Control Status for more information.

Description

Displays the text that appears on the Label.

Displays the type that uses the control.

Displays Label.

Basic Properties

Description

Displays the name of the tab.

Displays the type that uses the control.

Displays tab.

Basic Properties

Description

Column Description

Displays the name of the column from the view or table associated with the page.

Displays the context in which the control appears as configured.

All Views can be used in most cases. However, column properties can be applied to other views as needed. For example, a field can be a Combo Box on the Horizontal View, but can be a display only field on the Vertical View. In this case, set the field as a Combo Box for the View Type of All Views. Add another record for the field and select a View Type of Vertical, and set the CONTROL STATUS to Disabled.

Displays whether the column should be enabled (displayed), disabled (display only), or hidden in the associated View Type.

Refer to Set a Column Control Status for more information.

Displays the behavior of columns within a page. By default, all controls are text boxes but can be overridden by assigning a column property. A column can have one control per view. Refer to Assign a Control Type to a Column for more information.

Basic Properties

Displays the name of the image used for the button or image.

This field displays for the controls:

• Image

• Button

• Toolbar

Displays the name of the page that opens when the user clicks the control.

Refer to Link to a Page using Buttons and Images for more information.

This field displays for the controls:

• Image

• Button

• Text Area

• Toolbar

Displays the requirement level on a column by adding a page validation view. The requirement levels are:

• Required (Hard) – The field must contain valid data before the record can be saved.

• Required (Soft) - Construct generates an error if the field is blank but allows the records to be saved.

• No – The field is not required.

If the field value contains NOT NULL in the table (such as a key), columns automatically defaults to Required (Hard).

Refer to Set Required Fields for more information.

This field displays for the controls:

• Combo Box

• HTML Area

• Text Box

• DateTime

• Numeric

• List Box

• Text Area

Provides defaults for page columns during record insert. Defaults may also be set by a Defaults View at the page level.

Refer to Set the Default Field Value for a Column for more information.

This option is available for these controls:

• Check Box

• Combo Box

• HTML Area

• Text Box

• DateTime

• Numeric

• List Box

• Text Area

Displays the format for Check Box control only. Options are:

• INFOR LN (Yes or No)

  Note

  Use this check box format when creating a page that is integrated with INFOR. This check box stores 1 for True and 2 for False.

• SAP BDC

Note

A check box using this format allows the values ‘X’ for checked and ‘!’ for unchecked. The ‘!’ is a special character used in an SAP BDC that tells the program there is no data in the field (i.e., the field should be ignored). This is useful when doing an update to existing data in SAP and the data must not change unless it has been modified.

• SAP Checkbox – Deprecated

Note

A check box using this format allows the values ‘X’ for checked and ‘ ‘ for unchecked.

• Y or N

Note

A check box using this format allows the values ‘Y’ for checked and ‘N’ for unchecked.

Note

If the data type of the table column in SQL is set to bit, the Syniti Construct assumes the field is a checkbox and appropriately populate the data with a 1 or 0.

Note

If one of these formats is chosen for the checkbox, the data type of the table column in SQL must be set to a character of length 1. The user will receive a hard error while entering data on the page if one of these checkbox formats is selected and the data type of the field is bit or another non-character format.

Displays static text to use as a placeholder watermark when the control is empty.

Refer to Add a Watermark for more information.

This field displays for the controls:

• Combo Box

• HTML Area

• Text Box

• DateTime

• Numeric

• List Box

• Text Area

Displays a format for the selected control specified by the page Designer. Options vary for each control. Column database type should be taken into consideration when selecting Numeric and DateTime formats.

Refer to Set a Column’s Format for more information.

This field displays for the controls:

• Text Box

• DateTime

• Numeric

• Text Area

Displays the toolbar location. The only option is Page.

This field displays for the Toolbar control only.

Basic List Properties

Note

The fields in this section display for List Box and Combo Box controls only.

Displays the source of the data when the Control Type is Combo Box or List Box. The value can either be a SQL object (Table or View) or a List Data Provider plugin.

Refer to Add List Boxes and Combo Boxes for more information.

Displays the name of the field that stores the value.

In most cases, List Value Field is the primary key stored in the table

Refer to Add List Boxes and Combo Boxes for more information.

Displays the option visible in the List Box or Combo Box.

Refer to Add List Boxes and Combo Boxes for more information.

Note

The fields in this section display for the Numeric control only.

Displays the number of decimal places to display after the decimal separator.

If enabled, a number uses the current user’s locale to display a number such as 4213.22 as 4,213.22 given that English – United States is selected in the Currency Locale ID List Box.

Displays the locale used for formatting currency.

Description

Displays the image to appear in the header row for this column.

This field displays for these controls:

• HTML Area

• Text Box

• Button

• Check Box

• DateTime

• Combo Box

• Image

• Numeric

• List Box

• Text Area

Displays a depiction of header image chosen.

This field displays for these controls:

• HTML Area

• Text Box

• Button

• Check Box

• DateTime

• Combo Box

• Image

• Numeric

• List Box

• Text Area

Displays the image specified in the contents of the query.

This field displays for image control.

Displays the dynamic link method the control uses when the image is clicked. Options are:

• Dynamic Pages – This option contains a Syniti Construct PageID.

• Dynamic Views – this option is comprised of SQL statements that can use drill or binding criteria...

• Dynamic URLs – This option must contain a URL.

This field displays for these controls:

• Text Box

• Button

• DateTime

• Image

• Numeric

• Toolbar

Displays the column in view to use as dynamic link criteria.

Dynamic Links may be used to navigate to WebApp pages outside of the current WebApp.

This field displays for these controls:

• Text Box

• Button

• Image

Displays the Syniti Construct page name navigated to when page link is executed. Value list only contains pages in the current WebApp. Dynamic Links may be used to navigate to WebApp pages outside of the current WebApp.

This field displays for these controls:

• Text Box

• Date time

• Combo Box

• Numeric

• List Box

• Image

• Toolbar

• Text Area

Displays whether the page that is accessed from the control overlays the existing page or opens in a separate page.

This field displays for these controls:

• Button

• Image

• List Box

• Toolbar

Displays the field name that contains a GUID that corresponds to the Data Source to join against for the view/table specified in the List Table column.

The Syniti Construct looks for that field's value in the following order.

1. Column in the page's Horizontal or Vertical view

2. Drill Down Criteria passed to this page.

3. Link Criteria passed to this page.

4. Shared Criteria for this WebApp.

The System Administration WebApp uses this feature extensively to look up INFORMATION_SCHEMA objects. For example, when looking up column names, the Syniti Construct creates a boaColumnList view in the database when a data source is registered, as opposed to relying on one view that unions the INFORMATION_SCHEMA views of all data sources. Connecting to the actual Data Source directly increases performance, reliability and scalability.

This field displays for these controls:

• Button

• Combo Box

• Image

• List Box

• Toolbar

If enabled, the selected column name is a primary key. The Syniti Construct only passes Primary Keys when linking to other pages. If the page data source is a view, a control must be added indicating the Key.

If disabled, the selected column name is not a primary key.

This field displays for these controls:

• Check Box

• Text Box

• Date time

• Combo Box

• List Box

• Numeric

• Text Area

If enabled, a required column is allowed to have space(s) as a valid entry. If disabled, a required column is not allowed to have space(s) as a valid entry.

This field displays for these controls:

• Text Box

• Date time

• Combo Box

• Numeric

• List Box

• Text Area

If enabled, the text associated with the label for the check box wraps.

This field displays for the Check Box control only.

If checked, this column displays in the failed records Bulk Execution results. By default, only the first column on the page displays in these results.

Refer to View Bulk Execution Results for more information.

If enabled, the cell values are translated. Translations are dependent on catalog entries for the selected session Language. Refer to Manage Catalogs for more information.

If disabled, the cell values are not translated.

This field displays for these controls:

• Text Box

• Combo Box

• Image

• List Box

• Toolbar

• Text Area

Note

The fields in this section display for the Text Area control type only.

Displays a comma-separated list of columns used to filter data on a linked page. By default, when linking form one page to another, the Syniti Construct sends the key fields to the linked page. However, it the key fields are different between linked pages or additional fields are required, use this field to indicate the columns.

For instance, a user clicks a button on a page listing country records to access a page listing the selected country’s regions. If both pages do not have the country field with the same name, the field on the linked page must be added here to include as part of the binding criteria. Otherwise, the region page displays regions for all countries.

Displays a comma-separated list of columns used to send data to a linked page.

Shared Fields tell the Syniti Construct to send the data from a column that is not normally passed and allow it to be used on a subsequent page. For example, to filter a Region list box on a page by the Country field that was entered on a previous page, add the Country field as a shared field on the link between pages. It is then available for use in the list box Where Clause on the Region page.

If you were to include Country as a Shared Field and not a Binding Field, you would see regions for all countries after clicking the link, but any list boxes with a Country filter would only show regions filtered by the country shared from the previous page.

Note

The fields in this section display for the Toolbar control type only.

If enabled, the boaStatus column is used to determine whether the toolbar button is active or dimmed.

Refer to Use boaStatus to Set a Toolbar Button’s Control Status for more information.

If enabled, a user can select multiple records on the Horizontal View and click the toolbar button to perform the action related to the toolbar button on multiple records at once.

Advanced List Properties

Note

The fields in this section display for List Box and Combo Box controls only.

Displays the Where Clause used to restrict the values that display in a List Box or Combo Box.

Refer to Set a Dynamic List Box and Enable List Where Clause for more information.

Displays the column that sets the sort for values in the List Box or Combo Box.

By default, like pages, List Boxes are sorted based on the primary key. Use List Order By to sort select options in a List Box based on another field.

Note

When a field name is entered in List 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, ProductName desc. Separate entries by a comma.

If enabled, displays List Box or Combo Box values not previously selected in another record on the page. If the record has already been added, the List Unique property removes it from the List Box, leaving only the records that have not been selected.

If enabled, the Filter icon displays next to the Combo Box, indicating a filter is enabled.

The Combo Box Filters are designed to reduce the number of items displayed in the value field or the descriptive field.

Note

This field displays for the Combo Box control only.

Displays an option that sets the behavior of the List Box or Combo Box when the value stored in the field is known.

As the user types in the List Box, matching values display.

Options for List Allow Insert are:

• No – Insert does not display and additional options cannot be added or searched.

• Yes – Insert displays and any additional option can be entered in the field regardless of the options available in the List Box. The record is considered valid. The added value does not become a future option in the table.

• Constrained to List Source –A user can add a new entry by clicking Use this Value. A validation rule automatically runs to verify the entry is valid. This prevents undesirable data being added to the list table.

Note

The current user must have security to add new records to the page associated with the list.

Displays the name of the page that displays when a user clicks a link that displays below the List Box that allows them to add a new record. Used in conjunction with List Allow Insert. This feature permits additional values not available in the list to be added to the associated list.

If both are enabled, clicking the link opens a window containing the page associated with the list. Enter the new options in the fields and the value is available in the List Box when adding new records.

Displays the name of the field that contains descriptive text that displays in a List Box or a Combo Box when in add or edit mode. Refer to Add a List Selection Field for more information.

Displays the name of the view used to select columns from the table to restrict the number of values in the List Box or Combo Box.

Description

If checked, the boaStatus column is used to determine whether the control is enabled or disabled.

If unchecked, and the Control Status Field on the Enable/Disable tab displays another column in the view, this column’s value (NULL/0, 1, or 2) determines the Control Status of this column for a given row.

If unchecked and the Control Status Field is blank, the control status field is not set using either of these methods. Control Status can also be set as a column property. Refer to Set Column Control Status for more information.

Description

Displays the name of the view that contains the tooltip. Before creating a tooltip, the user mist write a view with the suffix Dtv for each column that requires a tooltip and alias the column as boatooltip in the view.  

This field displays for the controls:

• Button

• Combo Box

• Image

• List Box

Displays the comma-delimited list of field names to bind against to return tooltip data.

For instance, if you wanted the page to display a different tooltip depending on data from a previously populated field, you could use that field here as a binding column allowing it to select the proper data to display.

This field displays for the controls:

• Button

• Combo Box

• Image

• List Box

If enabled, the tooltip value is run through system translation. If disabled, the watermark value is not translated.

This field displays for the controls:

• Button

• Combo Box

• Image

• List Box

Displays the view that defines what text should appear for each record when the field is empty as an informational watermark.

This field displays for the controls:

• HTML Area

• Text Box

• Date Time

• Combo Box

• Numeric

• List Box

• Text Area

Displays the fields to bind page data against watermark view with.

This field displays for the controls:

• HTML Area

• Text Box

• Date Time

• Combo Box

• Numeric

• List Box

• Text Area