Graphical user interface for automated process control

• US 7,266,764 B1
• Filed: 11/07/2001
• Issued: 09/04/2007
• Est. Priority Date: 08/16/2000
• Status: Expired due to Term

• Current Assignee: Sparta Systems Inc (Honeywell International Inc.)
• Original Assignee: Sparta Systems Inc (Honeywell International Inc.)
• Inventors: Flam, Ran J.
• Primary Examiner(s): Alam; Shahid
• Assistant Examiner(s): Stevens; Robert
• Application Number:
  US10/036,591
• Time in Patent Office: 2,127 Days
• Field of Search: 715/500, 715/764, 715/809, 715/507, 715/509, 707/104.1, 707/102, 345/764, 345/809
• US Class Current: 715/209
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06Q 10/00 Administration; Management
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A process control system that automatically monitors processes and performs activities based on conditions detected during monitoring. The information needed to do the monitoring and perform activities is contained in tables in a database system. The process control system may be configured by configuring entries in the tables. An administrative query table has records that define administrative queries. Each administrative query has associated with it a query to be executed on a table of process records that indicate statuses of the processes being monitored, a scope that defines a subset of the process records upon which the query is to be executed, a schedule from which a time of next execution of the administrative query can be computed, and an activity. The activity is a set of one or more actions. When an administrative query is executed and the query associated with the administrative query is run on the table of process records and the result set is not empty, the activity is performed with regard to the process records of the result set. A plurality of administrative activities may be associated with the administrative query, with the activity to be performed being selected on the basis of a state of a given process record with regard to the query. An administrative activity is made up of one or more actions; also disclosed is a graphical user interface for defining administrative queries, administrative activities, and administrative actions.

Claims

1. A graphical user interface in a system having at least one memory device, at least one device for implementing the graphical user interface, and at least one processor having access to the memory device and the graphical user interface device, the graphical user interface specifying one or more predefined actions, each predefined action modifying a value of a record field that is common to records belonging to a set thereof, the records being stored in the memory devices and the processor causing the graphical user interface device to generate the graphical user interface, responding to inputs therefrom, and automatically executing a predefined query according to a predefined schedule, the predefined query being associated with the predefined action and returning records belonging to the set,

the graphical user interface comprising:

a window in the graphical user interface device, the window displaying a table wherein the record field whose value is to be modified by the action has an entry that is selectable by a user of the graphical user interface, the entry including

a first field of the entry that identifies the record field to be modified by the action; and

one or more action fields of the entry that, when the user has selected the entry, the user sets to specify a particular predefined action in which the record field identified by the first field of the entry is set to a value which is derived from a current value of a reference field in the returned record, the reference field being another field that is common to records belonging to the set thereof,

whereupon, each time the processor automatically executes the predefined query according to the predefined schedule and the predefined query returns a record that belongs to the set, the processor performs the particular predefined action.

2. The graphical user interface set forth in claim 1 wherein:

the values of the record field identified by the entry'"'"'s first field belong to one of a plurality of types; and

the entry'"'"'s action fields are determined by the type of the identified field'"'"'s values.

3. The graphical user interface set forth in claim 2 wherein:

the plurality of types include types whose values belong to ordered sets that are defined in the system to which the graphical user interface belongs, types whose values specify times, and types whose values specify persons.

4. The graphical user interface set forth in claim 1 wherein:

the predefined actions include a further predefined action in which the entry'"'"'s action fields are set by the user to specify that the record field in the returned record that is identified by the entry'"'"'s first field be cleared,

whereupon, each time the processor automatically executes the predefined query according to the predefined schedule and the predefined query returns a record that belongs to the set, the processor performs the further predefined action.

5. The graphical user interface set forth in claim 1 wherein:

the predefined actions include a further predefined action in which the entry'"'"'s action fields are set by the user to specify a value and to specify that the value be assigned to the record field in the returned record that is identified by the entry'"'"'s first field, whereupon, each time the processor automatically executes the predefined query according to the predefined schedule and the predefined query returns a record that belongs to the set, the processor performs the further predefined action.

