Using the List View Grid Format (Release 9.2.0.5)
List View grid format is one of the grid formats that you can use to find and view records. List View grid format enables you to stack columns vertically so that the information displayed is compact and easy to find. Using the Grid Format Manager, you can select the grid columns you want to include in your List View grid format, and then group them in the way you want them displayed.
Your ability to create a grid format depends on whether your system administrator has enabled the Personalize Grid icon. If you do not see the Personalize Grid icon in the bar located at the top of the grid, you do not have permissions to personalize the grid.
For more information on using the Grid Format Manager to create and modify List View Grid Formats, see "Grid Formats" in the JD Edwards EnterpriseOne Tools Using and Approving User Defined Objects Guide.
List View Grid Format User Interface
When you open a form with a default List View grid format, the form displays the grid with only those fields that have been added to the List View grid format. The fields are displayed in the same order in which they were arranged while creating the List View grid format. The field width and alignment of the labels and values are displayed as specified when the grid format was created. The List View grid format is also supported in the Visual Assist forms.
When a record in the grid contains underlined text, it indicates a hyperlink. Clicking the hyperlink text opens the form associated with the text. A paper clip icon in the grid row indicates that attachments exist for the corresponding record. Clicking the paper clip icon opens the Media Object Viewer form and displays the attachments.
Similar to the Table View grid, the List View grid format supports data privacy and data masking. For more information about data masking, see "Display Rule" in the JD Edwards EnterpriseOne Tools Data Dictionary Guide.
Pointing to a field in the grid displays the field's label and its value as Hover Text. This is helpful when data in the grid is truncated due to resizing of the field width.
Fore more information, see "Changing the Field Width" in the JD Edwards EnterpriseOne Tools Using and Approving User Defined Objects Guide.
Fetching Records
When the grid retrieves the records that match the search criteria, the grid header bar displays the record range. EnterpriseOne categorizes the records into groups so that you can view several records at a time. The default number of records in a group is 20. You can click the Next button in the header bar to fetch the next set of records to be displayed in the List View grid. To retrieve all records, click the Go to End button located on the header bar of the grid.
Filtering Records
The header bar of the List View grid contains the Search field that can be used for filtering the records in a grid. Filtering is applicable only to the primary rows of the List View grid. You can filter records by entering text or numbers in the Search field, and then clicking the Find button or pressing the Enter key.
You cannot to use the wildcard characters * or% in the Search field. EnterpriseOne automatically applies a wildcard character to the searchable text fields in the primary row based on the value entered in the Search field. When you enter a numeric value in the Search field, only records that exactly match the value are displayed.
Sorting Records
You can sort the records in the List View grid using the Sort By drop-down list located in the header bar. You can select the field you want to sort by from the drop-down list, and the records are sorted in ascending order of the selected field. You can sort the records on just a single field. List View grid does not support sorting in descending order. The sorting order is reset to default when a Search filter is applied.
Selecting Records
In the List View grid, you can select a single record, multiple records, or a range of records. You can select a single record or multiple records by clicking anywhere on the corresponding grid rows. The selected row is then highlighted as indicated by the change in background color. You can select multiple records only if the grid is enabled to support multi select in Form Design Aid.
To select a range of records, click the start record, and while pressing the Shift key on your keyboard, click the end record. You can expand the range of records you have already selected by pressing the Shift key and clicking a different end record. The "start record" is the first row you click to begin selecting a range of records. The "end record" is the last grid row you click to end selecting a range of records.