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.
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.)
When "display in grid" is enabled, the REST API function of this model becomesAutomaticallyIt becomes effective.(There is no need to set it manually.)
Here is an example of the list display displayed in the grid.
Sorting is done by clicking the column name.Click again to switch ascending and descending order.
You can move columns by drag & drop.
You can change the column display width by dragging and dropping.
When you press the "+" button at the right end of the grid, a list of display target column names is displayed.
Columns can be hidden.
You can change "simultaneous display number" at the lower right of the grid.Pagination changes at the same time as changing.
"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.
You can specify the vertical size of the grid.The vertical scroll bar is displayed.
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).
You can retrieve data as needed when operating the scroll bar without using pagination.(Called OnDemand Grid.)
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).
You can use the settings of the grid (display/non-display of the columns and arrangement) commonly among different users.
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".
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.
Let's change the standard column setting here.
After changing, enter 'Customer list user 1 setting' as common setting name.(The name is optional.)
When you move the cursor, the "save" button will be displayed, so press this.
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.
When you load common settings, the column settings are changed.
To return to the standard setting specified in the repository (design information), select "Clear Grid Setting".
It returns to the standard setting.
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.