Displays the referenced model in checkbox format. Multiple values ​​can be selected.

Example of operation

Prepare the district model in advance as shown in Fig. 1.

Figure 1 Pre-prepared district model

Figure 2 shows an example screen that selects the value of this district model with a check box. You can select the name of the referenced model "district" from the check box.

Figure 2 Operation example of check box

Definition method

In the customer model shown in Figure 2, the type of the district item is referred to as "item reference of another model".(Figure 3)

Figure 3 Definition of customer model

In the type detail setting, the reference destination model is "district", and the item of the reference destination model which is the option of the check box is "district name". Select "Checkbox" as input type.

Figure 4 Setting to use the check box

You can select all the options at once.Please press the check all icon shown in Figure 5.

Figure 5 All check icon

After checking, the shape of the icon changes to an eraser.(FIG. 6)

Figure 6 Icon shape changed to eraser

By using the eraser function, you can cancel all selections at once.The icon returns to the full check.

Figure 7 When the eraser icon is pressed, the shape of the icon changes to all clear

Select all of the check boxes/Switch the state of the clear buttonEven when the check box is pressed downIt will be done.
If you check all the check boxes, it automatically changes to the clear button.If you uncheck one of all checked states, it changes to a full selection button.

Definition method

From the input control tab of the model item detail definition dialog, activate "Create clear button" in the model reference.(It is enabled by default.)

This setting is reflected in the registration, update and search screens.

Figure 8 Creating a clear button

Example of operation

You can specify the initial value of the check box.When opening the new registration screen of the customer model, we will explain an example of selecting "Hokkaido" "Tohoku" "Hokuriku" "Kanto" into the selected state.

Check the value of the primary key (here, the district ID) of the target data.(Figure 9)

Fig. 9 Check the primary key of the data used as the initial value

When you open the new customer model registration screen, you can see that the data in Figure 5 is selected as the initial value.(FIG. 10)

Figure 10 Example of screen when initial value is set

Definition method

Specify the primary key of the target data.If the target is a check box, you can specify multiple values ​​separated by commas.

Figure 11 Setting the initial value of the new registration screen
The value of the primary key is never changed during system operation.
This method can be used only when the referenced model is a single primary key and an integer type.

Special notation on checkbox/Application example

"Initial value> check boxIt is summarized in.There are ALL notation for full selection and techniques that can be used in combination with functions.

Changing display order of options in option modelYou can set the same rule as for any model.

Detail is,List box descriptionPlease read.

Invalidating options in option modelYou can set the same rule as for any model.

Detail is,List box descriptionPlease read.

Invalid items in the option model are also to be searchedYou can set the same rule as for any model.

Please read the link above for setting.

Example of operation

The check box is set to display four choices per line by default.

Fig. 12 Wrapping in four views

If you specify this as wrapping every eight times, it will be displayed as shown in Figure 12.

Figure 13 Wrapping in Eight Displays

Definition method

From the Input Control tab of the Model Item Detailed Definition dialog box, specify the number of checkbox/radio button wraps in the model reference.The standard is "4".

Figure 14 Setting number of turnaround

When switching on search screen

"Search control> Model reference> Switch display modeThis setting will also be reflected even if you specify.

For example, if you set it as a check box on the registration or update screen but as a check box on the search screen, this setting is used for the number of items to be wrapped for the search screen.

Example of operation

On the detail display screen, a check image is displayed next to the selected data.(FIG. 15)

Figure 15 Check image displayed (standard)

You can hide this check image.(Figure 16)

Figure 16 Example of check image being hidden

Definition method

Opens the Output Control tab of Model Item Detail Definition.Activate "Do not display images when selecting check boxes" of the model reference prepared in the detail screen.(By default, it is invalid.)

Fig. 17 Setting not to display images when checkbox is selected
This setting is effective only on the detail screen.Settings for the list screen are also available separately.

Example of operation

You can set "number of wraps" and "toggle display of check images" on the list display screen.
Figure 18 shows an example of a list display screen with the wrapping number set to "1" and the check image hidden.

Figure 18 List screen example

Definition method

Select the "List screen" tab in the output control tab of the model item detail definition dialog.Set "Do not display the selected image of the check box" in the model reference field, "Display number of check box/radio button displayed on one line" respectively.

Figure 19 List screen setting

Example of operation

On the detail screen, only the selected item is displayed.This is the standard behavior.

Figure 20 Display on Detail Screen

If you set the item name which was not selected, it will be as follows.

Figure 21 When setting to display item names not selected is enabled

Definition method

Activate the "Display unselected item names" setting that is provided for options in the model item type detail setting dialog.

Figure 22 Model Item Type Detailed Settings Dialog
This setting is also reflected on the list screen.

Example of operation

We will introduce examples where you can select up to three from multiple choices (choose four or more to select an input error).

Figure 23 Selecting an error results in an error

Definition method

In the user definition check column in the input check tab of the model item detail definition dialog,Acceptable (no error) condition.You can also set the error message.

Figure 24 User Defined Check Settings
CHECKED(${myhobby})<=3

Detail is"User defined checkPlease read.

You can change the input type of the registration/update screen and search screen.

For details of switching method,List box descriptionPlease read.

To manage the value selected in the check box, another table is prepared.

FIG. 25 shows a table prepared as a standardAccount model (juser)Excerpted from the table structure of.The "belonging group (jgroupid)" item refers to the model using the group model (jgroup) as a checkbox.This item does not exist in the juser table.Instead, a table named "juser $ jgroup" is created.

Figure 25 Table image
  • The table name is "model name $ item name".
  • Holds the primary key of the juser table to which it belongs.
  • A column named "item name jshid" is automatically added.This is also part of the primary key.This is prepared as an index column for internal management.
  • The value of "item name jshid" starts from 0.Also there is no jump number.

In a state where none of them are selected, there is no data in another table.The value actually held (in the above example, the value of the jgroupid column) is the primary key of the referenced model (jgroup).

When operating the database directly, please observe the rule "item name jshid" starting from 0 and without jump number.In case of inconsistency, the check box item will not function.

If the primary key of the referenced model is a compound key, this function (referred to as a check box) can not be used.