Method and system for visually indicating a selection query

• US 5,933,145 A
• Filed: 04/17/1997
• Issued: 08/03/1999
• Est. Priority Date: 04/17/1997
• Status: Expired due to Term

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Meek, Christopher A.
• Primary Examiner(s): Bayerl, Raymond J.
• Application Number:
  US08/843,959
• Time in Patent Office: 838 Days
• Field of Search: 345/348, 345/968, 345/967, 345/349, 345/352, 345/354, 345/334, 345/335, 707/4, 707/3, 707/2
• US Class Current: 715/835
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 3/04817 using icons graphical or visual programming using iconic symbols G06F8/34
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 715/968 interface for database querying and retrieval

Abstract

A method and system for specifying a selection query for a collection of data items. The system allows a user to define various conditions (e.g., "Supervisor=Smith") that relate to the collection. A unique icon is then assigned to represent each condition. These icons can either be assigned automatically by the system or assigned by a user. When a selection query is to be specified, the system displays a selection query grid. The selection query grid contains a row for each possible combination of the defined conditions. Each possible combination is represented by displaying the icons for the conditions in that combination in the row. A user can then select which combinations should form the selection query by selecting rows of the selection query grid. The selection query is the logical-AND of each condition or logical inverse of each condition of a selected combination and the logical-OR of all the selected combinations. The system then uses this selection query to retrieve the data items from the collection.

Claims

1. A method in a computer system for specifying a selection query for a collection of data items, the method comprising:

defining a plurality of tags, each tag specifying a condition with respect to the collection of data;

assigning a unique icon to each defined tag;

displaying a selection query grid having rows for possible combinations of the defined tags and logical inverse of the defined tags, each row displaying the unique icons representing the defined tags or the logical inverse of the defined tags in the combination; and

receiving a selection of one or more rows, the selected rows indicating the combinations of defined tags that form the selection query

wherein the selection query indicates to select each data item that satisfies the condition in at least one selected combination.

2. The method of claim 1, including displaying an indication of the condition specified by each tag.

3. The method of claim 1 wherein after receiving a selection of one or more rows, receiving an indication to invert the selection so that all rows that were previously not selected are now selected and all rows that were previously selected are now not selected.

4. The method of claim 1 wherein each icon has a similar shape but a different color.

5. The method of claim 1 wherein each icon has a certain characteristic with one of a plurality of attribute values and wherein the receiving of a selection of one or more rows includes receiving an indication that all rows that display an icon with a certain attribute should be selected.

6. The method of claim 5 wherein the certain characteristic is color and the attribute is the color of the icon.

7. The method of claim 1 wherein the defining of tags includes defining a condition using previously defined tags.

8. The method of claim 7 wherein the defining of a condition using previously defined tags includes displaying a selection query grid having a row for various combinations of the defined tags and the logical inverse of the defined tags, each row displaying the unique icons representing the defined tags or the logical inverse of the defined tags in the combination and including receiving a selection of one or more rows, the selected rows indicating the combinations of tags that form the condition.

9. The method of claim 1 wherein the assigning of a unique icon to each tag includes receiving from a user an indication of the icon to be assigned.

10. The method of claim 1 wherein the receiving of a selection of one or more rows includes receiving an indication to select all rows with a certain tag present.

11. The method of claim 1 wherein the collection is a table with records having fields with names and wherein the defining of a plurality of tags includes the displaying of names of the fields and possible relations and the receiving of a selection of a name of a field, a relation, and a value.

12. The method of claim 1 wherein the collection is a collection of documents and data items are the documents, and wherein the relation includes an indication that a certain word within a document is used in proximity with another word.

13. The method of claim 1 wherein a characteristic of an icon suggests the condition that the icon represents.

14. The method of claim 1 wherein a tag is assigned a preference.

15. The method of claim 14 wherein the preferences are indicated by the displaying the icon in varying sizes.

16. The method of claim 1 wherein the rows include a row for each possible combination of tags.

17. The method of claim 1 wherein rows for combinations of exclusive tags are not displayed.

18. A method in a computer system for specifying a selection query for a collection of data items, the method comprising:

defining a plurality of conditions that relate to the collection of data items;

displaying a selection query grid having rows for possible combinations of the defined conditions and logical inverse of the defined conditions, each row indicating the possible combination; and

receiving a selection of one or more rows, the selected rows indicating the combinations of conditions that form the selection query

