Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners

DB2 PHP Generator online Help

Prev Return to chapter overview Next

Check box group

Select this control to provide users with the ability to select multiple items. You can also use the Multiple select control for this purpose. The difference between these editors are:

Check box group demonstrates all values available for selection,
Multiple select provides adding new items using drop-down combobox and requires less space in the form. Live Demo.

Changing the control type to Multiple select creates this multi-choice control with the same properties.

 

In case you use Check box group to work with a table column, the corresponding Filter Builder uses Multiple select for this column.

 

 

Max width

Use this property to restrict the maximum width of the editor (this means that in any screen resolution editor's width will be less or equal then the property value). Can be specified in any units supported by web browsers e.g. 300px, 25em, 50%, etc.

 

Values

You can separate values to be represented in the control and values stored in the database. For this purpose use the dialog opened by the ellipsis button and enter the values you need, or add them manually as pairs stored_value=value_to_be_represented separated by commas (Example: 1=One, 2=Two).

 

Display mode

Use the drop-down list to select whether the check box group will be represented on the same column (Stacked) or on the same line (Inline).

 

Retrieve values from database

Turn this option ON to fill in the control with values from a database.

Data source

Data source name to retrieve values from.

 

Stored field

Data source field name to retrieve stored values from.

 

Displayed field

Data source field name to retrieve displayed values from.

 

Sorting

Sorting order of displayed values in the editor.

 

Filter condition

Allows to reduce the list of values represented in the editor with a specified criteria. This condition corresponds to the WHERE clause applied to the data source (you must not add the WHERE keyword to beginning of the condition). The following operators can be used in this clause: =,<> (!=), >, <, >=, <=, BETWEEN, LIKE, IN.  It is also possible to use predefined variables like %CURRENT_USER_NAME%.

 

Add new item on the fly

Turn this option ON to allow adding new items directly in the editor. When this option is checked, an 'Insert item' link is displayed on the bottom of the editor.

Click the ellipsis button at the right to customize the modal dialog to be displayed when adding a new item. For example, you might want to hide some fields and/or customize the form layout.

 

Note: If values are retrieved from a database, hard-coded values described above are ignored and NOT included into the list of available choices.

 

Inline styles

Use this field to set formatting options to be used inside the style attribute of the element. For example, to set the font color and the background color for a control, place the following string to Inline styles:

 

color: red; background-color: yellow;

 

Custom attributes

This property allows you to add simple metadata to individual elements, largely for the purpose of providing information to make JavaScript functions easier. Such attributes can be later handled in client-side events. For example, to add several custom attributes to an editor, enter the following string into the Custom attributes edit box:

 

data-city="Boston" data-lang="js" data-food="Bacon"

 

It is recommended to prefix all custom attributes with data- to keep the result document compatible with the HTML5 requirements.



Prev Return to chapter overview Next