6. The graphical user interface set forth in claim 1 wherein:

the predefined actions include a further predefined action in which the entry'"'"'s action fields are set by the user to specify an operation by which a new value for the record field identified by the entry'"'"'s first field is computed from a current value which is the identified record field'"'"'s value in the returned record when the returned record is returned by the query execution,

whereupon, each time the processor automatically executes the predefined query according to the predefined schedule and the predefined query returns a record that belongs to the set, the processor performs the further predefined action.

7. The graphical user interface set forth in claim 6 wherein:

the value of the record field identified by the entry'"'"'s first field belongs to an ordered set of values; and

in the further predefined action, the action fields are set by the user to specify an increment operation wherein the new value that is assigned to the identified record field'"'"'s value in the returned record is a value that follows the identified record field'"'"'s current value in the ordered set of values.

8. The graphical user interface set forth in claim 1 wherein:

the record field identified by the entry'"'"'s first field has a null value when the record is returned by the query execution; and

the predefined actions include a first further predefined action in which the entry'"'"'s action fields are set by the user to specify an action that is to be performed when the identified record field in the returned record has the null value and/or second further predefined action that is to be performed when the identified record field in the returned record does not have the null value,

whereupon, each time the processor automatically executes the predefined query according to the predefined schedule and the predefined query returns a record that belongs to the set, the processor performs the first further predefined action or the second further predefined action as determined by the value of the identified record field and the settings of the action fields.

9. The graphical user interface set forth in claim 1 wherein:

the particular predefined action sets the record field identified by the entry'"'"'s first field to a value which is computed from the current value of the returned record'"'"'s reference field.

10. The graphical user interface set forth in claim 9 wherein:

in the particular predefined action,

the action fields are set by the user to specify a first reference field and a first manner of computing the value to which the identified record field is to be set from the current value of the first reference field when the identified record field in the returned record has a null value and/or a second reference field and a second manner of computing the value to which the identified record field is to be set from the current value of the first reference field when the identified record field in the returned record does not have the null value.

11. The graphical user interface set forth in claim 1 wherein:

the particular predefined action derives the value to which the identified record field is to be set from the current value of the first reference field by assigning the current value of the returned record'"'"'s reference field to the identified record field in the returned record.

12. The graphical user interface set forth in claim 1 wherein:

the identified record field and the reference field have time values; and

in the particular redefined action, the action fields are further set by the user to specify an amount of time by which the reference field'"'"'s current value is increased or decreased to derive the new value for the identified record field.

13. The graphical user interface set forth in claim 12 wherein:

the action fields are further set by the user to specify the amount of time in one of a plurality of ways.

14. The graphical user interface set forth in claim 13 wherein:

one of the plurality of ways is days; and

when days have been specified, the action fields are further set by the user to specify whether the days will be derived as business days or calendar days.

15. The graphical user interface set forth in claim 12 wherein:

one of the reference fields is a field whose value is always set to the current time when the query execution returns the returned record.

16. The graphical user interface set forth in claim 1 wherein:

the identified record field has a person value; and

in the predefined action, the entry'"'"'s action fields are set by the user to specify a role reference field in the returned record from which a new person value for the record field identified by the entry'"'"'s first field is obtained, the role reference field being another field common to the record belonging to the set thereof, the role reference field referring to an ordered set of person values wherein one of the person values is a last-used person value, and the role reference field in the returned record being set to the next person value following the last-used person value at the time the returned record is returned by the query execution and the value of the identified record field in the returned record being set from the value of the role reference field in the returned record.

17. The graphical user interface set forth in claim 16 wherein:

another action has been specified which assigns the person reference field a value from a role reference field; and

when the returned record is returned by the query execution, actions which assign person fields values from role reference fields are performed prior to other actions.

18. The graphical user interface set forth in claim 1 wherein:

the predefined actions include a further predefined action in which the action fields are set by the user to directly specify a person value, whereupon, each time the processor automatically executes the predefined query according to the predefined schedule and the predefined query returns a record that belongs to the set, the processor performs the further predefined action.