wherein the selection query indicates to select each data item that satisfies at least one combination of a selected row.

19. The method of claim 18 wherein each defined condition is assigned a unique icon and the defined condition or the logical inverse of a defined condition in a combination is represented by the presence or absence of the icon in the row.

20. The method of claim 18 wherein when no data item can satisfy a certain combination of conditions, a row representing that combination is not displayed.

21. The method of claim 18 wherein the selection query grid includes a row for each possible combination of the defined conditions.

22. The method of claim 18 wherein the selection query is the logical-AND of defined conditions and of the logical inverse of defined conditions of each selected row and the logical-OR of the conditions of each row.

23. The method of claim 18 wherein a condition is defined in terms of other defined conditions.

24. The method of claim 23 wherein a condition is defined in terms of other defined conditions by selecting rows of a displayed selection query grid.

25. The method of claim 18 wherein each condition is assigned an icon that is suggestive of a meaning of the condition.

26. The method of claim 18 wherein after receiving a selection of one or more rows, receiving an indication to invert the selection so that all rows that were previously not selected are now selected and all rows that were previously selected are now not selected.

27. The method of claim 18 wherein icons are automatically assigned to each condition.

28. The method of claim 18 wherein a user assigns an icon to each condition.

29. The method of claim 18 wherein the conditions are assigned a preference indicating ordering in which selected data items are to be retrieved.

30. The method of claim 29 wherein the conditions are assigned icons and the size of the icon is based on the assigned preference.

31. The method of claim 18 wherein the collection of data items is assigned an icon and the icon is displayed in each row.

32. A computer-readable medium containing instructions for causing a computer system to receive a specification of a selection, by:

defining a plurality of conditions;

displaying a selection query grid having rows for possible combinations of the defined conditions, each row indicating the defined conditions in one of the combinations; and

receiving a selection of one or more rows, the selected rows indicating the combinations of conditions that form the selection query.

33. The computer-readable medium of claim 32 wherein each defined condition is assigned a unique icon and the defined condition or the logical inverse of the defined condition in a combination is represented by the presence or absence of the icon in the row.

34. The computer-readable medium of claim 32 wherein when no data item can satisfy a certain combination of conditions, a row representing that combination is not displayed.

35. The computer-readable medium of claim 32 wherein each defined condition is assigned a unique icon and the defined condition or logical inverse of the defined condition in a combination is represented by the icon without a logical inverse symbol or by the icon with a logical inverse symbol.

36. The computer-readable medium of claim 32 wherein the selection query is the logical-AND of the defined conditions or logical inverse of the defined conditions of each selected row and the logical-OR of the conditions of each row.

37. The computer-readable medium of claim 32 wherein a condition is defined in terms of other defined conditions.

38. The computer-readable medium of claim 37 wherein a condition is defined in terms of other defined conditions by selecting rows of a displayed selection query grid.

39. The computer-readable medium of claim 32 wherein each condition is assigned an icon that is suggestive of a meaning of the condition.

40. The computer-readable medium of claim 32 wherein after receiving a selection of one or more rows, receiving an indication to invert the selection so that all rows that were previously not selected are now selected and all rows that were previously selected are now not selected.

41. The computer-readable medium of claim 32 wherein icons are automatically assigned to each condition.

42. The computer-readable medium of claim 32 wherein a user assigns an icon to each condition.

43. The computer-readable medium of claim 32 wherein the conditions are assigned a preference indicating ordering in which selected data items are to be retrieved.

44. The computer-readable medium of claim 43 wherein the conditions are assigned icons and the size of the icon is based on the assigned preference.

45. The computer-readable medium of claim 32 wherein the collection of data items is assigned an icon and the icon is displayed in each row.

46. A computer system for specifying a selection query, comprising:

a tag component for inputting a definition a plurality of conditions; and

a selection query component for displaying in a selection query grid possible combinations of the defined conditions and for receiving a selection of the displayed combinations

wherein the selected combination forms the selection query.

47. The computer system of claim 46 wherein the defined condition or logical inverse of the defined condition is indicated by display of an icon assigned to the condition without or with a logical inverse symbol.

48. The computer system of claim 46 wherein the selection query is the logical-AND of each defined condition and of the logical inverse of each defined condition in a selected combination and a logical-OR of the selected combinations.

49. The computer system of claim 46 wherein a condition is defined in terms of other conditions by selecting displayed combinations of previously defined conditions.