Database query generation for project task management system for managing project schedules over a network
First Claim
1. A computer-implemented method for automatic generation of database queries in a network based project schedule system comprising a database, the method comprising:
- in response to a request associated with a particular editor of said project schedule system, locating a particular query string associated with said particular editor;
wherein said particular query string contains one or more placeholder strings and wherein each placeholder string indicates with what type of value said placeholder string is replaced to generate a database query for submission to said database;
generating a database query by automatically replacing said one or more placeholder strings in said particular query string with respective values;
submitting said database query to said database; and
returning results of said database query in response to said request.
1 Assignment
0 Petitions
Accused Products
Abstract
A client-server based project schedule management system comprises multiple editors accessible through a web browser to perform various scheduling tasks by members of a project. Client-executable code is generated by the server for the client, which is passed to the client along with schedule-related information for populating the respective editors. The client executes the server-generated code to display the respective editor with pertinent information populated therein, and to manage and maintain any new or updated information in response to user interactions with the editor. Rows of tasks are represented by corresponding objects, where editor elements are object attributes which are directly accessible by the respective objects. Database queries are generated by the server based on constant strings containing placeholders which are replaced with information used by the query.
24 Citations
22 Claims
-
1. A computer-implemented method for automatic generation of database queries in a network based project schedule system comprising a database, the method comprising:
-
in response to a request associated with a particular editor of said project schedule system, locating a particular query string associated with said particular editor; wherein said particular query string contains one or more placeholder strings and wherein each placeholder string indicates with what type of value said placeholder string is replaced to generate a database query for submission to said database; generating a database query by automatically replacing said one or more placeholder strings in said particular query string with respective values; submitting said database query to said database; and returning results of said database query in response to said request. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 12, 13, 14, 15, 16, 17, 18, 19, 20)
-
-
10. A computer-implemented method for automatic generation of database queries in a network based project schedule system comprising a database, the method comprising:
-
in response to a request, identifying a particular query string associated with a particular editor with which said request is associated; assigning said particular query string to a variable string; determining whether said particular query string contains any placeholder strings indicating with what type of value a respective placeholder string is replaced to generate a database query for submission to said database; if said particular query string does not contain any placeholder strings, then submitting said particular query string to said database; and returning results of said particular query string in response to said request. - View Dependent Claims (11, 21, 22)
-
Specification