Dynamic Column Value Help via Metadata Binding
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing graphical query interfaces do not provide value help features in input fields for dynamically selected columns, making it difficult for users to select appropriate values for filling in input fields.
Innovation Solution
A method and system that generates user interface elements with name and value input fields, binding them to metadata attributes and using query descriptors to provide Extended Value Selector (EVS) and Object Value Selector (OVS) help features, enabling users to select values from lists or execute queries to retrieve appropriate values for input fields.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If graphical query interfaces allow dynamic column selection, then user flexibility and query adaptability improve, but the complexity of providing appropriate value help features increases
Solution Approach 1:
The patent creates a universal value help mechanism that automatically adapts to any dynamically selected column by binding to metadata attributes. Instead of implementing separate value help features for each column type, the system uses a single generic query interface that retrieves and displays appropriate values based on the selected column's metadata, making the value help feature universally applicable across all dynamic columns.
Solution Approach 2:
The system performs preliminary actions by pre-defining the generic query structure and metadata binding rules before the user selects columns. When a user dynamically selects columns, the value help feature is already prepared to automatically retrieve and display appropriate values based on the column's metadata attributes, eliminating the need for complex real-time analysis of each column type.
2Ease of operation
If no value help features are provided for dynamically selected columns, then the system complexity remains low, but user ease of operation deteriorates
Solution Approach 1:
The value help feature operates autonomously by automatically retrieving values from the database based on the selected column's metadata. The system binds the generic query to the column's metadata attributes and displays appropriate values without requiring manual configuration or complex user input, making the feature easy to use while maintaining low system complexity.
Solution Approach 2:
The patent introduces a generic query as an intermediary between the user and the database. This intermediary automatically retrieves appropriate values based on metadata binding, simplifying the user's task of selecting correct values while avoiding the need for complex hard-coded value help features for each column type.
3Reliability
If value help features are implemented for all possible column types, then completeness of value assistance improves, but system complexity and development time increase
Solution Approach 1:
Instead of implementing separate value help features for each column type, the patent creates a single universal generic query mechanism that works with all column types by binding to their metadata attributes. This approach ensures completeness of value assistance across all columns while dramatically reducing implementation complexity compared to type-specific solutions.
Solution Approach 2:
The system achieves adaptability to different column types by dynamically changing parameters - specifically, by binding the generic query to different metadata attributes based on the selected column's field type. This allows a single implementation to serve all column types reliably without requiring separate code paths for each type.
Data Source
AI summary
Described are methods and systems for providing value help features to input fields. In response to a user selection of a condition type, an associated metadata is retrieved. Based upon the metadata, a user interface element comprising a static key and a dynamic key is generated. The dynamic key includes a name field and a value input field. Based upon the user interface element, a generic query including an input parameter node and a result node is generated. For the name field and the value input field of the dynamic key, a sequence number indicating an associated attribute group is extracted from the metadata. Based upon a field type of the value input field, the user interface element is bound to the associated attribute group indicated by the sequence number. Based upon the user entry received at the value input field, a corresponding value help feature is displayed.