If the amount of data to be referenced is large, you can use refinement using the search screen.

An example

In the estimate model prepared in Figure 1, we refer to the customer field from the customer model.When you click on the "Search" button prepared next to the entry field, the search screen shown in Figure 2 opens.

1 Press the "Search" button on the new registration screen of the quotation

In the search screen of Figure 2, narrow down by search criteria and then press the "to list view" button.

Figure 2 Customer search screen

Select the value (here the name) that is on the left side of the list display screen.Specifically, click with the mouse.

Figure 3 List display screen

The customer is selected.

Figure 4 Customer selected

Definition method

Opens the type detail setting dialog of model item.Select "Search screen" as input type.

Fig. 5 Setting to use search screen

The input field length is determined by the following rule.

  • You can change the input field length.For details, please read "Input control> Input field length".
  • If you do not specify the input field length, the web browser will automatically adjust it.
  • Items prepared in the repeating container use all the widths of the column of the container by standard, so style designationwidth:100%Is set implicitly.The same style specification is applied when this item is used as a search condition.To change this behavior, specify the input field length.

An example

To cancel the selected content, press the clear button (icon with an eraser shape) prepared next to the item name.(The explanatory note will be displayed when you hover the mouse cursor.)

Fig. 6 Clear button to release selected state

The selected state is canceled.(FIG. 7)

Figure 7 Returned to unselected state

Hide the clear button

Invalidate "Create clear button" of the model reference prepared in the input control tab of the model item detail definition dialog.(FIG. 8)

Figure 8 Creating a clear button

An example where the clear button is not prepared is shown in Fig.In this case, once you select something, you can not return it to the unselected state.

Figure 9 Clear button is hidden

When this setting becomes invalid

If you set the search button to non-display, this clear button will also automatically be hidden.

An example

An example of changing the standard "Search ..." button to "Detect" is shown in Figure 10.

Fig. 10 Changed the button name to "Detected"

Definition method

Opens the input control tab of the model item detail definition dialog.Activate "Show buttons" in "Model reference (search)" and enter the button name.

Figure 11 Setting the button name
In addition to the registration/update screen, this setting is also reflected on the search screen.

Search screen (subwindow)You can specify the standard height and width.The initial value is 500 pixels.

This setting is common across applications.
Suggest is offering usability equal to or higher than this function.In the suggestion function, you can enter not only the value of the primary key but also the values ​​of other items.Although the following explanation is left for compatibility with the old version, we recommend that you use the suggestion as much as possible.

An example

You can directly enter the primary key of the reference model and reference the value.It is effective for business use when the primary key is used as the business code and the operator at the site remembers the coding system.

In Figure 12, the product code is entered directly."Search ..." button is not provided.

Figure 12 Directly entering the code

Corresponds to the product code Product name and price are displayed in conjunction.(FIG. 13)

Fig. 13 Reference linkage of product name and price by product code

This is an example of entering multiple product information.(FIG. 14)

Figure 14 Managing product information as a statement

If you enter a product code that does not exist, an error occurs when the save button is pressed.

Figure 15: Nonexistent code gives error

Definition method

Prepare the item code item in the estimate model as the input slip.(Figure 16)

Figure 16 Preparing item code items

The input type is "search screen".The reference model item specifies the primary key item.Let's assume that the primary key plays a role as a business code.

Refer to Figure 17. Set the model item as the primary key item

Opens the model item detail definition dialog.Activate "enable value input directly" in the "Model reference (search)" column in the input control tab.At the same time, disable "Show buttons".

Figure 18 Allowing you to enter values ​​directly


  • In this setting, you will directly enter the primary key item of the referenced model.Items other than the primary key are not supported.
  • This setting and "automatic calculation" can not be defined at the same time.
  • This setting can not be used for reference linkage.
  • If the primary key of the referenced model is a compound key, this setting can not be used.(Multiple code entry fields are not prepared.)
  • If the item of the referenced model isSuggest, You can not use it together with this function.Please use a suggestion.
  • This setting isRefine byCan not be used in conjunction with.The refinement is realized by the description of "$ {content_ 6 _ name}" below.

An example

The input value of the registration/update screen (main window) can be passed as the search value of the search screen (sub window).

Here is an example.The item "customer name" in the "business report" model refers to the "customer" model.
Here, we reuse the value of the item "job type" of the "business report" model as the search condition (of the "customer" model).

As shown in Fig. 18, set the value in advance in the column of occupation and press "Search" button.

Fig. 19 Press the search button

You can see that the value of the main window (business report) has been passed to the subwindow (customer model search screen).(Figure 20)

Fig. 20 Passing Search Conditions

Definition method

The definition of the customer model is shown in Fig."Industry type" item (jobtype) is used as a search condition.

Figure 21 Defining customer model

Figure 21 shows the definition of the sales report model.In the same way, specify "industry type" item (customertype) to be delivered as search condition as search condition.

Figure 22 Defining the business report model

"Customer name" in the business report model refers to the customer model.The input type is the search screen.(FIG. 23)

Figure 23 Related settings

Setting refinement

Here, we associate the item "industry type (customertype)" in the business report model (own model) with "business type (jobtype)" of the reference destination model "customer".This is the narrowing-down setting shown in Fig.

Figure 24 Relating items in both models (narrowing down)

Pass fixed value

In Figure 24, we specified the item name (which holds the value to be passed), but you can pass a fixed value.(FIG. 25)

Figure 25 Passing fixed values


  • If this item is set to "search condition", this narrowing down setting will also be valid on the search screen.Therefore, the "item name" specified in Figure 23 must also be the search condition.(Items not prepared on the search screen can not be passed to the subwindow.)
  • This function does not work on the list update screen and the child model simultaneous update screen.
  • Read-only items (including items calculated by calculation) in the main window can not be passed to search conditions in the subwindow.It is an item prepared as an input column that can pass.Hidden items are available.

In addition to narrowing down by string type as in this example, you can also set refinement using model reference items.For details, please read "Restrict options by value of other items".

Application example

Please read "Suggest".

You can hide the reset button on the search subwindow screen.

Release "Reset button (Search screen)" of "Screen> Search · List display> Button display".It is enabled by default (it displays reset button).

Fig. 26 Reset button (search screen) display setting

An example is as follows.The reset button is not displayed.

Figure 27 Reset button is not displayed
When using the search subwindow screen of model A in models B, C, D, the reset button on the search subwindow for model A in all cases is hidden.For this reason, for example, in model B, you can not make individual specifications such as wanting to display a reset button when using the search sub window display of model A.

If the reference data has been deleted, "Detailed data" will be displayed on the detail display screen.

Change wording

You can change this wording "nonexistent data".

1. The subwindow does not use exactly the same items as the list display screen, but the items referenced on another model reference (search screen) may be automatically added to the list.It is difficult to automatically adjust the layout furthermore with Wagby's added items automatically added to the layout prepared by the developer, so the layout setting is not reflected in the subwindow.