System and method for filtering and sorting data
First Claim
1. A method of managing data, the method comprising:
- displaying a table comprising a plurality of rows and columns of data cells, wherein a number of the rows or columns of cells of the table have an associated filter cell and an associated sort procedure, and wherein the content of each of the data cells belongs to at least one data set;
receiving filter criteria via one or more of the filter cells;
providing a sorting priority list that defines a sorting order for the sort procedures, wherein the sorting priority list is generated based at least in part upon the order in which a user enters filter criteria in the filter cells;
identifying which of the data cells satisfy the filter criteria that is associated with the respective data cells;
sorting the data sets of the identified data cells, wherein the sorting is based at least in part upon one of the sort procedures and the sorting priority list; and
displaying the sorted data sets of data cells, wherein the identified cells are displayed contiguously and interposed between non-identified data cells, wherein the data cells are identified, sorted, and displayed in response to receiving character-by-character input or upon the lapse of a preset pause period, and wherein the data sets associated with the identified data cells are graphically displayed to a user via highlight, color or other image marking that is different from the highlight, color, or image marking that is used for the non-identified data cells.
4 Assignments
0 Petitions
Accused Products
Abstract
System and method for filtering and sorting data. The system includes data management system for displaying a data table having a plurality of rows and columns of data cells. Each of the columns in the data table has an associated filter cell whereby the user may input filter criteria. In response to receiving the filter criteria in the filter cells, a data management system filters and sorts each of the data cells in the data table. In one embodiment of the invention, the data management system records the order in which the user inputs the filter criteria and generates a sorting priority list that defines a sorting priority for the data cells. The data management system sorts the data cells using the sorting priority list. Furthermore, in one embodiment of the invention, the data management system displays the data cells that satisfy the filter criteria contiguously and interleaved between those data cells that do not satisfy the filter criteria.
-
Citations
38 Claims
-
1. A method of managing data, the method comprising:
-
displaying a table comprising a plurality of rows and columns of data cells, wherein a number of the rows or columns of cells of the table have an associated filter cell and an associated sort procedure, and wherein the content of each of the data cells belongs to at least one data set;
receiving filter criteria via one or more of the filter cells;
providing a sorting priority list that defines a sorting order for the sort procedures, wherein the sorting priority list is generated based at least in part upon the order in which a user enters filter criteria in the filter cells;
identifying which of the data cells satisfy the filter criteria that is associated with the respective data cells;
sorting the data sets of the identified data cells, wherein the sorting is based at least in part upon one of the sort procedures and the sorting priority list; and
displaying the sorted data sets of data cells, wherein the identified cells are displayed contiguously and interposed between non-identified data cells, wherein the data cells are identified, sorted, and displayed in response to receiving character-by-character input or upon the lapse of a preset pause period, and wherein the data sets associated with the identified data cells are graphically displayed to a user via highlight, color or other image marking that is different from the highlight, color, or image marking that is used for the non-identified data cells. - View Dependent Claims (2, 3, 24)
-
-
4. A method of managing data, the method comprising:
-
displaying in a window a plurality of filter cells and a table comprising a plurality of rows and columns of data cells, wherein the content of each of the data cells belongs to at least one data set, wherein each of the columns or rows has an associated sort procedure, and wherein each of the data cells is associated with at least one of the filter cells;
receiving filter criteria via one or more of the filter cells;
identifying which ones of the associated data cells contain data that satisfies the filter criteria of the filter cell that is associated with the data cells; and
sorting the data sets of the identified data cells, wherein the sorting is based at least in part upon one of the sort procedures. - View Dependent Claims (5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36)
-
-
37. A system for managing data, the system comprising:
-
means for displaying a table comprising a plurality of rows and columns of data cells, wherein a number of the rows or columns of cells of the table have an associated filter cell and an associated sort procedure, and wherein the content of each of the data cells belongs to at least one data set;
means for receiving filter criteria via one or more of the filter cells;
means for identifying which ones of the data cells satisfy the filter criteria that is associated with the respective data cells; and
means for sorting the data sets of the identified data cells, wherein the sorting is based at least in part upon one of the sort procedures.
-
-
38. A system for managing data of a database, the system comprising:
-
a module for displaying a table comprising a plurality of rows and columns of data cells, wherein a number of the rows or columns of cells of the table have an associated filter cell and an associated sort procedure, and wherein the content of each of the data cells belongs to at least one data set, and wherein the content of the data cells is from the database;
a module for receiving filter criteria via one or more of the filter cells and for identifying which of the data cells satisfy the filter criteria that is associated with the respective data cells; and
a module for sorting the data sets of the identified data cells, wherein the sorting is based at least in part upon one of the sort procedures.
-
Specification