Data Row List

Displays a list of rows returned from a database query.

Remarks

The Data Row List control presents the results of a database query as an interactive, tabular list within the Grooper web client. Each row in the list corresponds to a record from the underlying Data Table, and each column represents a field or property from the query results. This control is ideal for reviewing, selecting, and managing tabular data extracted from external databases or data sources.

UI Components

• Results Table:
  • Displays query results as rows, with columns for each field in the Data Table.
  • Column widths are configurable for optimal readability.
  • Supports both single and multi-selection for batch actions.
• Column Headers:
  • Show field names as defined in the Data Table.
  • Columns are generated dynamically based on the schema of the query results.
• Row Attributes:
  • Selected and focused rows are visually highlighted.
  • Custom HTML attributes can be added for integration with scripts or styling.

Interactive Features

• Selection Controls:
  • Click to select a row; use Ctrl + click for multi-select, Shift + click for range selection.
  • Supports batch operations on selected items.
• Keyboard Navigation:
  • Up/Down: Move between rows.
  • Home/End: Jump to the first or last result.
  • Shift + Up/Down: Multi-select.
• Dynamic Column Generation:
  • Columns are created for each field in the Data Table, supporting flexible display of any tabular schema.
  • Column widths can be set to ensure all values are visible.

Usage Guidance

Use Data Row List to review and interact with the results of a database query or tabular data source. Configure the Data Table to select the desired fields for display. Leverage multi-select and keyboard shortcuts for efficient batch operations and navigation.

• For large result sets, use column sizing and selection features to quickly locate and act on relevant records.
• Integrate with client-side scripts using row data attributes for advanced workflows.
• Use custom column names to provide user-friendly labels in the results table.

Example

// Example: Data Row List columns | Customer Name | Order Date | Amount | |---------------|------------|----------| | Acme Corp | 2025-07-21 | $1,200.00| | Beta LLC | 2025-07-20 | $850.00 |

Accessibility

• Fully navigable by keyboard and mouse.
• Screen reader support for row and column data.
• Visual highlighting for selection and focus.

For more information, see the documentation for Data Table, Data Column, and Object List.

Used By

Imports PageActive Task ListAI Assistant - Chat HistoryFRX VisualizerNode FinderWeightings ListCMIS Tree BrowserCMIS Connection - GeneralCMIS Repository - TypesData Connection - GeneralList SearcherLookup ResultsService CollectionACL EditorChoice EditorCollection EditorOrdered Reference Editor