# US 2003/0229848 A1 · Table filtering in a computer user interface

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2003/0229848 A1
- Document ID: US20030229848A1
- Status: Published application
- Kind: A1
- Application number: 10/233,085
- Filed: 2002-08-30
- Published: 2003-12-11
- Earliest claimed: 2002-06-05
- Inventors: Udo Arend; Edmund Eberleh; Heinz Willumeit
- Web page: https://patentgrep.com/patent/US20030229848A1

## CPC

- G06F 16/242: Query formulation
- G06F 17/00: Digital computing or data processing equipment or methods, specially adapted for specific functions (information retrieval, database structures or file system structures therefor G06F16/00)
- G06F 16/00: Information retrieval; Database structures therefor; File system structures therefor
- G06F 16/26: Visual data mining; Browsing structured data
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Techniques are disclosed for displaying information to a user on a display device of a computer system. In one general aspect, the invention provides for the display of a first view having a plurality of objects in a table of rows and columns on the display device. Each object is displayed as a row in the table and has a plurality of fields, where each field is in a column of the table. A blank input row corresponding to the table is displayed, having input fields corresponding to the columns of the table. An input is received in the form of a character string in a selected input field of the input row. A filter command is received, causing a filtering function to be performed on a field of the objects corresponding to the selected input field of the input row using the character string, and filtered data is displayed.

## Claims

### Claim 1

A method of displaying information on a display device of a computer system, comprising:
displaying a first view on the display device, the first view comprising a plurality of objects in a table of rows and columns, each object displayed as a row in the table and comprised of a plurality of fields, each field being in a column of the table;
displaying a blank input row corresponding to the table, the input row having input fields corresponding to the columns of the table;
receiving an input in the form of a character string in a selected input field of the input row;
receiving a filter command; and
performing, in response to the filter command, a filtering function on a field of the objects corresponding to the selected input field of the input row using the character string, and displaying filtered data.

### Claim 2 (depends on 1)

The method of claim 1 further comprising, displaying, on the display device, a third view that comprises a subset of objects, specified by the filtering function, from the plurality of objects.

### Claim 3 (depends on 2)

The method of claim 2 wherein the third view comprises, from the objects displayed in the first view, only those objects contained in the subset of objects.

### Claim 4 (depends on 2)

The method of claim 2 wherein the subset of objects is arranged in a filtered table of rows and columns with one object per row.

### Claim 5 (depends on 4)

The method of claim 4 further comprising, displaying the input row with the filtered table.

### Claim 6 (depends on 5)

The method of claim 5 further comprising, performing a subsequent filtering function on the filtered table.

### Claim 7 (depends on 2)

The method of claim 2 wherein the third view contains a notification message that a filtering function has been performed.

### Claim 8 (depends on 1)

The method of claim 1 wherein the input row is the first row of the table.

### Claim 9 (depends on 1)

The method of claim 1 wherein the input row comprises a filter row.

### Claim 10 (depends on 1)

The method of claim 1 wherein the objects are database objects.

### Claim 11 (depends on 1)

The method of claim 1 wherein the filter command comprises a carriage return.

### Claim 12 (depends on 1)

The method of claim 1 wherein the filter command comprises a selection of a filter button.

### Claim 13 (depends on 12)

The method of claim 12 wherein the filter button is located in the input row.

### Claim 14 (depends on 1)

The method of claim 1 wherein the filter command comprises the provision of data followed by a predetermined period of inactivity.

### Claim 15 (depends on 1)

The method of claim 1 wherein the input row has an input field for each column of the table.

### Claim 16 (depends on 1)

The method of claim 1 further comprising, receiving input in the form of a plurality of filter conditions, each filter condition comprised of a character string and a corresponding selected field of the input row, before receiving the filter command.

### Claim 17 (depends on 16)

The method of claim 16 further comprising, applying a logical “AND” relation to the filter conditions.

### Claim 18 (depends on 16)

The method of claim 16 further comprising, applying a logical “OR” relation to the filter conditions.

### Claim 19 (depends on 2)

The method of claim 2 wherein the filtering function specifies the subset of objects by comparing the character string in the selected input field of the input row with the entry in the corresponding field for each of the objects in the plurality of objects.

### Claim 20 (depends on 1)

The method of claim 1 wherein the character string comprises an operator.

### Claim 21 (depends on 20)

