Table filtering in a computer user interface

• US 20030229848A1
• Filed: 08/30/2002
• Published: 12/11/2003
• Est. Priority Date: 06/05/2002
• Status: Abandoned Application

• Current Assignee: SAP AG (SAP SE)
• Original Assignee: SAP AG (SAP SE)
• Inventors: Eberleh, Edmund, Arend, Udo, Willumeit, Heinz
• Application Number:
  US10/233,085
• Publication Number:
  US 20030229848A1
• Time in Patent Office: Days
• US Class Current: 715/509
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: 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

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

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.

2. 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.

3. 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.

4. 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.

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

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

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

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

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

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

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

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

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

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

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

16. 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.

17. The method of claim 16 further comprising, applying a logical “

AND”

relation to the filter conditions.

18. The method of claim 16 further comprising, applying a logical “

OR”

relation to the filter conditions.

19. 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.

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

21. 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.

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

23. 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.

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.

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.

26. 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.

27. 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.

28. 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.

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

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

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

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

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

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

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

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

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

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

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

40. 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.

41. The medium of claim 40 further comprising, instructions that when executed apply a logical “

AND”

relation to the filter conditions.

42. The medium of claim 40 further comprising, instructions that when executed apply a logical “

OR”

relation to the filter conditions.

43. 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.

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

45. 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

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

47. 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.