Lookup Results

A UI which allows users to manually execute Lookup Specifications and resolve duplicate matches in the Data Grid.

Remarks

Overview

The Lookup Results control provides an interactive interface for running lookups against external data sources and resolving results for fields in a Data Grid. Users can select a lookup, enter criteria, execute the lookup, and choose from multiple returned matches.

Purpose and Usage

• Use this control to validate or populate field values by querying external databases, web services, or other sources.
• Supports manual execution of lookups, enabling users to review and resolve ambiguous or duplicate results.
• Designed for data entry, review, and correction workflows where external validation is required.

UI Components

• Lookup List:
  Displays all available Lookup Specifications in scope for the current data context.
  • Select a lookup to view and enter criteria fields.
  • Each lookup row shows its type and context.
  • Example: Vendor Lookup, Invoice Validation
• Criteria Entry Panel:
  When a lookup is selected, the criteria fields are displayed for user input.
  • Enter values for each required field to define the lookup query.
  • Example: Vendor ID: 12345, Invoice Number: INV-2025-001
• Result Set:
  After executing a lookup, results are shown in a tabular grid.
  • Each row represents a possible match from the external source.
  • Double-click a row or press Enter to apply the result to the document.
  • Example: Vendor Name | Address | Status
• Diagnostics Button:
  View detailed diagnostics for the previous lookup execution.
  • Click to open a diagnostics viewer for troubleshooting or audit.

How to Use

1. Select a lookup from the Lookup List.
2. Enter criteria values in the input fields.
3. The lookup is executed automatically when criteria change, or manually via context menu.
4. Review the results in the Result Set grid.
5. Double-click a result or press Enter to apply it.
6. Use the diagnostics button to view details about the lookup execution.

Keyboard Shortcuts

• Enter: Apply the selected result.
• Esc: Close the dialog.
• Up/Down: Navigate lookup or result lists.
• Ctrl + F: Focus the criteria input.

Child Controls

• Reflection List: Displays the list of available lookups.
• Data Row List: Shows the results returned from the lookup.
• Splitter: Allows resizing between lookup and result panels.
• Diagnostics Button: Launches the diagnostics viewer for troubleshooting.

Examples

• Vendor Lookup:
  Lookup: Vendor Lookup Criteria: Vendor ID = 12345 Results: ACME Corp | 123 Main St | Active
• Invoice Validation:
  Lookup: Invoice Validation Criteria: Invoice Number = INV-2025-001 Results: Invoice Date | Amount | Status
• Resolving Duplicates:
  Multiple results returned for "Vendor Name". Select the correct row and double-click to apply.

Additional Features

• Results update automatically when criteria change.
• Diagnostics viewer provides detailed logs and troubleshooting for lookup execution.
• Supports context menu actions for advanced operations.

For more information, see the documentation for Lookup Specification, Data Grid, and Object List.

Child Controls

Name	Type		Summary
Lookup List	Reflection List	►	The list of lookups in scope. Overview The Lookup List displays all Lookup Specifications available for the current field or container. Usage Select a lookup to display its criteria fields and prepare for execution. Each lookup row shows its type, context, and relevant attributes. Attributes such as data-container-id and data-lookup-index are used for context and execution. Example Lookup Type | Context -----------------|----------------- Vendor Lookup | Vendor Section Invoice Lookup | Invoice Table
Result Set	Data Row List	►	The result set from running the currently-selected lookup. Overview The Result Set displays the results returned from the selected lookup. Usage Review possible matches from the external data source. Double-click a result or press Enter to apply it to the document. Results are shown in a grid with columns for each returned field. Example Vendor Name | Address | Status -----------------|----------------|-------- ACME Corp | 123 Main St | Active WidgetCo | 456 Elm Ave | Inactive