The method of claim 20 wherein the operator is selected from a group consisting of “logical or”, “greater than”, “less than”, “not equal”, range indicator, and wild card indicator.

### Claim 22 (depends on 1)

The method of claim 1 wherein the objects are local to a computer system.

### Claim 23 (depends on 1)

The method of claim 1 wherein the input row is associated with a computer application, and is displayed each time the computer application is executed.

### Claim 24

A graphical user interface for displaying items retrieved from a database, the user interface comprising:
a table having rows of a plurality of items, each row comprised of a plurality of fields, each field corresponding to a column in the table; and
a blank input row adjacent to the table, the input row having sections corresponding to the columns of the table, each section providing a work area to enter filter criteria such that when a filtering function is executed on the table, the table displays items filtered in accordance with the filter criteria.

### Claim 25

Computer-readable medium with program instructions stored thereon that when executed perform the following functions for providing display information on a display device of a computer system:
displays a first view on the display device, the first view comprising a plurality of objects in a table of rows and columns, each object displayed as a row in the table and comprised of a plurality of fields, each field being in a column of the table;
displays a blank input row corresponding to the table, the input row having input fields corresponding to the columns of the table;
receives an input in the form of a character string in a selected input field of the input row;
receives a filter command; and
performs, in response to the filter command, a filtering function on a field of the objects corresponding to the selected input field of the input row using the character string, and displaying filtered data.

### Claim 26 (depends on 25)

The medium of claim 25 further comprising, instructions that when executed display, on the display device, a third view that comprises a subset of objects, specified by the filtering function, from the plurality of objects.

### Claim 27 (depends on 26)

The medium of claim 26 wherein the third view comprises, from the objects displayed in the first view, only those objects contained in the subset of objects.

### Claim 28 (depends on 26)

The medium of claim 26 wherein the subset of objects is arranged in a filtered table of rows and columns with one object per row.

### Claim 29 (depends on 28)

The medium of claim 28 further comprising, instructions that when executed display the input row with the filtered table.

### Claim 30 (depends on 29)

The medium of claim 29 further comprising, instructions that when executed perform a subsequent filtering function on the filtered table.

### Claim 31 (depends on 26)

The medium of claim 26 wherein the third view contains a notification message that a filtering function has been performed.

### Claim 32 (depends on 25)

The medium of claim 25 wherein the input row is the first row of the table.

### Claim 33 (depends on 25)

The medium of claim 25 wherein the input row comprises a filter row.

### Claim 34 (depends on 25)

The medium of claim 25 wherein the objects are database objects.

### Claim 35 (depends on 25)

The medium of claim 25 wherein the filter command comprises a carriage return.

### Claim 36 (depends on 25)

The medium of claim 25 wherein the filter command comprises a selection of a filter button.

### Claim 37 (depends on 36)

The medium of claim 36 wherein the filter button is located in the input row.

### Claim 38 (depends on 25)

The medium of claim 25 wherein the filter command comprises the provision of data followed by a predetermined period of inactivity.

### Claim 39 (depends on 25)

The medium of claim 25 wherein the input row has an input field for each column of the table.

### Claim 40 (depends on 25)

The medium of claim 25 further comprising, instructions that when executed receive input in the form of a plurality of filter conditions, each filter condition comprised of a character string and a corresponding selected field of the input row, before receiving the filter command.

### Claim 41 (depends on 40)

The medium of claim 40 further comprising, instructions that when executed apply a logical “AND” relation to the filter conditions.

### Claim 42 (depends on 40)

The medium of claim 40 further comprising, instructions that when executed apply a logical “OR” relation to the filter conditions.

### Claim 43 (depends on 26)

The medium of claim 26 wherein the filtering function specifies the subset of objects by comparing the character string in the selected input field of the input row with the entry in the corresponding field for each of the objects in the plurality of objects.

### Claim 44 (depends on 25)

The medium of claim 25 wherein the character string comprises an operator.

### Claim 45 (depends on 44)

The medium of claim 44 wherein the operator is selected from a group consisting of “logical or”, “greater than”, “less than”, “not equal”, range indicator, and wild card indicator

### Claim 46 (depends on 25)

The medium of claim 25 wherein the objects are local to a computer system.

### Claim 47 (depends on 25)

The medium of claim 25 wherein the input row is associated with a computer application, and is displayed each time the computer application is executed.
