Column Settings Dialog

Dialogs Overview

In the Column Settings dialog, you can specify hiding/showing columns, set the display order and display widths of columns, and also create new properties (new columns).



The Column Settings dialog displays column information that is recorded in the table you selected and in the style applied to the table.
The caption of the dialog is displayed as "Column Settings" added by the name of the style that is applied to the currently opened view the last time. For example, "Column Settings - Name of the style".


(1) Filter (after Ver.12.0.2, Ver.13 restricted feature)

Properties are narrowed down to those that include the text entered in the text box in their code (internal name), display name, or alias and displayed in the list in (2).

The following image shows the Column Settings dialog for orders. The left image is the result obtained by entering "quantity" for the filter. The right is that obtained by entering "qty". The filtered result shows "Order quantity". This is because the property display name is "Order quantity" and the code (internal name) is Order_Qty. Therefore, it appears in both results. Note that a property’s long name up til the first underscore are not matched against the filter. For example given a property’s long name “Order_Qty”, the filter text “Order” will not match it. So, even if the filter text is “Order_Qty”, it will not filter to that property.

 

(2) Property list

Lists properties (columns) for which you can specify settings. Properties are listed according to the display order.

If you check a box for a property in the list, the property will be added to the table.
Unchecking a box for a property will remove the property from the table. Only the checked properties (columns) will be displayed in the table.
If you select a property (column) in the list, you will be able to specify attributes of the property.
Double-clicking a property in the list causes the corresponding property column on the table to be selected. This applies only to properties that are displayed. (After Ver.12.0.2, Ver.13 restricted feature)

(3) Class selection combo box

Lists types of records (class definitions) displayed in the table you selected.
If you select a class in the combo box, properties of the class you selected will be added at the end of the Property (column) list.

(4) Attributes of the selected column

Specify here the display of the property (column) you selected in the Property (column) list.

Display width

Specify here the width in pixel by which to display the column. Please specify a number larger than 0.

Display order

Order in which the column is displayed. Please specify a number. Specifying the smallest value means to display the property in the leftmost column of the table.

Summary type

Specify the summary type when grouping is used. Refer to here for details on summary type.

Hide column (You can redisplay the hidden column by selecting [Unhide Column] from the column header popup menu.)

Hides the property (column). You can redisplay the hidden column using [Unhide Column] in the column header popup menu of the table.

(5) Save in the current style

If you check this option, the settings you have made will be applied to the target view (the table from which the dialog was opened) and also the settings will be saved in the target style (that was selected when you opened the dialog) when closing the dialog using the OK button.
If you do not check this option, the settings will be applied only to the the target view (the table from which the dialog was opened) when closing the dialog using the OK button.

(6) New Property

Adds a new property to the class you selected in the Class selection combo box.

(7) Delete Property

Deletes a user added property. This is only valid when a user added property is selected in the property list.

(8) Upward

The user moves Property Position upward, which was selected in Property List. (This moves to the left on the table in terms of a row display)

(9) Downward

The user moves Property Position downward, which was selected in Property List. (This moves to the right on the table in terms of a row display)

(10) Reset

Ignores the contents you have edited so far and returns the dialog to the status when it was opened.

(11) Cancel All

Removes all the checks in the "Property (column)" list.

(12) OK

Reflects the contents you have set and closes the dialog. The way the contents are reflected differs whether you check "Save in the current style" or not.

(13) Cancel

Discards the contents you have set and closes the dialog.

 

References

The Column Settings dialog in Ver.12.0.1 and earlier is as follows.



HelpNo.:734700
© Since 2019 Asprova Corporation, All rights reserved.