System for visual query and manipulation of configuration management records

• US 8,548,967 B1
• Filed: 12/12/2007
• Issued: 10/01/2013
• Est. Priority Date: 12/12/2007
• Status: Active Grant

• Current Assignee: Accurev Incorporated (Open Text Corporation)
• Original Assignee: Accurev Incorporated (Open Text Corporation)
• Inventors: Poole, Damon B.
• Primary Examiner(s): LY, CHEYNE D
• Application Number:
  US12/001,708
• Time in Patent Office: 2,120 Days
• Field of Search: 707/705, 717/101, 717/110, 717/120, 717/124
• US Class Current: 707/705
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 8/34 Graphical or visual programming

Abstract

Embodiments of the invention are directed to systems and processes for enabling querying of one or more data stores of CM applications using a graphical user interface (GUI) by which a user (e.g., a developer, supervisor, or project team leader) may select search terms. The GUI may offer one or more types of categories of search terms illustrated at a high level, such that a user may select search terms without knowledge of the underlying data structure of the data store(s). In some embodiments of the invention, when search results are presented to the user issuing a query, the search results are presented in a GUI that permits the users to make edits to the data without opening other windows to make the changes. For example, in some embodiments of the invention, the user may be permitted to select one or more results and “drag” the results, using the GUI, to another element of the GUI to make a change to the data, or may perform any other graphical operation with the results.

Claims

1. A computer-implemented method for querying a data store of information regarding at least one software development effort, the method comprising:

A) displaying to a user a graphical interface comprising at least one graphical element, each graphical element of the at least one graphical element being associated with at least one field of a record stored in the data store, the record being associated with the at least one software development effort, at least one first graphical element being associated with at least one software component related to the at least one software development effort and/or with at least one developer related to the at least one software development effort, and at least one second graphical element being associated with a workflow stage of a workflow related to the at least one software development effort;

B) detecting a selection by the user of at least one selected graphical element, the selection indicating a desired search to be performed;

C) assembling, from a set of one or more previously-identified query elements, a search query to be carried out, based at least in part on the user'"'"'s selection of graphical elements;

D) querying the data store of information regarding the at least one software development effort based on the search query; and

E) presenting results of the querying to the user,

whereby a user, without having knowledge of the fields of records stored in the data store, graphically defines a search of the data store regarding one or more issues related to the at least one software development effort, the records that can be searched comprising information regarding at least one attribute from a group of attributes consisting of one or more developers assigned to the issue, a target release for the issue, and a workflow stage of the issue.

2. The computer-implemented method of claim 1, wherein the results are presented to the user in the graphical interface displayed to the user in act A).

3. The computer-implemented method of claim 1, wherein the information regarding the at least one software development effort comprises project information on at least one version of at least one software project and at least one workflow associated with the at least one software project, the workflow comprising a plurality of workflow stages and at least one workflow transition.

4. The computer-implemented method of claim 3, wherein the at least one version of the at least one software project is implemented as at least one stream.

5. The computer-implemented method of claim 3, wherein the project information comprises at least one issue associated with the at least one software project, at least one user and/or group of users associated with the at least one software project, at least one target release for the at least one software project, and/or at least one software component associated with the at least one software project.

20. The computer-implemented method of claim 1, wherein selecting from a set of one or more previously-identified queries a search query to be carried out comprises:

for each of the plurality of selected graphical elements, selecting one or more previously-identified queries related to the selected graphical element, at least one of the queries identifying at least two fields to be searched; and

assembling the search query from the one or more previously-identified queries.

6. A computer-implemented method for manipulating a data store of information regarding at least one software development effort, the method comprising:

A) presenting to a user at least one result of a query of the data store via a graphical interface, the graphical interface comprising at least one graphical element, each graphical element of the at least one graphical element being associated with at least one field of a record stored in the data store, the record being associated with the software development effort, each graphical element being associated with at least one change that may be made to the data store when a particular graphical operation is performed involving the graphical element;

B) detecting a selection of at least one selected result of the at least one result;

C) detecting a graphical operation performed by the user with regard to the at least one selected result and a graphical element of the at least one graphical element;

D) determining an edit to be made to the at least one record based on the graphical operation by identifying, for the graphical element of the graphical operation, the at least one change associated with the graphical element; and

E) editing the at least one record in the data store corresponding to the at least one selected result according to the at least one change.

7. The computer-implemented method of claim 6, wherein the graphical operation is a “

drag and drop”

operation forcing an interaction between the at least one selected result and the graphical element.

8. The computer-implemented method of claim 6, wherein editing the at least one record in the data store comprises changing at least one value of at least one field to at least one new value associated with the graphical operation.

9. The computer-implemented method of claim 6, wherein each graphical element of the at least one graphical element is associated with at least one value of at least one field of at least one type of record stored in the data store.

10. The computer-implemented method of claim 6, wherein the information regarding the at least one software development effort comprises project information on at least one version of at least one software project and at least one workflow associated with the at least one software project, the workflow comprising a plurality of workflow stages and at least one workflow transition.

11. The computer-implemented method of claim 9, wherein the at least one version of the at least one software project is implemented as at least one stream.

12. The computer-implemented method of claim 9, wherein the project information comprises at least one issue associated with the at least one software project, at least one user and/or group of users associated with the at least one software project, at least one target release for the at least one software project, and/or at least one software component associated with the at least one software project.

13. An apparatus comprising:

an output device to display a graphical interface to a user, the graphical interface comprising at least one graphical element, at least one first graphical element being associated with at least one software component related to at least one software development effort and/or with at least one developer related to the at least one software development effort and at least one second graphical element being associated with a workflow stage of a workflow related to the at least one software development effort, wherein the graphical interface enables the user, without having knowledge of fields of records stored in a data store, to graphically define a search of the data store regarding one or more issues related to the at least one software development effort, the records that can be searched comprising information regarding at least one attribute from a group of attributes consisting of one or more developers assigned to an issue, a target release for the issue, and a workflow stage of the issue;

an input device with which the user can interact with the graphical interface;

a data store of information regarding the at least one software development effort; and

at least one processor adapted to

operate the output device to display the graphical interface,

detect a selection of one or more graphical elements of the graphical interface by the user, the selection indicating a desired query,

in response to the selection by the user, query the data store to determine one or more fields and/or values associated with the plurality of selected graphical elements,

construct a search query based at least in part on the fields and/or values determined in said querying,

perform a search of the data store using said search query, and

present results of the search to the user via the graphical interface.

14. The apparatus of claim 13, wherein the processor is further adapted to edit the information stored in the data store according to at least one graphical operation performed by the user, the at least one graphical operation implying a desired edit to be made to the information.

15. The apparatus of claim 14, wherein the at least one graphical operation is a drag and drop operation forcing an interaction between at least one selected result and a graphical element of the graphical interface.

16. The apparatus of claim 15, wherein editing the information in the data store comprises changing at least one value of at least one field of at least one record associated with the at least one selected result to at least one new value associated with the graphical operation.

17. The apparatus of claim 13, wherein the information regarding the at least one software development effort comprises project information on at least one version of at least one software project and at least one workflow associated with the at least one software project, the workflow comprising a plurality of workflow stages and at least one workflow transition.

18. The apparatus of claim 13, wherein the at least one version of the at least one software project is implemented as at least one stream.

19. The apparatus of claim 13, wherein the project information comprises at least one issue associated with the at least one software project, at least one user and/or group of users associated with the at least one software project, at least one target release for the at least one software project, and/or at least one software component associated with the at least one software project.