Unified Table Interface for Multi-Query Aggregation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional interfaces for managing multiple queries in supply chain operations are inefficient, particularly when results from multiple queries need to be aggregated and manipulated for subsequent actions.
Innovation Solution
A graphical user interface with a single table layout, featuring a search pane at the top, a results section at the bottom, and a selected items section in the middle, allows users to input queries, display results, and selectively move items between sections for efficient aggregation and manipulation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If conventional interfaces are used to manage multiple queries in supply chain operations, then users can perform basic query functions, but the interface efficiency is low and the operation complexity increases when aggregating results from multiple queries
Solution Approach 1:
The patent combines multiple query result sets from different searches into a single unified table structure. Users can execute multiple queries and all results are displayed together in one interface, eliminating the need to switch between multiple separate query interfaces. This merging of results directly improves productivity by reducing the time and steps required to aggregate data from multiple sources.
Solution Approach 2:
The unified table provides multi-functional capabilities including displaying results from multiple queries simultaneously, allowing selective aggregation of specific rows, enabling various operations (view, edit, delete) on aggregated results, and supporting different query types. This universal interface replaces multiple specialized interfaces, reducing operation complexity while maintaining full functionality for managing supply chain data.
2Quantity of substance
If results from multiple queries are aggregated in conventional interfaces, then comprehensive data can be collected, but the time required to assemble and manipulate results increases
Solution Approach 1:
The system performs preliminary actions by automatically executing multiple queries and pre-aggregating their results into a unified table before the user needs to analyze the data. Instead of requiring users to manually compile results from separate queries, the interface proactively gathers and organizes all query results in advance, significantly reducing the time users spend assembling data while ensuring complete data collection.
Solution Approach 2:
The unified table acts as an intermediary structure that receives results from multiple different queries and presents them in a single organized view. This intermediary layer automatically handles the aggregation process, translating multiple separate result sets into one cohesive table that users can immediately analyze and manipulate, eliminating the time-consuming manual compilation step.
3Productivity
If a unified table interface is implemented to aggregate multiple query results, then interface efficiency and user productivity improve, but the interface design complexity increases
Solution Approach 1:
The unified table interface is segmented into distinct functional zones including a query input area, a results display area showing aggregated data from multiple queries, and a controls area for managing results. This segmentation allows the complex functionality to be organized into manageable, intuitive sections, improving user productivity by making the interface easier to navigate while the underlying design handles the complexity of multi-query aggregation transparently.
Data Source
AI summary
A graphical user interface including, in a single table, a search pane on a top portion, a results section on a bottom portion, and a selected items section in a middle portion between the top portion and the bottom portion is provided. Thereafter, first user-generated input is received via the search pane in the top portion of the table in the graphical user interface that specifies a first alphanumeric search query. In response, one or more data repositories are polled to obtain results responsive to the first alphanumeric search query. Once the results are obtained, one or more results responsive to the first alphanumeric search query are displayed in the results section. Each result responsive to the first alphanumeric search query is displayed in a respective row in the results section of the table. Each result responsive to the first alphanumeric search query further includes a first graphical user interface element in the corresponding row. Second user-generated input is received that selects one or more of the first graphical user interface elements in the results section. In response to such second user-generated input results corresponding to the selected one or more first graphical user interface elements are moved from the results section to the selected items section of the table such that results that do not correspond to the selected one or more first graphical user interface elements remain displayed in the results section. Related apparatus, systems, techniques and articles are also described.