Natural language based filtering

• US 20100083151A1
• Filed: 09/30/2008
• Published: 04/01/2010
• Est. Priority Date: 09/30/2008
• Status: Abandoned Application

• Current Assignee: Apple Inc.
• Original Assignee: Apple Inc.
• Inventors: Lanza, Nathaniel Cleverly, Weeldreyer, Christopher Douglas
• Application Number:
  US12/286,691
• Publication Number:
  US 20100083151A1
• Time in Patent Office: Days
• US Class Current: 715/764
• CPC Class Codes: G06F 16/90332 Natural language query formulation or dialogue systems
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Natural language based filtering is disclosed. In some embodiments, a user interface for defining one or more filters for a group of data allows one or more parameters associated with a filter definition, including a filter condition, to at least in part be specified in natural language. In some embodiments, a filter definition is specified at least in part by selecting one or more of a plurality of pre-configured natural language expressions made available for selection via the user interface.

Claims

1. A computer program product for processing a group of data, the computer program product being embodied in a computer readable storage medium and comprising computer instructions for:

providing a user interface for defining one or more filters for a group of data;

wherein the user interface allows one or more parameters associated with a filter definition, including a filter condition, to be specified at least in part in natural language.

2. The computer program product recited in claim 1, wherein a filter definition comprises a specification of a column of the group of data with respect to which one or more rows of the group of data are to be filtered.

3. The computer program product recited in claim 1, wherein a filter definition comprises a specification of a row of the group of data with respect to which one or more columns of the group of data are to be filtered.

4. The computer program product recited in claim 1, wherein a filter definition comprises one or more of a specification of a condition, a specification of a value for a condition, and a specification of a type of a value for a condition.

5. The computer program product recited in claim 1, wherein a filter definition is specified at least in part by selecting one or more of a plurality of pre-configured natural language expressions made available for selection via the user interface.

6. The computer program product recited in claim 1, wherein the user interface comprises one or more of:

a menu for selecting a row of the group of data, a menu for selecting a column of the group of data, a menu for selecting a filter condition, an input field for specifying a value for a filter condition, a menu for selecting a value for a filter condition, and a menu for selecting a data type of a value for a filter condition.

7. The computer program product recited in claim 1, wherein at least a portion of a filter condition comprises one or more of:

“

is”

, “

is not”

, “

is blank”

, “

is not blank”

, “

is greater than”

, “

is less than”

, “

is between”

, “

is in the top”

, “

is in the bottom”

, “

is above average”

, “

is below average”

, “

contains”

, “

doesn'"'"'t contain”

, “

starts with”

, “

ends with” and

“

date is”

.

8. The computer program product recited in claim 1, wherein the user interface provides an option to define a date-based filter.

9. The computer program product recited in claim 8, wherein the user interface allows a date range associated with a date-based filtered to at least in part be specified in natural language.

10. A system for processing a group of data, comprising:

a processor configured to;

provide a user interface for defining one or more filters for a group of data, wherein the user interface allows one or more parameters associated with a filter definition, including a filter condition, to be specified at least in part in natural language; and

a memory coupled to the processor and configured to provide the processor with instructions.

11. The system recited in claim 10, wherein a filter definition comprises one or more of a specification of a condition, a specification of a value for a condition, and a specification of a type of a value for a condition.

12. The system recited in claim 10, wherein a filter definition is specified at least in part by selecting one or more of a plurality of pre-configured natural language expressions made available for selection via the user interface.

13. The system recited in claim 10, wherein the user interface comprises one or more of:

a menu for selecting a row of the group of data, a menu for selecting a column of the group of data, a menu for selecting a filter condition, an input field for specifying a value for a filter condition, a menu for selecting a value for a filter condition, and a menu for selecting a data type of a value for a filter condition.

14. The system recited in claim 10, wherein the user interface provides an option to define a date-based filter.

15. The system recited in claim 14, wherein the user interface allows a date range associated with a date-based filtered to at least in part be specified in natural language.

16. A method for processing a group of data, comprising:

providing a user interface for defining one or more filters for a group of data;

wherein the user interface allows one or more parameters associated with a filter definition, including a filter condition, to be specified at least in part in natural language.

17. The method recited in claim 16, wherein a filter definition comprises one or more of a specification of a condition, a specification of a value for a condition, and a specification of a type of a value for a condition.

18. The method recited in claim 16, wherein a filter definition is specified at least in part by selecting one or more of a plurality of pre-configured natural language expressions made available for selection via the user interface.

19. The method recited in claim 16, wherein the user interface provides an option to define a date-based filter.

20. The method recited in claim 19, wherein the user interface allows a date range associated with a date-based filtered to at least in part be specified in natural language.