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

Columns

The Columns tab of Page Editor allows you to customize the way column data is displayed for all the available presentations (like List, Edit, Insert, etc). Details are covered below.

 

Common

Properties specified in this section are applied to all presentations.

 

Caption

Allows you to specify the caption for the column. To provide different captions for different presentations (for example, you might want to specify a shorter caption for the List view and a more longer caption for Insert/Edit form), click the ellipsis button and specify the appropriate values.

 

Use lookup

Turn this checkbox ON and set the appropriate options to enable displaying of lookup values instead of the "real" values stored in this column. For example, if a column stores country IDs, you can use this option to display country names instead of their IDs (assuming that there is a table that stores the ID/name combination for each country).

 

 

By default, DB2 PHP Generator enables lookups for columns linked by a foreign key with a single column from another table (if the Setup lookups by foreign key option option is enabled).

 

View

Use this section to specify the way column values are displayed on List, View, Print, Export, and Compare pages.

 

 

List

Here you can specify some options that are applied only for the List view.

 

Show column filter

Turn ON the checkbox to enable the column filtering for the appropriate column. Use Sorting and Number of values to display controls to specify the sort order and number of values to be displayed in the column filter dropdown accordingly. Live Demo.

 

Minimal visibility

DB2 PHP Generator provides you with an ability to generate responsive pages that look beautiful on any device from a mobile phone up to an extra-large desktop. This option allows you to select the minimum resolution of devices the column will be visible at. Live Demo.

 

Available values correspond to the device widths as follows:

 

Phone

The column is displayed on all devices.

Tablet

The column is displayed on all devices with width greater than 768px.

Desktop

The column is displayed on all devices with width greater than 992px.

Large desktop

The column is displayed only on devices with width greater than 1200px.

 

Fixed column width

To set a fixed width for a column, check the Fixed width, specify the Width and select the Units. You can use both relative-length (like px or mm) and absolute-length (em, rem, etc) units. Live Demo. More about CSS units.

 

Totals

This option allows you to enable a grid footer to display summaries (Sum, Average, Count, etc) for the selected column. Live Demo.

 

Edit/Insert

Allows you to select a control to be used for the selected column in Edit and Insert forms and customize the control's properties.

 

 

Filter Builder

Here you can specify operators to be allowed for the selected column in the Filter Builder dialog. To select the operators, open the drop-down list and select/unselect the corresponding options.



Prev Return to chapter overview Next