Selection context filtering
First Claim
Patent Images
1. A computer-implemented method for graphical construction of filter queries, the method comprising:
- displaying on a display device a table of data through a user interface;
receiving a signal from a user through the user interface to select a portion of data in a cell of the displayed table, wherein the selected portion of data is a key field with a value used in filtering;
analyzing a context of the selection of the portion of data to determine the context of the data, wherein the context of the selection of the portion of data is defined by characteristics of the selection of the portion of data, and wherein the analysis is based upon a type of the selected portion of data;
generating a menu of filters based on the context of the selection of the portion of data, wherein the content of the menu of filters is automatically generated in response to the analysis of the selected portion of data, and wherein the content of the menu of filters comprises filters specifically related to the context of the selected portion of data and default filters appropriate for any context;
displaying on the display device the menu of filters in proximity to the selected portion of data, wherein the menu of filters is displayed such that it overlaps the table of data;
receiving a filter selection from said menu of filters;
generating a filter query, wherein the value of the key field is used to determine whether a given row is filtered;
applying the generated filter query to the table of data, wherein applying the generated filter query comprises;
determining whether an existing filter is applied to the table of data;
if an existing filter is applied to the table of data, determining whether the existing filter currently applied to the data table is mutually exclusive to the filter selection;
based upon the determination, automatically removing the currently applied filter from the data table if the existing filter and the filter selection is mutually exclusive, wherein the selected filter is applied to the table of data after the existing filter is removed;
if the existing filter is not mutually exclusive to the filter selection, applying the filter selection in conjunction with the existing filter; and
if there is no existing filter, creating an Original filter based upon the filter selection and applying the Original filter to the table of data; and
displaying on the display device a table of results from applying the generated filter query to the table of data.
1 Assignment
0 Petitions
Accused Products
Abstract
A method and system for the graphical formulation of filter queries is disclosed which enables data queries to be easily chosen via selection from a menu. A signal is received to filter, or query, a data table. Next, the context of a selection of data is analyzed, and a menu of filters based on that context is formulated and displayed. A filter selection is received, and the corresponding filter is executed. The results of the filter are displayed on the screen.
-
Citations
16 Claims
-
1. A computer-implemented method for graphical construction of filter queries, the method comprising:
-
displaying on a display device a table of data through a user interface; receiving a signal from a user through the user interface to select a portion of data in a cell of the displayed table, wherein the selected portion of data is a key field with a value used in filtering; analyzing a context of the selection of the portion of data to determine the context of the data, wherein the context of the selection of the portion of data is defined by characteristics of the selection of the portion of data, and wherein the analysis is based upon a type of the selected portion of data; generating a menu of filters based on the context of the selection of the portion of data, wherein the content of the menu of filters is automatically generated in response to the analysis of the selected portion of data, and wherein the content of the menu of filters comprises filters specifically related to the context of the selected portion of data and default filters appropriate for any context; displaying on the display device the menu of filters in proximity to the selected portion of data, wherein the menu of filters is displayed such that it overlaps the table of data; receiving a filter selection from said menu of filters; generating a filter query, wherein the value of the key field is used to determine whether a given row is filtered; applying the generated filter query to the table of data, wherein applying the generated filter query comprises; determining whether an existing filter is applied to the table of data; if an existing filter is applied to the table of data, determining whether the existing filter currently applied to the data table is mutually exclusive to the filter selection; based upon the determination, automatically removing the currently applied filter from the data table if the existing filter and the filter selection is mutually exclusive, wherein the selected filter is applied to the table of data after the existing filter is removed; if the existing filter is not mutually exclusive to the filter selection, applying the filter selection in conjunction with the existing filter; and if there is no existing filter, creating an Original filter based upon the filter selection and applying the Original filter to the table of data; and displaying on the display device a table of results from applying the generated filter query to the table of data. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A computer storage medium encoding a computer-implemented method for filtering data based on a context of a selection of data, the method comprising:
-
displaying a data table through a user interface; receiving a selection of a portion of data in a cell of the displayed table from a user through the user interface, wherein the selection of the portion of data is a key field with a value used in filtering data table; analyzing a context of the selection of the portion of data in a cell to determine the context of the data, wherein the context of the selection of the portion of data is defined by characteristics of the selection of the portion of data, and wherein the analysis is based upon a type of the selected portion of data and a position of the selected portion of data; generating a menu of filter options based on the context of the selection of the portion of data, wherein the content of the menu of filters is automatically generated in response to the analysis of the selection of the portion of data, and wherein the content of the menu of filter options includes filters specifically related to the context of the selection of data and default filters appropriate for any context; displaying the menu of filter options in proximity to the selected portion of data, wherein the menu of filter options is displayed such that it overlaps the table of data; receiving a filter selection from said menu of filters; generating a filter query, wherein the value of the key field is used to determine whether a row is filtered by the filter query; applying the generated filter query to the table of data, wherein applying the generated filter query comprises; determining whether an existing filter is applied to the table of data; if an existing filter is applied to the table of data, determining whether the existing filter currently applied to the data table is mutually exclusive to the filter selection; based upon the determination, automatically removing the currently applied filter from the data table if the existing filter and the filter selection is mutually exclusive, wherein the selected filter is applied to the table of data after the existing filter is removed; if the existing filter is not mutually exclusive to the filter selection, applying the filter selection in conjunction with the existing filter; and if there is no existing filter, creating a Original filter based upon the filter selection and applying the Original filter to the table of data; and displaying a table of results from applying the filter selection to the table of data. - View Dependent Claims (12, 13, 14, 15, 16)
-
Specification