Behavior user preferences options in the web client

Option	Description/Comments/Procedures
Show Configuration Name On Caption	To display the name of the system configuration, to which you are currently logged on, in the title bar of the application, select this option.
Prompt to Save Form Splitter Changes	When this option is selected, a prompt to save your changes displays when you close a MultiView form in which changes have been made to the position of the splitter bar. For example, in a MultiView form, you can move the splitter bar to enlarge the Grid View of the form. If this option is selected, then you can save the changes permanently, so that every time you open the form, the Grid View is right where you positioned it. When you close the form, a prompt displays, asking whether you want to save the current splitter bar position. To save the form configuration, click Yes. If this check box is cleared, you cannot save splitter bar position changes in Runtime Mode.
Prompt to Save Grid Changes	When this option is selected, a prompt to save your changes displays when you close a MultiView form in which changes have been made to the Grid View. For example, in a MultiView form, you can widen some columns and narrow other columns in the Grid View of the form. If this option is selected, then you can save the changes permanently, so that every time you open the form, the Grid View is just as you have it now. When you close the form, a prompt displays, asking whether you want to save the current Grid View changes. To save your changes, click Yes. If this check box is cleared, you cannot save Grid View changes in Runtime Mode.
Prompt to Save Flex Layout Changes	When this option is selected, a prompt to save your changes displays when you close a form in which changes have been made to its FlexLayout attributes.
Prompt to Save DataView Layout Changes	When this option is selected, prompt to save your changes displays when you close a form in which an updated DataView layout is in use, or if a DataView layout is switched to another layout. DataView Layout changes include updates to: Column order Column visibility Column size Column filtering Grouping Summaries Expression columns Custom columns (Windows client only) The prompt to save changes applies to all types of DataView Layouts except for DataSearch. If you make changes to multiple DataView components in a form, then a separate prompt to save your changes appears for each component.
Show All Forms in Forms List	To display hidden forms in the All Forms list, select this option. You can hide forms in Runtime mode using the Hidden In Forms List form. When a form is hidden, you cannot see the form in the Explorer > Master Explorer > All Forms list or search for the form from Form > Open > Select Form list.
Unload IDO Metadata With Forms	To force the system to unload IDO metadata when forms are closed, select this option.
Display Captions in Most Recently Used forms list	To display the form captions, instead of form names, in the Most Recently Used list, select this option.
Load/replace form with extended form	To enable users to extend and replace an original (base) form, select this option. If this option is selected, when a request to open the base form is received, a new (extended) form, of a base form, opens. This option is available only to users with Site Developer or Vendor Developer editing permissions.
ENTER key behaves like TAB key	To use the ENTER key to move between fields on a form, in the same way the TAB key works, select this option. To use only the TAB key to move between fields, clear this check box. Note: If you select this option, then you can use the ENTER key or the TAB key for most movement between fields and options on the form, with these exceptions: In fields where you can enter several lines of text, pressing ENTER always starts a new line. To move to the next field, you must use the mouse or the TAB key. If the focus is on a button, pressing ENTER executes the action represented by the button. To move to the next button or field without executing the action, you must use the mouse or the TAB key.
User Data Record Cap and User List Record Cap	The term "caps" refers to the maximum number of records or items that the system can return at one time. There are two types of caps that you can set: Data records Drop-down list items Note: Instead of resetting the cap for collections, we recommend that you use the Get more rows in the current collection tool bar button. These settings do not override any system-wide caps that might be in effect. Both of these types of caps have the same three options: Use Default: To use the system default cap setting, select this option. This is the default option. Retrieve All: To retrieve all records or to display all items in a list, and override the system default setting, select this option. Note: This option is not recommended for most operations, because the time it takes to retrieve all records or display all items on a list can be excessive and can slow the system down. Use Specified Max: To set your own maximum cap, select this option. If you select this option, then you must also specify a value in the field next to it. For example, to return a list of 350 records at a time, under User Data Record Cap, select this option, and then specify 350. A -1 value indicates that the system default setting is used. If the Retrieve all option is selected, then this field displays 0. Unless the system administrator has set the Save record cap override process default, this setting is not saved when you sign out.
Language	To set the language for the texts in field labels, button labels, menus, online help, and other parts of the user interface, select a language from the list, and then click Apply. Note: Only languages that are installed and are available on your system are listed. It can take a few minutes for the language to apply to the system. Currently, the Mongoose help is available only in U.S. English.
Wildcard character	Specify a wildcard character. The wildcard character is used when you search for information with Filter-in-Place or query forms. The default character is the asterisk (*).
SQL Characters to Pass Through in Filtering	Specify a SQL character to pass through in filtering. The special character that you specify is escaped in SQL wildcard queries. The underscore (_) and square brackets ([ ]) are special characters that you can use in a query with a SQL "LIKE" clause and a wildcard. For example, the underscore character in a wildcard context is treated as "any character" by SQL unless it is escaped. There are users who use these special characters with their built-in query capabilities while others use the characters like any other character in the query. For example, if you specify the underscore character as a character to pass through and you perform a query for the value my_data*, then the SQL Server ESCAPE clause is applied to the underscore character in the query, and only instances that start with my_data are returned. If you do not specify the the underscore character in this field, the _ in the query represents represents "any character" and instances such as my3data are returned.

