Support > Repository > Screen function > Search/List display (list display) Using the grid

Wagby's "grid" is a part that realizes a highly functional list display. You can rearrange the columns, set the width, and hide them at run time. R7.10.1

Activate "Show in grid" in "Screen> Search ยท List display" of target model.(In this case, "Display search screen and list display screen at the same time" is also automatically enabled.)

Figure 1 Settings displayed in the grid

When "display in grid" is enabled, the REST API function of this model becomesAutomaticallyIt becomes effective.(There is no need to set it manually.)

Figure 2 REST API is enabled

Here is an example of the list display displayed in the grid.

Figure 3 List displayed in grid

Sort (rearrange)

Sorting is done by clicking the column name.Click again to switch ascending and descending order.

Figure 4 Sort by item
Figure 5 Click to switch between ascending and descending order

Move column

You can move columns by drag & drop.

Figure 6 "Phone number" column moved by drag & drop
The column display sequence is stored for each user.(Exactly it is saved in the cookie of the web browser.Even if you log on again, it will be restored.

Changing the display width of columns

You can change the column display width by dragging and dropping.

Figure 7 Changing the display width of each column
The display width of the column is stored for each user.(Exactly it is saved in the cookie of the web browser.Even if you log on again, it will be restored.

Hide columns

When you press the "+" button at the right end of the grid, a list of display target column names is displayed.

Figure 8 List of target column names

Columns can be hidden.

Figure 9 "Customer ID" column hidden
The non-display setting of the column is memorized for each user.(Exactly it is saved in the cookie of the web browser.Even if you log on again, it will be restored.

You can change "simultaneous display number" at the lower right of the grid.Pagination changes at the same time as changing.

Fig. 10 Changing the number of simultaneous display
Figure 11 Pagination also changed
The selected value is memorized for each user.(Exactly it is saved in the cookie of the web browser.Even if you log on again, it will be restored.

Configuration

"Simultaneous display number pattern" prepared on the search/list display tab in the screen tab is reflected.Multiple numbers can be specified with a comma delimiter.

Fig. 12 Setting the pattern of simultaneous display number
By setting this value to one (example 100), the list box of FIG. 11Hide.The number of indications is fixed and it is treated as unchangeable.
If this value is left blank, it is treated as "10".(Because the value is a single value, the list box is also hidden.) Also, negative numbers can not be specified.

You can specify the vertical size of the grid.The vertical scroll bar is displayed.

Fig. 13 Vertical size fixed (vertical scroll bar is displayed)

Definition method

The scroll type of the list display part is "fixed header column".At the same time, specify the height of the table when header rows are fixed.Please specify the unit as pixel (px) or em (em).

Figure 14 Header column setting

You can retrieve data as needed when operating the scroll bar without using pagination.(Called OnDemand Grid.)

Figure 15 Required data is read in conjunction with the scroll bar

Definition method

Unset the "Display pagination" setting.In addition, specify the scroll type of the list display part as "fixed header column" and the table height when header row is fixed.Please specify the unit as pixel (px) or em (em).

Figure 16 Unpinning the pagination
Please read "Batch Processing> Setting with Grid".

You can use the settings of the grid (display/non-display of the columns and arrangement) commonly among different users.

Preference common setting principals

Specify an account that can publish the settings of the grid.This is provided as "preference common setting management".In this example we will grant it to the account "User 1".

Figure 17 Preference Common Settings Administrative Principal

Publish settings

Log on with account "User 1".A column is provided at the bottom of the list display grid that allows you to enter common setting names.

Figure 18 Common setting name input field

Let's change the standard column setting here.

Figure 19 Changing column settings

After changing, enter 'Customer list user 1 setting' as common setting name.(The name is optional.)

Figure 20 Enter common configuration name

When you move the cursor, the "save" button will be displayed, so press this.

Figure 21 Saving common settings

Reuse common settings

Log on with account "User 2".User 2 is not granted the "preference common settings management" principal.Therefore, you can not register common settings, but you can select existing settings.

Figure 22 Selecting the saved common settings

When you load common settings, the column settings are changed.

Figure 23 Common settings reused

Restore the standard settings

To return to the standard setting specified in the repository (design information), select "Clear Grid Setting".

Figure 24 Clear Grid Setting

It returns to the standard setting.

Figure 25 Restored to standard settings

specification

  • Searching and listing are collected on one screen.The search screen and the list display screen can not be separated.
  • The "Display horizontal scroll bar in list display part" setting is invalid.Side scroll bars are automatically displayed as needed in the grid.
  • It is not possible to individually invalidate functions provided by the grid (sorting, rearranging columns, setting column widths, hiding columns).
  • Sorting and rearranging columns in the grid is valid only in the grid.Sorting and column sorting settings are not reflected in other screen functions (screen of print format display, CSV download etc).

About item type

  • Composite primary key is not supported.
  • E-mail address, URL, and file are displayed as character information, not link format.
  • The file type item icon is not displayed in the grid.

Unavailable settings

Refine setting

"Refer to other models" Narrow down the choices by the relationship between reference models> Troubleshooting> Do not narrow the screen on the list display screen ".

performance

In grid display, users can set non-display of columns at run time.For this reason, in the model definition, it may be assumed that the operation of enabling the list display setting of all items and allowing the user to freely select the display column.But in that case,Since the data to be displayed is once created on the server and sent to the browser, the performance will degrade.

At the design stage, please limit the items required on the list display screen as much as possible, and further make the user select display display.