Dynamic query of server applications
First Claim
1. A method for creating information queries to be used for locating and displaying information from a variety of applications running on a server system, the method comprising:
- interactively displaying at least one browser-based graphical user interface screen;
creating at least one condition in response to prompts from the graphical user interface screens;
prompting for the logical combination of the conditions into a query;
prompting for the logical combination of the queries into a complex query;
persisting the resulting query into associated database tables;
executing the query; and
displaying the results of the query to the end user.
1 Assignment
0 Petitions
Accused Products
Abstract
A framework for the creation and execution of a dynamic query (or recommended content) that includes a web-based interface for a business manager or administrator to query data in applications running on a server system. Graphical user interface screens will allow a user to create leaf conditions (or expressions), and to logically join the leaf conditions into more complex conditions. The conditions are then collectively joined into a query. The query will be persisted into database tables by saving the Where Clause in XML. The query can be executed using a adapter-connector framework provided by a host platform (i.e., the referenced Asera platform). Thereafter, the results will be displayed to the end user.
-
Citations
20 Claims
-
1. A method for creating information queries to be used for locating and displaying information from a variety of applications running on a server system, the method comprising:
-
interactively displaying at least one browser-based graphical user interface screen;
creating at least one condition in response to prompts from the graphical user interface screens;
prompting for the logical combination of the conditions into a query;
prompting for the logical combination of the queries into a complex query;
persisting the resulting query into associated database tables;
executing the query; and
displaying the results of the query to the end user. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18, 19, 20)
-
-
14. A graphical user interface that provides for creating the conditions for a Where Clause of a query in any form, the interface comprising:
-
at least one interactive screen to allow the user to select query leaf conditions;
at least one interactive screen to allow the user to logically nest and join query leaf conditions;
at least one interactive screen to allow the user to change the nesting and joining of query leaf conditions; and
at least one interactive screen to allow the user to repeat certain screens, thereby adding more leaf conditions, and joining them into a more complex condition, whereby the resulting query is saved in a persistent storage for execution of the query, and for display of the query results.
-
Specification