Data display software with actions and links integrated with information

• US 6,128,617 A
• Filed: 11/24/1997
• Issued: 10/03/2000
• Est. Priority Date: 11/24/1997
• Status: Expired due to Term

• Current Assignee: Select Retrieval, LLC (Patrick J. Curry)
• Original Assignee: Lowry Software Incorporated
• Inventors: Lowry, David D.
• Primary Examiner(s): Alam, Hosain T.
• Assistant Examiner(s): Colbert, Ella
• Application Number:
  US08/977,368
• Time in Patent Office: 1,044 Days
• Field of Search: 707/514, 707/1, 707/100, 707/103, 707/506, 345/353, 345/356, 345/357
• US Class Current: 1/1
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

A hierarchical graphical listing or chart rendered on a display includes multiple nodes that are at different hierarchical levels and may include connecting branches that represent hierarchical links. Each of nodes is active and has an action associated with it so that the action is integrated into the information in the listing. In addition, the hierarchical graphical listings allow simple retrieval of information from a database record having plural fields. In one implementation, multiple successive hierarchical graphical listings are rendered. A user selects from each listing a node that corresponds to information of interest, as well as a field in a database record. The user selections of nodes from successive hierarchical graphical listings are tracked, and a database query is formed from the sequence of selections.

Claims

1. A method of retrieving information from a database record having plural fields, comprising:

rendering on a display screen plural successive integrated active information documents, each having one or more action control elements integrated into information in the document;

obtaining control element selections of particular action control elements in the plural successive integrated active information documents, one or more of the action control elements corresponding to one or more fields of the database record; and

forming a database query according to the action control element selections,

whereby the information in subsequent ones of the successive intergrated active information documents corresponds to control element selections made from preceding ones of the intergrated active information documents.

2. The method of claim 1 further comprising rendering a selection panel that indicates previous control element selections and revising a particular preceding action control element selection by accessing only that selection.

3. The method of claim 1 in which each of one or more of the action control elements further include one of plural actions in addition to correspondence to one or more fields of the database record.

4. The method of claim 3 in which the plural actions include plural ones of a display action, a view/play action, and an editing action.

5. The method of claim 3 in which one of the plural actions includes displaying a designated hierarchical graphical listing.

6. The method of claim 3 in which the display action includes displaying a designated active form with first and second different types of action control elements.

7. The method of claim 6 in which the first type of action control element is a row of information in an information table of plural rows.

8. The method of claim 1 in which the integrated active information documents include at least one hierarchical graphical listing having plural nodes at plural levels, the nodes corresponding to the action control elements.

9. The method of claim 1 in which the integrated active information documents include at least one active form with first and second different types of action control element.

10. The method of claim 1 in which the integrated active information documents include at least one spreadsheet having an action control element.

11. The method of claim 1 in which the database query is an SQL statement.

12. A computer readable medium having thereon software instructions for retrieving information from a database record having plural fields, comprising:

software instructions for rendering plural successive integrated active information documents, each having one or more action control elements integrated into information in the document;

software instructions for obtaining control element selections of particular control elements in the plural successive integrated active information documents, one or more of the action control elements corresponding to one or more fields of the database record; and

software instructions for forming a database query according to the action control element selections,

whereby the information in subsequent ones of the successive integrated active information documents corresponds to control element selections made from preceding ones of the integrated active information documents.

13. The medium of claim 12 further comprising the integrated active information documents and in which the documents include at least one hierarchical graphical listing having plural nodes at plural levels, the nodes corresponding to the action control elements.

14. The medium of claim 12 further comprising the integrated active information documents and in which the documents include at least one active form with first and second different types of action control element.

15. The medium of claim 14 in which the first type of action control element is a row of information in an information table of plural rows.

16. The medium of claim 12 further comprising the integrated active information documents and in which the documents include at least one spreadsheet having an action control element.