DataSplice Releases Mobile Integration Suite 3.0
Field Settings
After the base SQL statement has been set up on the Settings and Attributes screen, the fields from the data source are visible in DataSplice and can be edited. To edit the fields, choose Field Settings from the Configuration Section drop-down list.
Select a field from the list to display pertinent information for the field.
Field Settings and Permissions
The Field Settings and Permissions section shows built-in settings that can be set as desired for the selected field.
| Field Name | Description |
|---|---|
| Primary Key | Identifies the unique primary key for this view. |
| Conflict Check | Checkbox that specifies if the field should be checked for data integrity conflicts at the time a record is saved. This is useful when there is a possibility of two users with cached data that are making changes to the same records at the same time. If this setting is enabled, when the users go to commit their changes, the system will check that the value for this field in the database is currently the same as it originally was when it was cached on the device. If it is different, such as if another user changed the field in the meantime, then a conflict resolution dialog box will be displayed. |
| Default | A value that will appear in this field by default. This can be a literal value or an attribute. |
| Visible | Determines if this field can be seen by users. |
| Editable | Determines if this field can be updated by users. Acceptable values are true, false, 1, 0, etc. |
| Searchable | Allows the field to be used for search criteria. |
| Sortable | Allows the field to be used as a sorting field. |
| Text Casing | Forces the text case to be in a predefined format. If enabled, acceptable choices are Upper or Lower. |
| Ignore Case on Search | Allows this field to be searched on using search criteria, independent of the text casing of the actual data of interest. |
Lookup List Settings
A key feature of successful mobile applications is to minimize the amount of user input steps. Wherever possible, the application should provide lists to choose from rather than requiring the user to enter data into the field in free form. The Lookup List Settings section allows for these types of lists to be configured.
| Field Name | Description |
|---|---|
| Lookup Type | The type of lookup list to create. Possible options are None, Static List, Dynamic List, and Popup Grid. Depending on the option that is chosen, different settings may need to be configured. |
| Restrict to List | This checkbox determines whether users will be able to add additional entries to the lookup list, or if their selection will be limited to the existing values in the list. |
| Value List | This setting is only available when using a Static List. This provides the area to enter delimited values to appear in the static list. |
| Query Name | This setting is particular to the Dynamic List and Popup Grid options. This is where the query to be used is selected from the list of available queries. |
| Value Field | This setting is particular to the Dynamic List and Popup Grid options. This allows for specific fields to be selected from the query that has been chosen. |
| Visible Fields | This setting is only available in the Dynamic List option. This allows for fields to be selected to in order to be made visible to the users. |
Static Lists
Static Lists allow for values to be entered, which can then be selected from a list. The values do not change. An example of a possible static list would be a drop-down containing the list of two-digit state abbreviations in the United States, such as CA, CO, etc.
Multiple Column Lists
For combo box-style validation lists, the Remote Client can be configured to display multiple columns. The values in the first column will be the ones used as the field data, but the other columns can contain information that is helpful to the user. For instance, a list of equipment numbers could provide a description field next to it.
To display multiple columns with static lists, the column values should be separated with a pipe character ("|").
Dynamic Lists
View style validation settings have some interesting options. These will create lists of possible entries by performing queries against other views. The dialog box defines a filter that can use values from current attributes and field values to find associated records in the target view.
Drop-down lists are limited to displaying at most 200 values. In practice
it is almost impossible to find values if this many entries are present.
In general, when numerous entries are present, the Popup Grid option should be used as Display Type addresses this problem.
The Visible Fields setting specifies which columns should be displayed in the popup list.
Popup Grids
If this is selected, the target view is displayed in a data grid format in a dialog box.
This allows the user to search for particular records and double-click on an item to copy its value into the current field.
Last modified 2005-12-08 12:34 PM
