System and method for implementing a non-destructive tree filter

• US 8,290,966 B2
• Filed: 11/29/2007
• Issued: 10/16/2012
• Est. Priority Date: 11/29/2007
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Vignet, Peter
• Primary Examiner(s): Radtke, Mark A
• Application Number:
  US11/998,668
• Publication Number:
  US 20090144315A1
• Time in Patent Office: 1,783 Days
• Field of Search: None
• US Class Current: 707/754
• CPC Class Codes: G06F 16/2457 with adaptation to user needs

Abstract

A system and method are described for filtering certain rows of a table while at the same time maintaining rows illustrating the ancestry of the filtered rows. For example, a computer-implemented method according to one embodiment of the invention comprises: receiving user-specified filtering criteria from a client comprising a value or range of values for filtering the rows of a table; filtering the table rows as indicated by the user-specified filtering criteria to generate a set of filtered rows; and generating a table containing the filtered rows and other rows which are ancestor rows to the filtered rows, notwithstanding the fact that one or more of the ancestor rows are not part of the set of filtered rows based on the user-specified filtering criteria, and excluding all other rows from the table.

Claims

1. A computer-implemented method comprising:

receiving user-specified filtering criteria from a client comprising a value or range of values for filtering the rows of a table having a hierarchy such that at least some rows have child-ancestor relations;

filtering the table rows as indicated by the user-specified filtering criteria to identify a set of filtered rows; and

displaying a table containing the filtered rows and ancestor rows of the filtered rows, even if the ancestor rows are not part of the set of filtered rows based on the user-specified filtering criteria, excluding all rows from the table that are neither a member of the set of filtered rows nor an ancestor of a member of the set of filtered rows.

2. The method as in claim 1 wherein displaying a table further comprises:

formatting the filtered rows using a first graphical and/or textual format; and

formatting the ancestor rows of the filtered rows using a second graphical and/or textual format.

3. The method as in claim 2 wherein the first graphical and/or textual format comprises bold text and the second graphical and/or textual format comprises text in a smaller font than that used for the first graphical and/or textual format.

4. The method as in claim 2 wherein the first graphical and/or textual format comprises the existence of text within the rows and the second graphical and/or textual format comprises no text within the rows.

5. The method as in claim 2 wherein the first graphical and/or textual format comprises text having a first color and the second graphical and/or textual format comprises text having a second color.

6. The method as in claim 1 wherein the user-specified filtering criteria are transmitted by the client using the Hypertext Transport Protocol (HTTP) and wherein the table generated in response to the user-specified filtering criteria is sent to the client using HTTP.

7. The method as in claim 1 wherein displaying a table further comprises retrieving data for the table from a model within a model-view-controller architecture.

8. A system comprising a memory for storing program code and a processor for processing the program code to perform the operations of:

receiving user-specified filtering criteria from a client comprising a value or range of values for filtering the rows of a table having a hierarchy such that at least some rows have child-ancestor relations;

filtering the table rows as indicated by the user-specified filtering criteria to identify a set of filtered rows; and

displaying a table containing the filtered rows and ancestor rows of the filtered rows, if the ancestor rows are not part of the set of filtered rows based on the user-specified filtering criteria, excluding all other rows from the table that are neither a member of the set of filtered rows nor an ancestor of a member of the set of filtered rows.

9. The system as in claim 8 wherein displaying a table further comprises:

formatting the filtered rows using a first graphical and/or textual format; and

formatting the ancestor rows of the filtered rows using a second graphical and/or textual format.

10. The system as in claim 9 wherein the first graphical and/or textual format comprises bold text and the second graphical and/or textual format comprises text in a smaller font than that used for the first graphical and/or textual format.

11. The system as in claim 9 wherein the first graphical and/or textual format comprises the existence of text within the rows and the second graphical and/or textual format comprises no text within the rows.

12. The system as in claim 9 wherein the first graphical and/or textual format comprises text having a first color and the second graphical and/or textual format comprises text having a second color.

13. The system as in claim 8 wherein the user-specified filtering criteria are transmitted by the client using the Hypertext Transport Protocol (HTTP) and wherein the table generated in response to the user-specified filtering criteria is sent to the client using HTTP.

14. The system as in claim 8 wherein displaying a table further comprises retrieving data for the table from a model within a model-view-controller architecture.

15. A machine-readable medium having program code stored thereon which, when executed by a machine, causes the machine to perform the operations of:

receiving user-specified filtering criteria from a client comprising a value or range of values for filtering the rows of a table having a hierarchy such that at least some rows have child-ancestor relations;

filtering the table rows as indicated by the user-specified filtering criteria to identify a set of filtered rows; and

displaying a table containing the filtered rows and ancestor rows of the filtered rows, even if the ancestor rows are not part of the set of filtered rows based on the user-specified filtering criteria, excluding all other rows from the table that are neither a member of the set of filtered rows nor an ancestor of a member of the set of filtered rows.

16. The machine-readable medium as in claim 15 wherein displaying a table further comprises:

formatting the filtered rows using a first graphical and/or textual format; and

formatting the ancestor rows of the filtered rows using a second graphical and/or textual format.

17. The machine-readable medium as in claim 16 wherein the first graphical and/or textual format comprises bold text and the second graphical and/or textual format comprises text in a smaller font than that used for the first graphical and/or textual format.

18. The machine-readable medium as in claim 16 wherein the first graphical and/or textual format comprises the existence of text within the rows and the second graphical and/or textual format comprises no text within the rows.

19. The machine-readable medium as in claim 16 wherein the first graphical and/or textual format comprises text having a first color and the second graphical and/or textual format comprises text having a second color.

20. The machine-readable medium as in claim 15 wherein the user-specified filtering criteria are transmitted by the client using the Hypertext Transport Protocol (HTTP) and wherein the table generated in response to the user-specified filtering criteria is sent to the client using HTTP.

21. The machine-readable medium as in claim 15 wherein displaying a table further comprises retrieving data for the table from a model within a model-view-controller architecture.