1. Form Design Aid Guide
  2. Loading and Processing Behavior

Loading and Processing Behavior

FDA provides some options to automate fetches. You can choose to load the grid based on the fetch logic when the user launches an application if the grid resides on a find/browse or headerless detail form. Use automatic loading options with care; in some cases, enabling these features can have a significantly negative impact on performance.

Especially in HTML environments, the page-at-a-time processing feature can enhance performance. This option enables you to populate the grid at the rate of one page at a time (the runtime engine only loads enough data to fill the grid, and then loads enough data to fill the grid again if the user clicks Next). Page-at-a-time processing is enabled by default, and the JD Edwards standard is to leave it enabled for all form types.

Desired Result

Navigation

Notes

Enable users to select multiple rows.

Select the grid control and set Multiple Select to Yes.

Change the sort order.

Select the grid control, select Column Sort Order, and launch the Grid Properties form.

Move columns to the right that you do want to sort on.

Load a different data item.

Select a column, select Data Item Information, and launch the Grid Column Properties form.

Select the Data Items tab and select the data item to use.

Load data at the rate of one grid page at a time (page-at-a-time).

Select the grid control and set Disable Page-at-a-Time Process to No.

Load data automatically upon changes in a related (child) form.

Select the grid control and set Auto Find On Changes to Yes.

Use this option only on forms that have no modeless form interconnections.

Prevent users from importing or exporting files.

Select the grid control and set one or more of these properties to No:

  • Display Import from Excel

  • Display Export to Excel

  • Display Export to Word

If a property is disabled, the system will not display the related option icon or menu item.

Process all the grid rows on a database commit, not just the ones that changed.

Select the grid control and set Process All Rows in Grid to Yes.

When enabled, this property causes runtime to apply row changed and row exited logic to all rows, no matter their state.