Data Grid Collection

The Record control renders the currently selected record in the collection using the Data Grid Container component. It presents all fields, tables, and nested sections for the active record, allowing users to review, edit, and validate its contents.

Interactive Components

• Displays all child fields, tables, and sections for the current record.
• Supports direct editing, validation, and error highlighting for each field.
• Integrates with context menus and keyboard navigation for efficient review.

How to Use

• Navigate to a record using the Page Navigator or keyboard shortcuts.
• Edit values, confirm entries, and resolve errors within the displayed record.
• Use context menu commands to perform record-level actions.

The Virtual Table control displays tabular data for a Virtual Table Definition in a spreadsheet-like grid. It is designed for reviewing, editing, and validating rows and columns of structured data within the Data Grid.

Purpose and Functionality

• Renders the contents of a Virtual Table Definition, displaying each row and column according to the selected collection and fields.
• Supports navigation, editing, and validation of individual cells, rows, and columns.
• Adapts to different table layouts, including single-row, multi-row, and changeset views.
• Integrates with error handling, change tracking, and workflow commands for efficient review and correction.
• Table columns are defined by a Virtual Table Definition defined on the Data View.

Interactive Components

• Rows and Cells:
  Each row represents a record from the selected collection, and each cell corresponds to a Data Field or Data Column chosen in the Virtual Table Definition.

  • The 'Cells' control renders all visible cells for each row, supporting direct editing and validation.
  • Visual indicators highlight errors, required fields, and workflow status.

• Table Header:
  Displays column headers with field names, tooltips, and data types.

  • Supports sorting by clicking header buttons; sorted columns are visually indicated.

• Caption Area:
  Shows the collection name and total record count.

  • Displays a warning icon and tooltip if errors are present in the underlying data.

• Context Menu:
  Provides table-level commands via a right-click menu, including actions such as sorting, copying, or exporting data.

  • The 'MenuModel' control adapts its available commands based on the table's state and workflow context.

• Paging and Scrolling:
  Supports paging for large tables, allowing users to skip and display a configurable number of rows.

  • Use arrow keys to move through cell contents and between cells.
  • Use Ctrl + arrow keys to move from cell to cell.

Keyboard Shortcuts

• Arrow Keys: Move through cell contents and between cells.
• Ctrl + Arrow Keys: Move directly from cell to cell.
• Tab / Shift+Tab: Move between fields and rows.

Styling and CSS Class Names

This control and its child elements are assigned specific CSS class names to enable custom styling. These class names can be used from the CSS property of the Data Model to apply custom styles to a Virtual Table:

• The main control uses VirtualTable.
• Each column header uses DataColumn and the code name of the field (e.g., DataColumn Item_No).
• Each cell uses DataColumn and the code name of the field or column.
• Each row uses VirtualTableRow and may include data attributes for order and line count.
• Each field within a cell is rendered as a Data Grid Field, which itself uses the DataGridField class and the code name of the field or column.
• Additional classes may be applied based on field configuration, such as custom CSS classes set on the Data Field or Data Column.

These class names allow you to style the table, rows, columns, and individual cells with high precision. For example: .VirtualTable { border-collapse: collapse; } .DataColumn.Quantity { text-align: right; } .DataGridField.Confirmed { background: #e6ffe6; }

For more information on CSS scoping and best practices, see CSS Builder.

Error Handling and Validation

• Highlights invalid or missing values within the table, rows, and cells.
• Integrates with change tracking and validation workflows, supporting error navigation and correction.
• Provides commands for clearing all rows, validating data, and rubberbanding new rows.

Accessibility & Usability

• Keyboard navigation is fully supported for efficient review and editing.
• Context menus and buttons provide quick access to common actions.
• Paging and scrolling controls help manage large tables.
• Visual cues guide users to errors, required fields, and workflow status.

Example Workflow

1. Open a document in the Data Grid.
2. The VirtualTable displays the selected collection, such as invoice line items or transaction logs.
3. Review and edit cell values, insert or delete rows as needed.
4. Use context menu commands to sort, copy, or export data.
5. Save changes and resolve any errors or validation issues.

Related Concepts

• Data Grid: Hosts the VirtualTable for each table in a document.
• Virtual Table Definition: Configures the collection and columns displayed.
• Data Field, Data Column: Define the structure and extraction logic for each cell.
• Context Menu: Provides table-level commands and workflow actions.
• CSS Builder: Manages styling and appearance for tables, rows, and cells.

For more information, see the documentation for Data Grid, Virtual Table Definition, Data Field, and CSS Builder.

The Pager control provides paging functionality for the collection, enabling users to move between records using toolbar buttons or keyboard shortcuts.

Interactive Components

• Displays page navigation controls (first, previous, next, last) in the toolbar.
• Shows the current record number and total count.
• Supports keyboard navigation:
  • Tab and Shift + Tab to move between records.
  • Arrow keys to change pages when focused.

How to Use

• Click navigation buttons in the toolbar to move between records.
• Use keyboard shortcuts for quick navigation.
• The Pager updates the displayed record and synchronizes with the Record control.

Example

> Use the Pager to quickly review all line items in an invoice or all claims in an EOB by paging through each record.

For more information, see the documentation for Page Navigator.

The ContextMenu control presents a menu of commands relevant to the collection, accessible via right-click or keyboard shortcuts.

Interactive Components

• Displays collection-level commands such as:
  • Append Record (Ctrl + Insert)
  • Insert Record (Ctrl + Shift + Insert)
  • Delete Record (Ctrl + Delete)
  • Merge With Previous (Alt + P)
  • Move Previous (Ctrl + Shift + Left)
  • Move Next (Ctrl + Shift + Right)
• Commands are shown in a context menu and can be executed with mouse or keyboard.
• Menu supports navigation with arrow keys, Home/End, and quick search by typing.

How to Use

• Right-click anywhere in the collection to open the context menu.
• Select a command to perform actions such as adding, deleting, merging, or moving records.
• Use keyboard shortcuts for faster access to common commands.