GB2380576A - Stardard user interface control display for a data provider - Google Patents

Stardard user interface control display for a data provider Download PDF

Info

Publication number
GB2380576A
GB2380576A GB0227921A GB0227921A GB2380576A GB 2380576 A GB2380576 A GB 2380576A GB 0227921 A GB0227921 A GB 0227921A GB 0227921 A GB0227921 A GB 0227921A GB 2380576 A GB2380576 A GB 2380576A
Authority
GB
United Kingdom
Prior art keywords
data
data set
filter
data provider
control
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
GB0227921A
Other versions
GB2380576B (en
GB0227921D0 (en
Inventor
Vorchik David De
Oshoma Momoh
Timothy Allen Satalich
Jr Richard S Turner
Lauren Beth Gallagher
Wayne G Scott
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Microsoft Corp
Original Assignee
Microsoft Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Priority claimed from US08/938,032 external-priority patent/US6279016B1/en
Application filed by Microsoft Corp filed Critical Microsoft Corp
Publication of GB0227921D0 publication Critical patent/GB0227921D0/en
Publication of GB2380576A publication Critical patent/GB2380576A/en
Application granted granted Critical
Publication of GB2380576B publication Critical patent/GB2380576B/en
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2428Query predicate definition using graphical user interfaces, including menus and forms

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Human Computer Interaction (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

A standard user interface enables a user to filter an arbitrary unfamiliar data set intuitively and effectively. The illustrated interface includes a header control presenting labels, filters, and pulldown menus for each attribute of a data set, presented by an associated display control. The control communicates with a data provider through a set of APIs included in the computer's operating system. Through these APIs the data provider indicates the labels and menus to be displayed, while the header control passes new filter criteria to the data provider as it is specified by the user. The data provider filters the data set according to the user-specified filter criteria, and returns the filtered data set for display by the display control. Desirably, new filter criteria are passed to the data provider as they are being typed by the user, allowing the data provider to return successively smaller sets of result data, thus giving the visual impression of a shrinking data set. Non-textual filtering criteria can be input using non-textual interfaces, specified by the data providers. The illustrated control is data-agnostic, allowing its standardized use across a wide variety of data types and data providers.

Description

STANDARD USER INTERFACE CONTROL FOR A DATA PROVIDER
PE7,D Or' THE INVENTION 5 The present invention relates to techniques for posing queries to data providers, and for returning results in a standardized forte.
BACKGROUND
Computer users frequently encounter an overwhelming amount of information 0 when trying to use a computer. A data provider such as an Internet search engine may return thousands of "hiss I' in response to a simple query. A data provider for an email archive may show hundreds of messages which must be scrolled through to find a single one. A computer file directory tree may list tens of thousands of documents in confusing layers. Figure 1A shows a computer system with a different interface 200, 202, 204, 206, 208 for each data 5 provider 210, 212, 214, 216, 218.
To compound the difficulty of accessing this volume of information, data providers do not use a standard user interface. Instead of learning one versatile user interface, a user must become proficient in multiple user interfaces, a time-consuming and frustrating .. task. 2 0 The lack of a standard user interface creates extra work for software developers, who must design a dtfferer.t ir.t.erface for each data provider. For e a. ple, in a windowed environment, a software developer must design a new control with different tabs, buttons, and overall configuration in order to satisfy the requirements of each data provider.
: Existing user interfaces allow Mitering of data sets based on multiple attributes at one tome. But it is not always apparent from looking at a user interface how this is to be accomplished. For example, a user interface might support precision filtering using multiple attributes of a data set only if the user possesses advance knowledge of the data set's attributes 5 or query language. No standard user interface allows precise filtering of a data set on multiple attributes in an intuitive fashion.
A user interface can issue even more precise queries on a data set by supporting multiple comparison modes for each query ternn. For example, the AntoFilter feature of Microsoft Excel 97^supports multiple comparison modes for a query term. AutoFilter allows 10 the user to specify how the query term is to be compared to the data set. One drawback of the AutoFilter implementation is that the user specifies the comparison mode in a dialog box apart from the main user interface.
Iterative related queries are frequently issued by users attempting to successively filter enormous quantities of data down to manageable amounts. For example, a 5 user who issues a simple query to an Internet search engine may receive thousands of "hits" in response. The user may then issue a narrower query to fmd a subset within these responses.
The narrower query is typically the original query + another term.
Enormous redundancy results when the modified query is executed on the entire data set rather than the narrower set returned in response to the first query. A lesser 2 0 redundancy results when the complete set of query terms rather than just the changes to the query terms are passed between the user interface and the data provider. These redundancies
lead to a lack of appealing visual feedback in a user interface and cause slow response time in filtering a data set.
Rather than showing a data set "shrinking" as further criteria are input, most existing user interfaces send a query only after the user has explicitly indicated that 5 formulation of the query is completed. For example, a user types a query and then presses C Enters to send the query. The disadvantage of this method is that the visual impact of seeing the data set shrink, as input is entered, is lost.
Accordingly, some existing user interfaces filter after each keystroke of textual input is entered. For example, many Applications have Help Indexes which are traversed as 10 each keystroke is entered. If the user needs help with the "display," the user types "d" and the index jumps to "d. i! When the user types "i, " the index jumps to "all, " etc. The disadvantage of this method is that a filtering system sometimes gets bogged down if filtering large data sets; responsiveness and visual performance suffer.
A further disadvantage of existing user interfaces is that they do not enable non 5 textual filtering of data sets. Instead, data sets are sorted according to arbitrary patterns of text or exact values of text, even if the user is searching for a color, icon, bitmap, or sound in a data set.
.. The preferred embodiment of the present invention overcomes the shortcomings of the prior art by providing a standard user interface through which a user can effectively and
2 0 intuitively interact with an unfamiliar data provider.
l SINMARY OF THE INVENTION
According to one aspect of the present invention, there is provided in a S computer system, a method for displaying on a display device a control window area used to filter data in a fist data set, the method comprising: receiving frorr.
an arbitrary data provider a first data set, wherein the first data set includes a plurality of data objects and a plurality of attributes associated with the data objects; displaying the first data set in the control window area, together with a 10 plurality of labels, a plurality of pulldown menu buttons, and a plurality of filters, wherein: each label describes an attribute of the first data set, each label is associated with a pulldown menu button, each filter is associated with an attribute of the first data set, and at least one filter receives input used to modify the first data set according to the attribute with which said filter is associated; 15 in response to the actuation of a pulldown menu button next to a labeled attribute, displaying a pulldown menu whose contents are provided from the arbitrary data provider, wherein the arbitrary data provider supplies one or more attribute-specific filtering options, displayed in the pulldown menu, whereby the arbitrary data provider elicits from a user of the computer system input 20 responsive to the one or more attribute-specific filtering options for the labeled attribute; receiving input from the user responsive to the pulldown menu; sending said input to the arbitrary data provider; receiving from the arbitrary data provider a second data sets wherein the second data set is derived by sorting the first data set according to the inputs and displaying the second data 25 set.
In another aspect of the invention, there is provided in a computer system, a method for displaying on a display device a control window area used to filter data ina first data set, the method comprising: receiving from an
arbitrary data provider a first data set, wherein the first data set includes a plurality of data objects and a plurality of attributes associated with the data objects; displaying the first data set in the control window area, together with a 5 plurality of labels, and a plurality of pulldown menu buttons wherein: each label describes an attribute of the first data set, and each label is associated with a pulldown menu button, in response to the actuation of a pulldown menu button associated with a labeled attribute, displaying a pulldown menu whose contents are provided from the arbitrary data provider, wherein the arbitrary 10 data provider supplies one or more attribute-specific filtering options displayed in the pulldown menu, whereby the arbitrary data provider elicits from a user of the computer system input responsive to the one or more attribute-specific filtering options for the labeled attribute; receiving input from the user responsive to the pulldown menu; sending said input to the arbitrary data 15 provider; receiving from the arbitrary data provider a second data set, wherein the second data set is derived by sorting the first data set according to the input; and displaying the second data set.
The preferred embodiment of the present invention is directed to a 20 header control which enables a user to filter an unfamiliar data set intuitively and effectively. The header control and its containing standard user interface simplifies tasks for users and software developers. Users no longer need to become proficient in a multitude of user interfaces. Software developments no longer need to design a new user interface for each data provider. Instead, 25 software developments can supply a minimum of information about the data provider and data set to the standard user interface.
In the described embodiment, the standard user interface is presented as a "QuickFilter" header control in a windowed environment. The standard user :;?
i interface includes a label, filter, and pulldown menu button for each attribute of a data set displayed by a corresponding columnar "listviesv" control. The 5 pulldown menu button can be actuated to display a menu of items associated with an attribute of the data set. The control communicates with a data provider through a set of Application Programming Interfaces (APIs) included in the computer's operating system.
10 Through these APIs, the data provider sends the header control data sets and pulldown menu information, which is then displayed in the header control as part of the standard user interface. The header control notifies the data provider of any changes to the filters of the control. The header control also notifies the data provider of any selections made using the pulldown menu 15 information supplied by the data provider.
lo'
The data provider filters the data set according to the filter change and selection information received from the header control. Each data provider determines how to filter a data set given the information received from the header control. Once the data set is filtered, the data provider sends it back to the listview control, where it is displayed.
5 The header control is designed for intuitive and easy use. It enables precise, intuitive queries by positioning a label and a filter for each of the attributes of a data set above that displayed attribute of the data set. As the filters are changed by the user, the data set is filtered by the data provider and redisplayed in the listview control, creating the visual effect of the data set shrinking as filter input is received.
0 The header control accomplishes this visual "shrinking" effect by sending filter change notifications without explicit signaling from the user to do so. To prevent the filter requests from becoming backlogged and ruining the advantageous shrinking effect, a filter timer -- set by the data provider -- determines how often filter requests are sent. If the filtering and redisplay of a data set can be done quickly, the data set might be filtered after 15 each keystroke of input. On the other hand, if the filtering and redisplay of a data set take longer, the filter timer may be set for a longer duration to balance the responsiveness of the display against performance degradation caused by reconstructing the set too frequently.
... In the described embodiment, the pulldown menus display information about comparison modes by which a filter for an attribute may be compared to the data set.
o Displaying this information in a pulldown menu near the attribute for which the information is relevant provides another intuitive aspect of the standard user interface.
l In, an alternate embodiment, the pulldown menus display custom controls (or launch a second window displaying custom controls) supplied by the data provider. Custom controls enable the user to enter non-textual filter input used to filter a data set with non textual attributes. For example, a custom control may be a color palette on which a user 5 selects a color then used to filter a data set by color. The foregoing and additional features of the present invention will be more readily apparent from the following detailed description, which proceeds with reference to the accompanying drawings.
DESCRIPTION OF THE DRAWINGS
0 Figure 1A is a diagram of a computer system with existing user interfaces to access different databases.
Figure 1B is a diagram of a computer system with a user interface according to one embodiment of the present invention to access different databases.
Figure 2 is a diagram illustrating a computer system that serves as an operating 15 envirorunent for an implementation of the invention.
Figure 3 is an illustration of a window control containing (1) a listview control with a space for a data set, and (2) a header control with labels for the data set attributes, pulldown menu buttons, and filters for the attributes.
Figure 4 is an illustration of the window control of Figure 3 displaying a data 2 0 set made up of rows of data objects described in columns of attributes.
ret Figure 5 is an illustration of the window control of Figure 4 with a pulldown menu button actuated and a pulldown menu displayed after retrieval of comparison mode information from a data provider.
Figure 6 is an illustration of the window control of Figure 4 after the data set 5 has been filtered by Type "MS," Comparison Mode "Starts with. " Figure 7 is an illustration of the window control of Figure 4 after the data set has been filtered by Type "Word, " Comparison Mode "Ends with. " Figure 8 is an illustration of the window control of Figure 4 after the data set has been filtered by Type "MS," Comparison Mode "Starts with," and Date "97," Comparison 10 Mode "Year."_ Figure 9A is an illustration of the window control of Figure 4 after the data set has been filtered by Type "MS Wor," Comparison Mode "Starts with," where the filtering process was initiated when the filter timer expired.
Figure 9B is an illustration of the window control of Figure g^A; after the data 15 set has been filtered by Type "MS Work," Comparison Mode "Starts with," where the filtering process was initiated when the user pressed c Enter >.
Figure 10 is an illustration of a window control showing a data set composed of homes and a custom control menu which displays an area for filter input and an area for .. comparison mode input.
t. {
Figure 11 is an illustration of the window control of Figure 4 showing a unique value list menu which displays each of the unique values of the column above which it is located and which is used to obtain filter input.
Figure 12 is a flowchart showing a method according to one embodiment of the 5 present invention.
Figure 13 is a flowchart showing the responses taken by the header control in different circumstances.
Fig. 14 is an illustration of a window control that has launched a secondary "calendar" window when the "Modified" pulldown menu is activated.
0 Fig. 15 is like Fig. 14, but shows selection of a range of dates in the secondary "calendar" window.
Fig. 16 shows another secondary window that may be launched by activation of the "Modified" pulldown menu - this one permitting selection of a "Modified" attribute around a specified date.
DETAILED DESCRIPTION
The invention is illustrated with reference to a method and apparatus for providing a standard user interface (SUI) to an arbitrary data provider. Through the use of the STAT., a user car. submit a precise query to an unfamiliar data provider and receive a timely 2 0 response. The timeliness of the response varies to maximize the efficiency of the query and the visual impact of continuously displaying intermediate updated results of a query. In the
illustrated embodiment, standardization of the SUI is accomplished by the adoption of a set of Application Programming Interfaces (APIs) by the SUI and the data providers.
Operating Environment for the Present Invention 5 Figure 2 and the following discussion are intended to provide a brief, general description of a suitable computing environment in which the invention may be implemented.
While the invention is described in-the general context of computerexecutable instructions of a computer program that runs on a personal computer, those skilled in the art will recognize thee the invention also may be implemented in combination with other program modules.
10 Generally, program modules include routines, programs, components, data structures, etc. that perform particular tasks or implement particular abstract data types.
- Moreover, those skilled in the art will appreciate that the invention may be practiced with other computer system configurations, including hand-held devices multiprocessor systems, microprocessor-based or programmable consumer electronics, minicomputers, mainframe 15 computers, and the like. The invention may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote memory storage devices.
Figure 2 illustrates an example of a computer system that serves as an operating 2 0 environment for the invention. The computer system includes a personal computer 120, having a processing unit 121, a system memory 122, and a system bus 123 that interconnects if
various system components including the system memory to the processing unit 121. The system bus may comprise any of several types of bus structures including a memory bus or memory controller, a peripheral bus, or a local bus using a bus architecture such as PCI, VESA, Microchannel (MCA), ISA and EISA, to name a few.
5 The system memory includes read only memory (ROM) 124 and random access memory (RAM) 125. A basic input/output system (BIOS), containing the basic routines that help to transfer information between elements within the personal computer 120, such as during start-up, is stored in ROM 124.
The personal computer 120 further includes a hard disk drive 127, a magnetic 10 disk drive 128, e.g., to read from or write to a removable disk 129, and an optical disk drive 130, e.g., for reading a CD-ROM disk 131 or to read from or write to optical media. The hard disk drive 127, magnetic disk drive 128, and optical disk drive 130 are connected to the system bus 123 by a hard disk drive interface 132, a magnetic disk drive interface 133, and an optical drive interface 134, respectively. The drives and their associated computer-readable 15 media provide nonvolatile storage of data, data structures, computer-executable instructions (program code such as dynamic link libraries, and executable files), etc. for the personal computer 120.
Although the description of computer-readable media above refers to a hard
disk, a removable magnetic disk and a CD, it can also include other types of media that are 2 0 readable by a computer, such as magnetic cassettes, flash memory cards, digital video disks, Bernoulli cartridges, and the like.
A number of program modules may be stored in the drives and RAM 125, including an operating system 135 (e.g. Windows NT, Windows 95, MS-DOS, etc.), one or more application programs 136, other program modules 137, and program data 138.
A user may enter commands and information into the personal computer 120 5 through a keyboard 140 and pointing device, such as a mouse 142. Other input devices (not shown) may include a microphone, joystick, game pad, satellite dish, scanner, or the like.
These and other input devices are often connected to the processing unit 121 through a serial port interface 146 that is coupled to the system bus, but may be connected by other interfaces, such as a parallel port, game port or a universal serial bus (USB).
10 monitor 147 or other type of display device is also connected to the system bus 123 via an interface, such as a video adapter 148. In addition to the monitor, personal computers typically include other peripheral output devices (not shown), such as speakers and printers. The personal computer 120 may operate in a networked envirorunent using 15 logical connections to one or more remote computers, such as a remote computer 149. The remote computer 149 may be a server, a router, a peer device or other common network node, and typically includes many or all of the elements described relative to the personal computer 120, although only a memory storage device 150 has been illustrated in Figure 1. The logical connections depicted in Figure i include a local area network (LAN) lSi and a wide area 2 o network (WAN) 152. Such networking environments are commonplace in of rices, enterprise-wide computer networks, intranets and the Internet.
When used in a LAN networking environment, the personal computer 120 is connected to the local network 151 through a network interface or adapter 153. When used in a WAN networking environment, the personal computer 120 typically includes a nom i Or other means for establishing communications over the wide area network 152, such as the 5 Internet. The modem 154, which may be internal or external, is connected to the system bus 123 via the serial port interface 146.
In a networked environment, program modules depicted relative to the personal computer 120, or portions thereof may be stored in the remote memory storage device. It will be appreciated that the network connections shown are exemplary and that other means of 10 establishing a communications link between the computers may be used.
The Header Control and Standard User Interface Figures 1B and 3-13 illustrate the functionality of the header control and listview control that comprise the Standard User Interface (SUI) of an embodiment of the 5 present invention. Figures 1B and 3-8 show the workings of Me header control and SUI as a whole, while Figures 9A and 9B shows how the filter timer for textual filter input works within the SUI. Figures 10 and 11 show alternate embodiments of the present invention using .. custom control menus and unique value lists, respectively. Figures 12 and 13 are flowcharts more generally describing operation of the illustrated system.
2 o Figure 1B shows an illustrative SUI according to the present invention. In contrast to the multiple UIs needed to access multiple data providers 210, 212, 214, 216, 218
according to the methods of the prior art, the present invention provides a single SUi 220 to
access multiple data providers.
The illustrated SUI 220 can access any data provider designed accorded to the APIs detailed below. For example, the SUI can be used to access a file directory tree 212 s through a file manager 202 employing the belowdiscussed APIs. The same SUI can be used to access spreadsheets 216, the Internet 214, or email archives 218.
SUI 220 offers advantages for users of computer systems and for software designers. Users no longer need to learn different query languages or remember how to manipulate different interfaces in order to access different data providers. Software developers 0 no longer nee to design data provider-specific user interfaces. Instead, software developers can rely on the features of the SUI.
Figure 3 shows a control 222 containing SUI 220 after the control is launched by the user. The SUI illustrated in Figure 3 is part of a standalone control. In an alternate embodiment, the SUI is part of another query control.
15 The control 222 includes an area 310 for the display of a data set (including columns 350, 352, 354, 356 for attributes), labels 320, 322, 324, 326 for the attributes of the data set, filters 330, 332, 334, 336 for the attributes of the data set, and pulldown menu buttons 340, 342, 344, 346 next to the labels of the attributes. The number of attributes and labels of the attributes are known when the control is launched. In an alternate embodiment, 2 0 the number of attributes and labels for the attributes are gleaned from the data set displayed in
the control. In any case, the number of columms and the labels for the attributes vary depending on the data set.
In the illustrated embodiment, the header control is launched independently of the listview control. This means that the header control may become visible before a data set 5 is displayed, as shown in Figure 3. In an alternate embodiment, the data set is displayed within the listview control as soon as the header control is launched. The data provider supplies the data set as well as the information contained in die pulldown menus which are activated by pressing the pulldown menu buttons on the header control.
As will be recognized by those skilled in the art, the precise configuration of the 0 data set area, labels, filters, and pulldown menu buttons can be modified as desired. _ Figure 4 shows the control of Figure 3 displaying a data set. The data set includes rows 360 of data objects and columns 370 of attributes describing those data objects.
Though the data set illustrated in Figure 4 is composed of application documents described by name, type, path, and date, any other data set can be used. For example, data sets can include 15 World-Wide-Web pages registering hits according to an Internet search engine, email messages stored in an email archive, or data records in a spreadsheet. The data set is supplied by the data provider. The illustrated listview control can accommodate a data set with an .. arbitrary number of data objects or data attributes. The illustrated header control can similarly accommodate an arbitrary number of data attributes.
2 0 As will be recognized by those skilled in the art, the precise organization of the data set can be altered without changing the functionality of the illustrated embodiment. For
example, the rows of the data set could be attributes while the columns could represent data objects. Figure 5 shows the SUI of Figure 4 with a pulldown menu button 342 pressed and a pulldown menu 382 displayed by the header control. The pulldown menu 382 displays 5 the comparison modes by which the filter 332 (Fig. 3) of the attribute of column 352 should be applied to the data set. For example, the pulldown menu for the "Type" attribute is displayed.
By selecting a comparison mode, a user can check whether any member of the data set has a Type which "Starts with," "Ends with," ',Is "exactly), " or "Is riot" She term input into the filter 332 for the attribute.
10 The data provider supplies the comparison mode information displayed in the pulldown menu. This information can be different for each attribute. In Figure 5, the user has selected the comparison mode "Starts with" with a cursor 390 of a pointing device. (As will be recognized by those skilled in the art, other input devices can be used to select a comparison mode without changing the functionality of the illustrated embodiment.) If the 15 user does not select a comparison mode for an attribute, the data provider uses a default comparison mode when executing a query.
Figure 6 illustrates the SUI of Figure 4 after the user has entered input into the header control's Type filter 332. The user has activated the Type filter by clicking on the filter using a pointing device. Prompted by the click on the filter, the filter switched to edit 2 0 mode. The user has typed in "MS " and pressed < ENTER to send a data change to the data
provider. Alternately, the user could click elsewhere on the SUI with the pointing device to exit edit mode.
When the user exits edit mode, the filter change is sent by the header cvr..ol to the data provider. The data provider filters the data set according to the Type filter term s "MS " and the comparison mode "Starts with, " which could have been selected by the user or could have been the default comparison mode. The filtered data set has been returned by the data provider and displayed in the listview control.
Although a data provider determines how to execute a query using filter and comparison mode input, normally a data provider ignores filters that have never been changed 0 by a user. In other words, by default, filters are blank (or otherwise shown as inactive) and not used in filtering.
As will be recognized by those skilled in the art, different methods of activating and exiting the filters for the purposes of editing can be usedwithout changing the functionality of the illustrated embodiment.
15 Figure 7 illustrates the SUI of Figure 4 after the user has selected Type comparison mode "Ends with" and Type filter "Word. " The data provider has filtered the data set according to the filter and mode information passed to it. The filtered data set has been returned by the data provider and displayed in the listview control.
Figure 8 illustrates the SUI of Figure 4 after the user has selected Type 2 0 comparison mode "Starts with, " Type filter "MS, " Date comparison mode "Year, " and Date filter "97" within the header control. The control displays the data set and the header control
displays the filters after the data provider has filtered the data set using all of this information.
The data provider determines how to apply the filters and mode selections to the data set. In Figure 8, the data provider filtered data objects starting with "MS" AND hazing year "97." Alternatively' a data provider could have filtered data objects starting with "MS" 5 OR having year "97. ' A data provider can use the filter terms and mode selections in any filtering algorithm. The filtering process is invisible to the header control and listview control of the illustrated embodiment. The header control sends filter changes and mode selections to the data provider (or its interface program) and the listYiew contro! receives filtered data sets in return.
10 Although Figure 8 shows the data set after filtering according to all of the -terms of the query, as noted above, filter changes are sent to the data provider when the user exits edit mode for a particular filter. Comparison mode selections are sent to the data provider when made. When the data provider receives a filter change or comparison mode selection, the data provider filters the data set according to the most recent terms of the query. For the 15 query of Figure 8, the data provider would have executed multiple filtering operations before the filtering operation resulting in the data set of Figure 8.
The Timer on Textual Filter Changes Figures 9A and 9B shows the SUI of Figure 4 working with a timer on textual 2 0 filter changes. When the user edits a filter, the timer measures the time elapsed since the user last entered keyboard input. As keyboard input is received, it is batched by the header control
until sent to the data provider as a filter change. The head control automatically sends the batched input when the user exits edit mode for the filter. In addition, if the time elapsed since keyboard input was last received (or time elapsed since a query was last se.n, to tithe data provider) is above a certain limit, the batched keyboard input is sent to the data provider.
5 Referring to Figure 9A, suppose a user of the illustrated embodiment is a novice typist and the timer is set for 2 seconds. The user wants to filter the data set of Figure 4 according to Type "MS Works." The user types "MS Wor," but before the user can find "k" on the keyboard, the timer expires and the filter change Type "MS Wor" is sent to the data provider. The data set filtered according to Type "MS Wor" and Comparison Mode "Starts 10 with" (default) is returned and displayed.
Referring to Figure 9B, suppose the user then finds the "k" and types "ks < ENTERS. " The < ENTER > causes the user to exit edit mode, automatically sending the filter change Type 'ks' to be sent to the data provider immediately without waiting for the timer to expire. The data set filtered according to Type "MS Works" and Comparison Mode 15 "Starts with" (default) is returned and displayed.
The timer in the illustrated embodiment is reset after each keystroke of input is received. If the timer is set for 3 seconds, a pause of less than 3 seconds between keystrokes causes the keystrokes to be batched into a single filter change and the timer to be reset after each keystroke. A pause of 3 or more seconds after the last keystroke is received causes the 2 o batched keyboard input to be sent as a filter change.
in the illustrated embodiment of the invention, the timer is set by the data provider and can be changed. If the data provider sets the timer with a very short duration, the data provider filters after each keystroke is input. In such a case, if the data provider's filtering operation takes longer than the typing of keystrokes, the data provider may become 5 bogged down in filter requests, causing slow visual responses in the redisplay of data sets and causing a slow response when the user explicitly initiates a filter operation by exiting edit mode. On the other hand, when the timer is set with a long duration, the SUI loses the advantageous visual impact of "shrinking" a data set as the user types in keystrokes.
10 Accordingly, the data provider sets the timer to balance the responsiveness of the SUI against the performance degradation caused by reconstructing the data set too frequently. If the data provider becomes more busy or less busy, the optimal time may change. For example, if the data provider is an Internet search engine, the time will be longer at peak hours for Internet use and shorter at off hours for Internet use.
15 As will be recognized by those skilled in the art, if it was possible to predetermine an optimal time for the data provider, the timer could be set by the header control when launched without changing the functionality of the illustrated embodiment.
The Custom Control Menu 2 0 Figure 10 illustrates an alternate embodiment of the control and SUI of the illustrated embodiment. In this embodiment, when the user actuates the pulldown menu button -if
342, a custom control menu 402 is displayed. The data provider supplies the custom control 412 displayed in the pulldown menu. In an alternate embodiment, the data provider signals to the control which one of plural custom controls 412 to display in the pulldown menu. (The color picker control 412 in Fig. 10 is necessarily grey due to patent reproduction limitations.
s In actual practice, the color picker presents a 2D spectrum of color choices.) The user interacts with the custom control 412 to input (e.g. with the cursor 390 of a pointing device) non-textual query terms for the attribute 352 with which the custom control is associated. These nontextual query teens are used as text filters are used to filter a data set.
10 For example, suppose the data set being searched is cars stocked by local par dealers, as detailed on a page on the World Wide Web. One attribute of each car is color. A potential car buyer with a limited color vocabulary (white, off-white, greenish-gray, etc.) would be at a disadvantage using a textual search for a car of a desired color. To overcome the user's inability to describe the full range of car colors in textual terms, and to enable a 15 more intuitive filter, the illustrated embodiment allows for a custom control 412 in the form of a color palette for car colors. Presented with this color palette, the user selects a color with the pointing device. The selection is passed like a filter change to the data provider. The data provider then filters the data set using the color selection as a filter.
The custom control menu displays comparison mode information supplied by 2 0 the data provider in a pulldown menu 382 alongside the custom control menu 402. For example, if the custom control 412 is a color palette, the comparison modes "Is close to" and 2 'A
"Is not" might be displayed. In an alternate embodiment, the custom control menu contains the custom control, while comparison mode information is presented in a separate menu.
In yet another alternative embodiment, the custom control may take the form of a secondary window, launched by activation of a filter's pulldown menu, or by selection of a 5 'Custom ' entry on the pulldown menu.
Fig. 14 shows such an arrangement, in which a secondary "calendar" window is launched when the user activates the "Modified" pulldown menu. The user can click on a single cats in the calendar or, as shown in Fig. 15, may drag the cursor control device across a range of dates in the calendar window. In the former case, a single date is entered in the 10 "Modified" filter field; in the latter, a range of dates is entered.
Fig. 16 shows another example of a secondary window that may be launched when a user activates the "Modified" pulldown menu button. In this example, the secondary window allows the user to pick one of several conditions, e.g. On, Between, or Around. If the user selects Around, a slider control activates that allows entry of the range of time around 15 the specified date that will meet the filter criteria. -I Returning to the custom color selector, if color data is stored in the data provider in quantitative form (e.g. ROB, YW, etc.), then the "is close to" condition may be satisfied by colors whose corresponding color components are all numerically within, e.g., 15 % of the color components of the color selected by the user. (In a variant embodiment, 2 o different percentage ranges may be used for different color components when judging "closeness," in accordance with the human eye's differing sensitivity to differing colors.)
Although not shown in Fig. to, other color relationships that may be specified include "lighter than" and "darker than." These can be adjudged, e.g., by converting the user-picked color to a corresponding gray-scale value, and comparing that value t..'ith corresponding gray-scale values of the colors stored in the data provider.
The Unique Value List Figure 11 illustrates an alternate embodiment of the header control and SUI of Figure 4. In this embodiment, when the user actuates the pulldown menu button 342, a unique value list menu 422 is displayed. The unique value list enumerates the unique values of the 1 o attribute with which the unique value list is associated. For example, the unique value list of Figure 11 displays "MS Word," "MS Excel," "MS Works, " and "Text, "-an exhaustive list of all the data types of stored in the data provider.
The unique value list displayed in a pulldown menu is used by the user to select - a value with the pointing device. This selection is passed as a filter change to the data 15 provider, which then uses the unique value selection to filter the data set.
The data provider supplies the unique value list. Before initializing the contents of the pulldown menu, the data provider scans the current data set and determines the unique values present for a given attribute of the data set. The unique values are passed back much as comparison modes are passed back.
2 0 As noted earlier, if filters are set for several attributes, the data provider ANDs these together when performing the query. The unique value list allows a powerful extension
! of this basic protocol: if the user selects several different values in a single attribute unique value list (e.g. by holding the Control key while selecting multiple values), then these are ORed together when querying the data provider. This arrangement has been found, in usability testing, to provide a highly intuitive interface.
Narrowing Searches As noted, iterative related queries are frequently issued by users attempting to successively filter large quantities of data down to manageable amounts. For example, a user who issues a simple query to an Internet search engine may receive thousands of ''hits" in 1 o response. The user may then issue a narrower query to find a subset within these responses.
The narrower query is typically the original query + (or "AND") another term.
Tremendous redundancy results when the modified query is executed on the entire data set rather than the narrower set returned in response to the first query. This redundancy impairs visual feedback in a user interface and slows response time.
Is In the illustrated embodiment, the handling of narrowed filters is left to the specific data provider being queried. When a second query, further limiting the results of an immediately preceding query, is presented, some data providers may execute the search anew.
Other, more intelligent data providers, may maintain and refine the results of the prior search, rather than starting anew.
Queries as Objects In many situations, it is advantageous to pass a query to another user instead of passing just the query results. (The latter may soon be outdated, and may be volume: c s as well.) In the illustrated embodiment, a user can pass a QuickFilter control to another user, 5 e.g. by email. That other user can then execute the passed query when and as desired.
Cursored Scrolling Sometimes the filter criteria may be set so broadly that hundreds of data objects in the data provider (or more) qualify for display. In one embodiment, all data objects that 0 meet the filter criteria are passed to the listview control for display, regardless of their number. In another embodiment, a [united number of objects (e.g. twice as many as can be displayed in the window) are passed. This allows for some scrolling through a window, without burdening the system with extensive data transfers. If the user tries to scroll past the last entry in the window, the data provider can be instructed to be provided additional objects 15 for display by the listview control.
Sort Order .. In the illustrated embodiment, sorting of the objects displayed in the SUI is effected by the data provider, which provides the objects to the listview control in a sorted 2 o order. In other embodiments, sorting can be effected on the SUI side.
The Header Control and Application Programming Interfaces As indicated, the header control communicates with the data provider and the parent of the control by means of a set of APIs. Generally, the APIs work through the exchange of messages and notifications. The header control sends notifications to the parent of the control and to the data provider through the parent. The header control receives messages from the parent and from the data provider through the parent.
Figure 12 is a high level flowchart of the header control of the illustrated embodiment. As illustrated in Figure 12, the header control is launched 500 by the user. At this point the control frame, labels, filters, and pulldown menu buttons are displayed. The 10 data set may be_displayed at this time or not, depending on whether the listview controLis also initialized. The header control can be launched as a standalone control or as part of a larger query window. Either way, the header control has a parent through which it sends and receives messages. If launched in Microsoft Windows, the Win32 CreateWindow API is used.
If the header control is created according to the standards of Microsoft's 15 QuickFilter, the control is described in messages to the control and notifications from the control as a NM QUICKFILT R or QF FILTER structure.
QF_FILTER
This structure is passed as part of the messages from the data provider involving 2 o individual filters. The message allows the parent to set or retrieve the current filter values for a particular column.
2 7
The field dwType indicates which of the filter values are valid based on the
FILTER_TYPE_* values. If dwType is FILTER TYPE_INT then the iFilter field is valid.
When dwType is FILTER_TYPE_STRING, it is assumed that pszFilter points to a suitable buffer from which to set the filter data or into which to return the filter data. When setting the 5 filter the cchFilter defines the maximum edit size of the filter, and when returning the filter it defines the buffer size pointed to by pszFilter.
#define FILTER_TYPE_STRING OxO1 #define FILTER_TYPE_INT Ox03 typedef struct DWORD dwFlags; // reserved (should be zero) DWORD dwTyDe; // one of the FILTER-TypE-chla values union 15 ANT iFilter; // valid if dwType == Fr TER_TYPE Ih struct LPSTR pszFilter; // valid if dwType == PILTER_TYPE STRING 2 0 INT-- cchFilter; // valid if dwType == FILTER TYPE STRING ) QF_FILTER, LPQFFILTER;
NM_QUICKFILTER
2 5 When communicating back to the parent of the header control by a WM_NOTIFY notification, a NM_QUICKFILTER structure indicates which column is the subject of the notification. All notifications from the QuickFiIter control have this header.
The NMHDR field is a standard part of any notify message. iColurun indicates
which column within the header is the subject of the notification.
3 0 typedef struck NM R hdr; INT iColumn; 3} NM_QUICKFILTER;
Once launched, the header control waits (520, Fig. 12) to receive messages.
When the control receives a message, it translates (540) the message in order to determine how to act in response to the message.
After translating a message, the header control acts (560) on the message before 5 returning to the state of waiting (S20) for the next message. An action taken by a control can be closing the control (570), moving or resizing the control, rearranging the appearance of the control, or sending a notification to the parent of the control or data provider through the parent. Many messages are standard messages for manipulating a header control and are 10 not specifically directed to the control of the illustrated embodiment. For example' if implemented in a windowed environment, the control of the illustrated embodiment receives Win32 HDM_ messages from the parent that tell it to rearrange the columns of the control.
The control also receives other standard Win32 messages from the parent that tell it to move or resize the control.
15 The header control receives HDM messages from the data provider through the parent which provide the data set displayed as part of the standard user interface. The header control further receives HMENU messages from the data provider through the parent which provide the information displayed in the pulldown menus.
In addition-to these standard messages, the header control receives over 2 0 messages which are specific to Me control of the illustrated embodiment. These messages are described in the following section.
-c1
rat API Messages and Notifications The illustrated header control responds to messages directing it to se. a ful.cr, get a filter, show/hide all filters, set the parent to which notifications are sent, and set the 5 duration of the filter timer.
If the header control is designed according to the standards of Microsoft's QuickFilter, the messages directing the control to do the above actions are implemented as fo!!ows. o QFM_SETFT TER The parent sends this message to set the filter value for a particular column.
wParam contains the column to set the filter on, which is assumed to have been previously added to the QuickFilter control by lIDM_SETITEM. lParam contains a pointer to a QF FILTER structure.
15 If the filter is an integer filter (FILTER_TYPE_INT) the value is simply stored in memory. When the edit control is created to allow the user to modify the value, the corresponding style bits are set to allow the user to only enter digits.
If the filter is a string filter (FILTER_TYPE STRING) a copy of the string pointed to be pszFilter is made. When the string value is edited, the cchFilter is used to limit 2 0 the number of characters the user can type.
The call returns TRUE if successfully.
3'
l T" QFM_GETFILTER
The parent sends this message to get the filter value for a particular co'ur l.
wParam contains the column to get the filter from. lParam contains a pointer to a 5 QF_FILTER structure.
The structure is filled to contain the current filter contents and type. It is assumed that the data provider knows the type of the filter for a particular column and that the QF FILTER structure contains a valid buffer pointer and size.
If the filter is FILTER_TYPE_INT, the integer value is simply stored into the 0 structure. If the filter is FILTER_TYPE STRING, the string is copied to the buffer supplied by the data provider if that buffer is large enough. Otherwise, the call fails.
The call returns TRUE if successful.
QFM_SHOWFILTER
15 By default the filter bar for the control is visible. This message allows the caller to show or hide it based on the value in wParam. If wParam is non-zero then the filter bar is shown, otherwise it remains hidden.
The call returns the previous visible state of the filter bar.
QF I_SETNOTIFYTARGET
When using the QuickFilter header control to replace the standard header control in a list view, notifications are sent to the ListView by default, as if is one parent OT one control. QuickFilter can specify that instead, notifications will be sent to the window 5 described in HWND of lparam.
The call returns TRUE if successful.
QFM_SETCHANGETlMEO-u When editing a filter, the QuickFilter control batches up the edits and sends a 10 single notification (QFN CHANGE) after a specified timeout. This message allows a data provider to change that timeout from its default, which is twice the double click time out.
lParam contains the time in milliseconds to set the filter timer.
The call returns TRUE if successful.
5 The illustrated headercontrol also sends notifications telling the data provider that a filter has been changed, requesting that the data provider return a pulldown menu, telling the data provider that an operator was chosen, and telling the parent that a filter has started or finished being edited.
If the header control is designed according to the standards of Microsoft 2 o QuickFilter, these notifications are implemented as follows.
at
- QFN_CHANGE
The QFN CHANGE notification notifies the parent of the header control that one of the filters has changed. A NMQUICKFILTER structure is passed as a parameter am contains information about both the control and the column that was modified.
5 QFN_CHANGE notifications are sent after the filter timer has expired, after the user presses C ENTER > within the edit control, or after the user selects a comparison mode from the pulldown menu.
The value returned by this notification is ignored.
10 QFN GETOPERATO}IMENU
The QFN_GETOPERATORMENU notification is sent when the filter wants to display the comparison operator menu for a particular column. A NM_QUICKFILTER structure is passed as a parameter and contains information about both the control and the column for the display. The parent, upon receipt of this message should return a HMENU 15 which will be displayed. If the return value is NULL then the call ignores the operator menu for that column. The return value from this notification is either a HMENU or NULL.
Q N OPERA TORCHOS EN
After the comparison operator menu has been displayed and the user has made a 2 o selection the QuickFilter control sends this notification to the parent to ir for r. thern of tale change.
The value returned by this notify message is ignored.
This notification passes, as a parameter, a structure NM_QFOPERATORCHOSEN. Having sent a QFN GETOPERATORMENU noti icaiion, the filter control calls TrackPopupMenu on it to display the result. The return code from that 5 TrackPopUpMenu is passed to the parent using as NM_QFOPERATORCHOSEN.
NM_QFOPERATORCHOSEN consists of a NM QUICKFILTER header and a wID field containing the result of TrackPopupMenu assuming it was non-zero.
typedef struct 10 NM_QUICKFILTER nmqf; } NM_QFOPERATORCHOSEN;
QIiN_BEGINFILTEREDIT 5 Q]iN_ENDFILTEREDIT These two notifications are used to inform the parent when a filter is being edited. A NM_QUICKFILTER structure is passed as a parameter and contains the identification of the column being edited.
The value returned by this notify message is ignored.
In embodiments using custom controls, a Microsoft COM object is employed to implement an interface named IQFCustomFilter. This interface interacts between the QuickFilter header control and He custom filter, as follows:
HRESULT IQFCustomFilter::Edit (HWND hwndParent, POINT, ptHit, HWND* phWnd) When the user clicks in the filter area,::Edit method is called, passing the relative X/Y (as a 5 point). The method returns a HWND into the pointer provided. If the call returns S FALSE or a failure then phWnd is assumed to be invalid. Otherwise, the window is displayed, allowing the user to edit the property.
lIRESI}LT IQFCustomFilter::Render 10 (HDC hDC, RECT rect, DWORD dwState) This is called to display the filter in the filter bar. The ICustomFilter object is responsible for rendering a representation of the data it holds into the given HDC/rectangle.
15 HRESI)LT IQFCustomFilter::GetOperatorMenu (HMENU* phMenu) HRESULT IQFCustomFilter::OperatorChosen MINT uID)
These map directly to the QFN GETOPERATORMENU / QFN SETOPERATOR notifications sent by the filter control to the parent. If the ICustornFilter object returns E_NOTIMPL from ICustornFilter::GetOperatorMenu the standard notification is issued. A QFN_OPERATORCHOSEN is always issued to allow the parent to store the operator ID.
5 When returning the operator menu a HMENU is returned to the pointer specified. If this is NULL or the call returns S_FALSE then it is ignored.
QFM _DTSM'SSEDIT
wParam = fRefresh 0 lParam = 0 When the custom filter editor has modified the state of the filter a QFM_DISMISSEDIT is sent to indicate completion. fRefresh indicates whether the custom filter object should re-render itself into the filter bar.
As will be recogruzed by those skilled in the art, the functionality of the illustrated embodiment does not depend on the use of messages and notifications exactly like those detailed above; they are detailed simply as illustrative examples.
3<
The Edit Control and Filter Timer The flowchart of Figure 13 shows the functioning of the edit control and filter timer used in the illustrated embodiment.
An edit control is launched (600), as described above, when the user clicks on a 5 filter and the control sends a notification (QFN BEGINFILTEREDIT) to begin editing the filter. The filter input batch is erased (602). The filter timer is then reset (604) to the value specified by the data provider. The edit control is placed over the filter clicked by the user.
Once launched, the edit control waits for messages changing the duration of the filter timer (620) or ending the edit (630), waits for keyboard input (640), and maintains a filter timer 0 (650).
If the edit control receives a message changing the filter timer (QFN_SETTIMEOUT) (620), the duration of the filter timer is changed as specified by the message, and the tuner is reset (622).
If the edit control receives a message telling it to end the edit s (QFN ENDFILTEREDIT) (630), the edit control closes (632) and the filter displays the text string as last modified in the edit control.
If the edit control receives a keystroke (640), the filter tuner is reset (642).to the level specified by the data provider (QFM_SETTIMEOUT). If the keystroke is C Enter > (670), the user has explicitly requested that the data provider initiate a filtering operation. If 2 0 there are arty batched filter changes, these changes are sent ( 80) to tile data provider (QFN CHANGE) before closing the edit control. If the keystroke is anything but C Enter >,
the keystroke is added (674) to a batch file containing all of the filter changes made since the last batch of filter changes was sent to the data provider (QFN_CHANGE). The timer is reinitialized (676) and records the time elapsed since the last keystroke. The control then waits for the next input.
5 If the edit control receives neither a keystroke (640), timeout message (620), nor end edit signal (630), the filter.timer is checked (650). If the filter timer has expired (i.e. the time elapsed since the user last input a keystroke is greater than or equal to the time set by the data provider), and the filter batch is nonempty, the control sends a filter change notification (QFN_CHANGE) (660) to the data provider with the batched filter changes as a 0 parameter (680; The control then waits forthe next input. If the user has not input any keystroke at all or has not input any keystroke since the last batch of filter changes was sent, the batch is empty, the elapsed time is zero, and the control waits for the next input.
As will be recognized by those skilled in the art, the precise ordering of steps in the flowchart of Figure 13 can be altered in numerous ways without changing the functionality is of the illustrated embodiment.
Web Implementation Embodiments of the present invention find particular utility in winnowing results of internet-based searches. In such embodiments, the data provider is typically a 2 0 remote computer linked to the user's computer over a communications linlc. Popular search
engines that may serve as such remote computers include Excite, Lycos, HotBot and AltaVista. In such embodiments, communications between the graphical query interface on the user's computer and the remote data provider cannot usually be effected by the Microsoft 5 Windows APIs detailed above. Instead, such communication takes place by other means. If the system is implemented in lava or the like, Java notification events can be used to effect the communications. In other embodiments,- HTTP communications can be used.
The data attributes by which internet objects may be filtered include date, size, domain, textual abstract, etc. 10 As in other web-based applications, the issue of communications latency should be dealt with. In a preferred embodiment, the time constant used by the timer (detailed above) is adaptively set in accordance with actual network latency (as measured by known techniques), as well as the current processing burden under which the data provider is laboring. 15 Using Java applets or the like, a control like that described above can be authored and incorporated onto Web pages extending standardization of this interface from the user's own desktop to throughout the world wide web.
Having described the principles of our inventive work with reference to several o illustrative embodiments it should be apparent that the technology cat" be m.odif ed in arrangement and detail without departing from such principles.
For example, while the illustrated embodiment has made use of two distinct control structures to form the standard user interface (i.e. the QuickFilter header control -
which knows nothing of the data set but knows only of filters, labels, pulldown menus, etc., and the listview display control, which simply presents the data set), in alternative 5 embodiments, a unified structure can be employed.
Further, while the invention has been illustrated in the context of a graphical user interface, our inventive concepts are not so limited. For example, the foregoing principles can advantageously be employed in textbased interfaces (as are common, for example, in many mainframe systems).
10 Moreover, while the invention has been illustrated as employing a tabular detailed description of each data object in the listview control, in other embodiments a simpler
iconic view of data objects meeting the specified filter criteria can be presented.
Still further, while the detailed embodiments have employed filter fields for
each of several attributes, in other embodiments, a single filter field can be used to search
15 across several attributes. In one such embodiment, the header control has a general "Search for" field. Data entered in that field is matched against all attributes of the data objects. Any
object having a match (regardless of which attribute has the match) is presented for display.
Such a general "Search for" field can be in addition to the specific attribute fields illustrated,
or can be used to their exclusion. Similarly, single fields can be used to search across subsets
O of all the attribute fields (e.g. titlelabstract/author).
4G
In view of the wide variety of possible embodiments to which the principles of our invention can be applied, it should be recognized that the detailed embodiments are illustrative only and should not be taken as limiting the scope of our invention. Rather, via clai..
as our invention all such variations as come within the scope and spirit of the following claims, 5 and equivalents thereto.
i
p< GR(CD INS oR G love-, i. In a first computer system, a method for standardized filtering of data from an arbitrary data provider, the method comprising: receiving a first set of data from the arbitrary data provider, said first set of data 5 including a plurality of data objects and a plurality of attributes associated with the data objects; displaying the first set of data, together with a plurality of labels and a plurality of filters, wherein: each label describes an attribute of the first data set; and 0 -. each filter is associated with an attribute of the first set of data; the method further including: receiving, from a user of the computer system, filter input into one or more of the plurality of filters; sending the filter input to the arbitrary data provider; 15 receiving from the arbitrary data provider a second set of data, wherein said second set of data is derived by filtering the first data set according to the filter input; and displaying the second set of data with said plurality of labels and filters.
2. The method ore i which includes displaying said data sets, labels, and 2 o filters, in a windowed control.
3. The method of icak c2 further including: displaying a queer user interface, wherein the control is displayed within die query user interface; receiving query input from a user of the computer system, wherein the query s input is used to sort the first data set prior to the displaying of the first data set.
4. The -method oft 1 wherein the first and second data sets are row/column tables of data objects, wherein each column represents one of said attributes and each row represents a single data object.
5. The method oflce l further including: timing elapsed time since filter input was last provided to the data provider; and sending any new filter input to the data provider when said elapsed time exceeds a predefined threshold interval, or when a user explicitly initiates a sending step, whichever 15 comes first.
6. The method of - 5 further including receiving from the arbitrary data provider the predestined threshold interval, wherein the predefined threshold duration is set to balance user-respo.nsiYe.n.ess with time required for said arbitrary dart provider to bitter data.
tip
7. The method of$ah 1 in which at least one filter includes a text string, wherein the text string is displayed inside said filter, and wherein f Iter input is a change to the text string in one or more of the plurality of filters.
s 8. The method off l which includes transferring filter instructions, and providing sets of data, in accordance with a predetermined applications programming interface. 9. The method of je 8 wherein the applications programming interface lo includes functions for (a) setting a filter, (b) getting a filter, (c) showing/hiding all filters, (d) setting the parent to which notifications are sent, and (e) setting the duration of the filter timer; and includes function calls Ifor (a) telling the arbitrary data provider that a filter has been changed, (b) requesting that the arbitrary data provider return a pulldown menu, (c) telling the arbitrary data provider that an operator was chosen, and (d) telling a parent that a filter has 15 started or finished being edited.
10. The method of$ - 1 wherein the arbitrary data provider is located in the memory or storage of the first computer system.
l J: 11. The method of/ - talc 1 wherein the arbitrary data provider is located in the r.emo'> or storage of a second corr.puter system, said second corr.puter system. being in communication with the first computer system.
5 12. In a computer system, a met-hod for displaying on a display device a control used to filter data in a first data set, the method comprising: receiving from the arbitrary data provider a first data set, wherein the first data set includes a plurality of data objects and a plurality of attributes associated with the data object; 10 displaying the first data set in the control, together with a plurality of labels, a plurality of pulldown menu buttons, and a plurality of filters, wherein: each label describes an attribute of the first data set, each label is associated with a set of comparison modes, each filter is associated with an attribute of the first data set, and at least one filter receives input used to modify the first data set according to the attribute with which said filter is associated; 15 in response to the actuation of a pulldown menu button next to a label, displaying a pulldown menu whose contents are provided from the arbitrary data provider; receiving input from the user of the computer system responsive to the pulldown menu; sending said nput to the arbitrary data provider; 2 C receiving from the arbitrary data provider a second data set, wherein the second data set is derived by sorting the first data set according to the input; and
displaying the second data set.
13. The method oft: 12 wherein at least one of said pulldown menus comprises a selection of comparison modes for the attribute with which the pulldown menu is 5 associated.
* 14. The method of ( 12 wherein the contents of the pulldown menu include a custom control for the attribute with which the pulldown menu is associated.
0 15. The method of - 12 wherein the pulldown menu launches a separate wmdow. 16. The method of - 12 wherein the contents of the pulldown menu include a unique value list for the attribute with which the pulldown menu is associated.
17. A computer storage medium having instructions thereon causing a computer progranuned thereby to: issue a filtering command to a data provider in response to user input; receive responsive results from the data provider and display same; O accept user input am storing in a batch; L,LD
forward the batched user input to the data provider when a timer expires, or when the user explicitly instructs the batched input be fo-rw rded; 2nd receive modified results from the data provider and display same.
5 18. The medium off 17 in which said instructions cause the computer programmed thereby to reset the timer when the batched user input is forwarded to the data provider. 19. The storage medium offi,c 17 in which said instructions cause the 1 o computer progrmnrned thereby to reset the timer each timer user input is accepted from the user. 20. The storage medium ofpq 17 in which said instructions cause the computer programmed thereby to receive a timing parameter from the data provider, and to set 15 said timer in accordance with said parameter.
21. The storage medium ofiqbq=17 in which said command comprises executable code sent over a communications link, for receipt by a remote computer on which the data provider resides.
22. The storage medium off 17 in which said command includes an API call. 23. The storage medium off 17 in which instructions form part of a web 5 browser.
24. A computer operating system comprising computer executable instructions stored on a storage medium, said instructions providing: means to invoke a generic filtering control; and 10 means for communicating between said generic filtering control and an arbitrary data provider.
25. The operating system of; 24 in which said means include messages and calls having syntaxes beginning with QFN and QFM.
26. In a method of querying a data provider, an improvement comprising: providing a standardized user interface capable of use with a plurality of different data providers; formulating first search criteria using said user nter face; 2 0 tra =n^ innng data relating to said first search criteria to a data provider; 4?
t conducting a first search of data by the data provider in accordance with said first search criteria to generate first results, and providing the results A, said standardized user interface for display; using said user interface, formulating second search criteria, said second search 5 criteria comprising the logical ANDing of said first search criteria with additional search criteria; transmitting data relating to said second search criteria to the data provider; conducting a second search of data by the data provider in accordance with said search criteria to generate second search results, and providing the results to said standardized lo user interface for display; said data provider conducting the second search by filtering the first search results in accordance with the additional search criteria (an iterative search), or by executing a new search including both the first and additional search criteria, wherein the same user interface is used to conduct both iterative and new searches when refining a prior search, 15 depending on the data provider queried.
27. In a method of querying a data provider, an improvement comprising.
presenting a query filter interface; presenting a non-textual selector by which a non-textual aunbute may be 2 0 selected; and Act
issuing search criteria to the data provider in accordance with a nontextual attribute selected by a user through said selector; wherein said selector is provided to the query filter interface by the data provider rather than being coded into the query filter interface.
28. The method ofi L4 27 in which the presenting step includes displaying, and the non-texmal picker includes presentation of a graphical display of colors.
29. In a computer system having a user interface including a display and a user 0 interface selection device, a method of formulating a query to a data provider and for presenting results of the query, comprising the steps: (a) identifying a set of data attributes corresponding to said data provider; (b) presenting said attributes in first fields of the graphical user interface;
(c) receiving, in second fields adjacent to said first fields, data entry
15 corresponding to one or more of said attributes; (d) querying the data provider to identify data objects having attributes matching said received data; and (e) presenting results of said query in the user interface, organized so that attributes of the identified data objects are presented in association with the first f;e'ds 2 o associated therewith.
30. The method of7L 29 in which steps (a) through (d) are performed by a windowed header control, and step (eJ is provided by a separate windowed display control.
31. The method off 29 in which: 5 the first fields are arranged in a first row;
the second fields are arranged in a second row beneath the first row; and
data objects.identified:by said query are displayed in successive rows beneath the second row.
10 32. The method of - 29 in which the identifying step includes obtaining said set of data attributes from the data provider, rather than from coding integral with said graphical user interface.
33. The method offic29 which includes issuing two or more.query requests 15 to the data provider as data entry is received in a single one of said second fields, the second
of said requests being more detailed than the first.
34. A method of formulating a query to a data provider in a computerbased system' comprising Me steps: 2 o receiving first filter criteria from an interactive interface; receiving second filter criteria from said interactive interface; S.l
querying the data provider to identify data objects whose attributes match both said first and second filter criteria, wherein a!ogica! ANDin. g of said first arid second filter criteria is effected; and wherein at least the first of said filter criteria comprises a plurality of criteria 5 selected from a unique value list, said plurality of selections being logically ORed together to form said first filter criteria.
)

Claims (1)

  1. CLAIMS:
    5 1. In a computer system, a method for displaying on a display device a control window area used to filter data in a f st data set, the method comprising: receiving from an arbitrary data provider a first data set, wherein the first data set includes a plurality of data objects and a plurality of attributes associated with the data objects; 10 displaying the first data set in the control window area, together with a plurality of labels, a plurality of pulldown menu buttons, and a plurality of filters, wherein: each label describes an attribute of the first data set, each label is associated with a pulldown menu button, each filter is associated with an 15 attribute of the first data set, and at least one filter receives input used to modify the first data set according to the attribute with which said filter is associated; in response to the actuation of a pulldown menu button next to a labeled attribute, displaying a pulldown menu whose contents are provided from the arbitrary data provider, wherein the arbitrary data provider supplies one or more 20 attribute-specific filtering options, displayed in the pulldown menu, whereby the arbitrary data provider elicits from a user of the computer system input responsive to the one or more attribute-specific filtering options for the labeled attribute; receiving input from the user responsive to the pulldown menu; 25 sending said input to the arbitrary data provider; receiving from the arbitrary data provider a second data set, wherein the second data set is derived by sorting the first data set according to the input; and
    displaying the second data set.
    2. The method of claim 1 wherein at least one of said pulldown menus comprises a selection of comparison modes for the attribute with which the 5 pulldown menu is associated.
    3. The method of claim 1 wherein the contents of the pulldown menu include a custom control for the attribute with which the pulldown menu is associated. 4. The method of claim 1 wherein the pulldown menu launches a separate window. 5. The method of claim 1 wherein the contents of the pulldown menu 15 include a unique value list for the attribute with which the pulldown menu is associated. 6. In a computer system, a method for displaying on a display device a control window area used to filter data in a first data set, the method 20 comprising: receiving from an arbitrary data provider a first data set, wherein the first data set includes a plurality of data objects and a plurality of attributes associated with the data objects; displaying the first data set in the conko1 window area, together with a 25 plurality of labels, and a plurality of pulldown menu buttons wherein: each label describes an attribute of the first data set, and each label is associated with a pulldown menu button; in response to the actuation of a pulldown menu button associated with a labeled attribute, displaying a pulldown menu whose contents are provided
    from the arbitrary data provider, wherein the arbitrary data provider supplies one or more attribute-specif c filtering options displayed in the pulldown menu, whereby the arbitrary data provider elicits from a user of the computer system input responsive to the one or more attributespecific filtering options for the 5 labeled attribute; receiving input from the user responsive to the pulldown menu; sending said input to the arbitrary data provider; receiving from the arbitrary data provider a second data set, wherein the second data set is derived by sorting the first data set according to the input; 10 and displaying the second data set.
    7. The method of claim 6 wherein at least one pulldown menu comprises a selection of comparison modes for the labeled attribute.
    8. The method of claim 6 wherein the contents of the pulldown menu include a custom control for the labeled attribute.
    9. The method of claim 6 wherein the contents of the pulldown menu 20 include a unique value list for the labeled attribute.
    SS
GB0227921A 1997-09-21 1998-07-17 Displaying on a display device a control window area used to filter data Expired - Fee Related GB2380576B (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US08/938,032 US6279016B1 (en) 1997-09-21 1997-09-21 Standardized filtering control techniques
GB9815684A GB2329492B (en) 1997-09-21 1998-07-17 Standard user interface control for a data provider

Publications (3)

Publication Number Publication Date
GB0227921D0 GB0227921D0 (en) 2003-01-08
GB2380576A true GB2380576A (en) 2003-04-09
GB2380576B GB2380576B (en) 2003-12-17

Family

ID=26314067

Family Applications (5)

Application Number Title Priority Date Filing Date
GB0227922A Expired - Fee Related GB2380577B (en) 1997-09-21 1998-07-17 Presenting a custom control in a data filtering interface of a computer system
GB0227921A Expired - Fee Related GB2380576B (en) 1997-09-21 1998-07-17 Displaying on a display device a control window area used to filter data
GB0227934A Expired - Fee Related GB2380300B (en) 1997-09-21 1998-07-17 A data filtering system and method
GB0227927A Expired - Fee Related GB2380578B (en) 1997-09-21 1998-07-17 Method of filtering visually displayed data
GB0227918A Expired - Fee Related GB2380575B (en) 1997-09-21 1998-07-17 A method of querying a data provider

Family Applications Before (1)

Application Number Title Priority Date Filing Date
GB0227922A Expired - Fee Related GB2380577B (en) 1997-09-21 1998-07-17 Presenting a custom control in a data filtering interface of a computer system

Family Applications After (3)

Application Number Title Priority Date Filing Date
GB0227934A Expired - Fee Related GB2380300B (en) 1997-09-21 1998-07-17 A data filtering system and method
GB0227927A Expired - Fee Related GB2380578B (en) 1997-09-21 1998-07-17 Method of filtering visually displayed data
GB0227918A Expired - Fee Related GB2380575B (en) 1997-09-21 1998-07-17 A method of querying a data provider

Country Status (1)

Country Link
GB (5) GB2380577B (en)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
GB2355818B (en) * 1999-10-26 2004-03-03 Mitel Corp Common data model including field interdependencies
KR100636227B1 (en) * 2005-03-10 2006-10-19 삼성전자주식회사 Method for generating directory structure to search contents
US7849093B2 (en) 2005-10-14 2010-12-07 Microsoft Corporation Searches over a collection of items through classification and display of media galleries
CN105278939A (en) * 2014-07-04 2016-01-27 普天信息技术有限公司 Method and device for manufacturing control on the basis of DotNet Framework class library

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1996003691A1 (en) * 1994-07-25 1996-02-08 Taligent, Inc. Object-oriented operating system enhancement for filtering items in a window
US5636350A (en) * 1993-08-24 1997-06-03 Lucent Technologies Inc. Using symbols whose appearance varies to show characteristics of a result of a query
WO1998049637A1 (en) * 1997-05-01 1998-11-05 Northern Light Technology, Llc Method and apparatus for searching a database of records

Family Cites Families (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5206949A (en) * 1986-09-19 1993-04-27 Nancy P. Cochran Database search and record retrieval system which continuously displays category names during scrolling and selection of individually displayed search terms
US5579471A (en) * 1992-11-09 1996-11-26 International Business Machines Corporation Image query system and method
JPH0728689A (en) * 1993-07-09 1995-01-31 Hitachi Ltd Information processor
US6201539B1 (en) * 1994-01-04 2001-03-13 International Business Machines Corporation Method and system for customizing a data processing system graphical user interface
US5745754A (en) * 1995-06-07 1998-04-28 International Business Machines Corporation Sub-agent for fulfilling requests of a web browser using an intelligent agent and providing a report
AU6685596A (en) * 1995-07-31 1997-02-26 Microsoft Corporation Computer input device and method of operation
US5634053A (en) * 1995-08-29 1997-05-27 Hughes Aircraft Company Federated information management (FIM) system and method for providing data site filtering and translation for heterogeneous databases
US5933823A (en) * 1996-03-01 1999-08-03 Ricoh Company Limited Image database browsing and query using texture analysis

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5636350A (en) * 1993-08-24 1997-06-03 Lucent Technologies Inc. Using symbols whose appearance varies to show characteristics of a result of a query
WO1996003691A1 (en) * 1994-07-25 1996-02-08 Taligent, Inc. Object-oriented operating system enhancement for filtering items in a window
WO1998049637A1 (en) * 1997-05-01 1998-11-05 Northern Light Technology, Llc Method and apparatus for searching a database of records

Also Published As

Publication number Publication date
GB0227922D0 (en) 2003-01-08
GB0227918D0 (en) 2003-01-08
GB0227934D0 (en) 2003-01-08
GB2380300B (en) 2003-09-10
GB2380577B (en) 2003-12-17
GB2380577A (en) 2003-04-09
GB2380575B (en) 2003-12-17
GB2380300A (en) 2003-04-02
GB2380578B (en) 2003-12-17
GB2380575A (en) 2003-04-09
GB2380576B (en) 2003-12-17
GB0227927D0 (en) 2003-01-08
GB0227921D0 (en) 2003-01-08
GB2380578A (en) 2003-04-09

Similar Documents

Publication Publication Date Title
US6279016B1 (en) Standardized filtering control techniques
US5428735A (en) Method and apparatus for maintaining a record of set-creating data processing activities and associated data sets
EP0536077B1 (en) Method and system for enhancing interactive query of a database
US6282551B1 (en) System and methods for improved spreadsheet interface with user-familiar objects
US5883626A (en) Docking and floating menu/tool bar
US5982370A (en) Highlighting tool for search specification in a user interface of a computer system
US7503012B2 (en) Invoking user designated actions based upon selected computer content
US5583761A (en) Method for automatic displaying program presentations in different languages
US4939689A (en) Outline-driven database editing and retrieval system
US5586242A (en) Font manager with selective access of installed fonts
US7490313B2 (en) System and method for making user interface elements known to an application and user
US5787416A (en) Methods for hypertext reporting in a relational database management system
US5430839A (en) Data entry screen method
US5621880A (en) Method and apparatus for providing contextual navigation to historical data
US20040032432A1 (en) Multi-dimensional table filtering system
US9659054B2 (en) Database browsing system and method
JPH08241336A (en) Apparatus and method for retrieval
JPH1097450A (en) Computer system and method for operating computer system
US6671691B1 (en) Method and apparatus for expression building editors
US5953720A (en) Method and apparatus for a unified chooser for heterogeneous entities
GB2380576A (en) Stardard user interface control display for a data provider
JP3167412B2 (en) Database search processor
JPH08328796A (en) Graphical class tree for graphical user interface

Legal Events

Date Code Title Description
PCNP Patent ceased through non-payment of renewal fee

Effective date: 20130717

732E Amendments to the register in respect of changes of name or changes affecting rights (sect. 32/1977)

Free format text: REGISTERED BETWEEN 20150312 AND 20150318