Support > Repository > Referencing other models > Search screen
ja | en

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

Example of operation

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

You can change the input field length.For details, refer to "Input control>Input field length> Search screenPlease read.

Example of operation

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.

Example of operation

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.
Usability equivalent or superior to this function is described as "SuggestWe offer it.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.

Example of operation

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.

Example of operation

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

Setting 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.Detail is"Narrow down choices by value of other itemsPlease read.

Application example

"SuggestPlease read.

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.