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

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 the following two settings on the "Screen> Search/list display" tab.

  • Search/list display screen> Simultaneously use the search screen and the list display screen
  • List display screen> Display with grid
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)

Setting 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

Setting 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
"Batch processing> Setting in the grid」をお読みください。

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).
  • Pagination can not be hidden.It is always displayed. (It was improved in R7.11.)

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.
  • Items in the repeating container are not displayed in the grid.(It was improved in R7.11.)

Unavailable settings

Refine setting

"Reference to other models> Refine choices by relationship between reference models> Troubleshooting> Narrowing does not work on list display screenPlease read.

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.