Show Configuration Name On Caption

To display the name of the system configuration, to which you are currently logged on, in the title bar of the application, select this option.

Prompt to Save Form Splitter Changes

When this option is selected, a prompt to save your changes displays when you close a MultiView form in which changes have been made to the position of the splitter bar.

For example, in a MultiView form, you can move the splitter bar to enlarge the Grid View of the form. If this option is selected, then you can save the changes permanently, so that every time you open the form, the Grid View is right where you positioned it.

When you close the form, a prompt displays, asking whether you want to save the current splitter bar position. To save the form configuration, click Yes.

If this check box is cleared, you cannot save splitter bar position changes in Runtime Mode.

Prompt to Save Grid Changes

When this option is selected, a prompt to save your changes displays when you close a MultiView form in which changes have been made to the Grid View.

For example, in a MultiView form, you can widen some columns and narrow other columns in the Grid View of the form. If this option is selected, then you can save the changes permanently, so that every time you open the form, the Grid View is just as you have it now.

When you close the form, a prompt displays, asking whether you want to save the current Grid View changes. To save your changes, click Yes.

If this check box is cleared, you cannot save Grid View changes in Runtime Mode.

Prompt to Save Flex Layout Changes

When this option is selected, a prompt to save your changes displays when you close a form in which changes have been made to its FlexLayout attributes.

Prompt to Save DataView Layout Changes

When this option is selected, prompt to save your changes displays when you close a form in which an updated DataView layout is in use, or if a DataView layout is switched to another layout.

DataView Layout changes include updates to:

Column order
Column visibility
Column size
Column filtering
Grouping
Summaries
Expression columns
Custom columns (Windows client only)

The prompt to save changes applies to all types of DataView Layouts except for DataSearch.

If you make changes to multiple DataView components in a form, then a separate prompt to save your changes appears for each component.

Show All Forms in Forms List

To display hidden forms in the list, select this option.

You can hide forms in Runtime mode using the Hidden In Forms List form.

When a form is hidden, you cannot see the form in the Explorer > Master Explorer > All Forms list or search for the form from Form > Open > Select Form list.

Unload IDO Metadata With Forms

To force the system to unload IDO metadata when forms are closed, select this option.

Display Captions in Most Recently Used forms list

To display the form captions, instead of form names, in the Most Recently Used list, select this option.

Load/replace form with extended form

To enable users to extend and replace an original (base) form, select this option. If this option is selected, when a request to open the base form is received, a new (extended) form, of a base form, opens.

This option is available only to users with Site Developer or Vendor Developer editing permissions.

ENTER key behaves like TAB key

To use the ENTER key to move between fields on a form, in the same way the TAB key works, select this option. To use only the TAB key to move between fields, clear this check box.

Note:

If you select this option, then you can use the ENTER key or the TAB key for most movement between fields and options on the form, with these exceptions:

In fields where you can enter several lines of text, pressing ENTER always starts a new line. To move to the next field, you must use the mouse or the TAB key.
If the focus is on a button, pressing ENTER executes the action represented by the button. To move to the next button or field without executing the action, you must use the mouse or the TAB key.

User Data Record Cap and User List Record Cap

The term "caps" refers to the maximum number of records or items that the system can return at one time. There are two types of caps that you can set:

Data records
Drop-down list items

Note:

Instead of resetting the cap for collections, we recommend that you use the Get more rows in the current collection tool bar button.
These settings do not override any system-wide caps that might be in effect.

Both of these types of caps have the same three options:

Use Default: To use the system default cap setting, select this option. This is the default option.
Retrieve All: To retrieve all records or to display all items in a list, and override the system default setting, select this option.
Note: This option is not recommended for most operations, because the time it takes to retrieve all records or display all items on a list can be excessive and can slow the system down.
Use Specified Max: To set your own maximum cap, select this option. If you select this option, then you must also specify a value in the field next to it.
For example, to return a list of 350 records at a time, under User Data Record Cap, select this option, and then specify 350.
A -1 value indicates that the system default setting is used. If the Retrieve all option is selected, then this field displays 0.
Unless the system administrator has set the Save record cap override process default, this setting is not saved when you sign out.

Language

To set the language for the texts in field labels, button labels, menus, online help, and other parts of the user interface, select a language from the list, and then click Apply.

Note: Only languages that are installed and are available on your system are listed. It can take a few minutes for the language to apply to the system.

Currently, the Mongoose help is available only in U.S. English.

Wildcard character

Specify a wildcard character. The wildcard character is used when you search for information with Filter-in-Place or query forms.

The default character is the asterisk (*).

SQL Characters to Pass Through in Filtering

Specify a SQL character to pass through in filtering. The special character that you specify is escaped in SQL wildcard queries.

The underscore (_) and square brackets ([ ]) are special characters that you can use in a query with a SQL "LIKE" clause and a wildcard. For example, the underscore character in a wildcard context is treated as "any character" by SQL unless it is escaped. There are users who use these special characters with their built-in query capabilities while others use the characters like any other character in the query.

For example, if you specify the underscore character as a character to pass through and you perform a query for the value my_data*, then the SQL Server ESCAPE clause is applied to the underscore character in the query, and only instances that start with my_data are returned. If you do not specify the the underscore character in this field, the _ in the query represents represents "any character" and instances such as my3data are returned.