Computing systems and networks have transformed the way we work, play, communicate. Information can now be accessed from remote locations, often at the click of a button. Data stores are often now quite larger, and may be queried for desired information. For instance, a user interface control may generate a query, issue the query to the data store, receive results from the data store, and display some or all of the results in a corresponding user interface control. Nevertheless, conventional queries can require some knowledge to build, and often such knowledge is not possessed by the typical user of the computing system. Furthermore, even for those familiar with a query language, generating queries may be quite time consuming and mentally taxing.
At least some embodiments described herein relate to a query building mechanism in which a query builder component assists a user in generating queries to be used to populate user interface elements. A user interface control itself issues the query with appropriate query parameters and populates the corresponding user interface element with the appropriate query results. However, the query builder component helps select the appropriate query parameters for the user interface control.
The user interface control provides a query schema to the query builder component. For instance, this might be performed at the request of a user that is viewing a user interface element populated by the user interface control. The query schema identifies available query parameters that the user interface control is capable of using to populate a corresponding user interface element. The query builder component presents at least some of the available query parameters to the user, such that the user may edit these parameters. As examples, the query parameters may include query fields, and query rules. The query builder component gathers those edits and generates a query therefrom.
In some embodiments, the query schemas are provided to the query builder component in consistent manner across a wide variety of possible user interface controls. Furthermore, the resulting query is provided in a uniform query format. Accordingly, the query builder component may be used for any user interface control, regardless of whether that user interface control is provided by a system, or by an application that runs in the system. Additionally, the user interface elements may be presented from a single class. Accordingly, the user interface element may appear consistent regardless of the identity of the user interface control, with customization occurring in the query parameters themselves.
In some embodiments, the user might be presented with presentation options for presenting the user interface element, but the presentation options may also be limited to options that would allow the user interface to retain a certain look and feel. Accordingly, the principles described herein may permit convenient generation of queries, and repopulation of user interface elements with different data, regardless of there being many different sources for the user interface controls.
This summary is provided to introduce a selection of concepts in a simplified form that are further described below in the Detailed Description. This Summary is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used as an aid in determining the scope of the claimed subject matter.
In order to describe the manner in which the above-recited and other advantages and features of the invention can be obtained, a more particular description of the invention briefly described above will be rendered by reference to specific embodiments thereof which are illustrated in the appended drawings. Understanding that these drawings depict only typical embodiments of the invention and are not therefore to be considered to be limiting of its scope, the invention will be described and explained with additional specificity and detail through the use of the accompanying drawings in which:
At least some embodiments described herein relate to a query building mechanism in which a query builder component assists a user in generating queries to be used to populate user interface elements. A user interface control itself issues the query with appropriate query parameters and populates the corresponding user interface element with the appropriate query results. However, the query builder component helps select the appropriate query parameters for the user interface control.
The user interface control provides a query schema to the query builder component. For instance, this might be performed at the request of a user that is viewing a user interface element populated by the user interface control. The query schema identifies available query parameters that the user interface control is capable of using to populate a corresponding user interface element. The query builder component presents at least some of the available query parameters to the user, such that the user may edit these parameters. As examples, the query parameters may include query fields, and query rules. The query builder component gathers those edits and generates a query therefrom.
In some embodiments, the query schemas are provided to the query builder component in consistent manner across a wide variety of possible user interface controls. Furthermore, the resulting query is provided in a uniform query format. Accordingly, the query builder component may be used for any user interface control, regardless of whether that user interface control is provided by a system, or by an application that runs in the system—so long as the user interface control communicates the schema in the right manner, and is able to interpret the unified query format. Additionally, the user interface elements may be presented from a single class. Accordingly, the user interface element may appear consistent regardless of the identity of the user interface control, with customization occurring in the query parameters themselves.
In some embodiments, the user might be presented with presentation options for presenting the user interface element, but the presentation options may also be limited to options that would allow the user interface to retain a certain look and feel. Accordingly, the principles described herein may permit convenient generation of queries, and repopulation of user interface elements with different data, regardless of there being many different sources for the user interface controls.
Thus, the principles described herein may enable a distributed and composite application in which the user may control information that they see, and otherwise customize the user interface to fit their needs. For instance, for data sets that are projected through different visual experiences (like grids, charts, summaries, and so forth), the user can change the parameters that result in getting that data from the data source. Users do this through a user experience that is standardized over a system.
The principles described herein may be implemented using a computing system. For instance, the users may be engaging with a portal that displayed multiple user interface elements using a client computing system. The executable logic supporting the portal and providing visualizations thereon may also be performed using a computing system. The computing system may even be distributed. Accordingly, a brief description of a computing system will now be provided.
Computing systems are now increasingly taking a wide variety of forms. Computing systems may, for example, be handheld devices, appliances, laptop computers, desktop computers, mainframes, distributed computing systems, or even devices that have not conventionally been considered a computing system. In this description and in the claims, the term “computing system” is defined broadly as including any device or system (or combination thereof) that includes at least one physical and tangible processor, and a physical and tangible memory capable of having thereon computer-executable instructions that may be executed by the processor. The memory may take any form and may depend on the nature and form of the computing system. A computing system may be distributed over a network environment and may include multiple constituent computing systems.
As illustrated in
In the description that follows, embodiments are described with reference to acts that are performed by one or more computing systems. If such acts are implemented in software, one or more processors of the associated computing system that performs the act direct the operation of the computing system in response to having executed computer-executable instructions. For example, such computer-executable instructions may be embodied on one or more computer-readable media that form a computer program product. An example of such an operation involves the manipulation of data. The computer-executable instructions (and the manipulated data) may be stored in the memory 104 of the computing system 100. Computing system 100 may also contain communication channels 108 that allow the computing system 100 to communicate with other message processors over, for example, network 110.
The computing system 100 also includes a display 112 on which a user interface, such as the user interfaces and portal described herein, may be rendered. Such user interfaces may be generated in computer hardware or other computer-represented form prior to rendering. The presentation and/or rendering of such user interfaces may be performed by the computing system 100 by having the processing unit(s) 102 execute one or more computer-executable instructions that are embodied on one or more computer-readable media. Such computer-readable media may form all or a part of a computer program product.
Embodiments described herein may comprise or utilize a special purpose or general-purpose computer including computer hardware, such as, for example, one or more processors and system memory, as discussed in greater detail below. Embodiments described herein also include physical and other computer-readable media for carrying or storing computer-executable instructions and/or data structures. Such computer-readable media can be any available media that can be accessed by a general purpose or special purpose computer system. Computer-readable media that store computer-executable instructions are physical storage media. Computer-readable media that carry computer-executable instructions are transmission media. Thus, by way of example, and not limitation, embodiments of the invention can comprise at least two distinctly different kinds of computer-readable media: computer storage media and transmission media.
Computer storage media includes RAM, ROM, EEPROM, CD-ROM or other optical disk storage, magnetic disk storage or other magnetic storage devices, or any other tangible medium which can be used to store desired program code means in the form of computer-executable instructions or data structures and which can be accessed by a general purpose or special purpose computer.
A “network” is defined as one or more data links that enable the transport of electronic data between computer systems and/or modules and/or other electronic devices. When information is transferred or provided over a network or another communications connection (either hardwired, wireless, or a combination of hardwired or wireless) to a computer, the computer properly views the connection as a transmission medium. Transmissions media can include a network and/or data links which can be used to carry or desired program code means in the form of computer-executable instructions or data structures and which can be accessed by a general purpose or special purpose computer. Combinations of the above should also be included within the scope of computer-readable media.
Further, upon reaching various computer system components, program code means in the form of computer-executable instructions or data structures can be transferred automatically from transmission media to computer storage media (or vice versa). For example, computer-executable instructions or data structures received over a network or data link can be buffered in RAM within a network interface module (e.g., a “NIC”), and then eventually transferred to computer system RAM and/or to less volatile computer storage media at a computer system. Thus, it should be understood that computer storage media can be included in computer system components that also (or even primarily) utilize transmission media.
Computer-executable instructions comprise, for example, instructions and data which, when executed at a processor, cause a general purpose computer, special purpose computer, or special purpose processing device to perform a certain function or group of functions. The computer executable instructions may be, for example, binaries, intermediate format instructions such as assembly language, or even source code. Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the described features or acts described above. Rather, the described features and acts are disclosed as example forms of implementing the claims.
Those skilled in the art will appreciate that the invention may be practiced in network computing environments with many types of computer system configurations, including, personal computers, desktop computers, laptop computers, message processors, hand-held devices, multi-processor systems, microprocessor-based or programmable consumer electronics, network PCs, minicomputers, mainframe computers, mobile telephones, PDAs, pagers, routers, switches, and the like. The invention may also be practiced in distributed system environments where local and remote computer systems, which are linked (either by hardwired data links, wireless data links, or by a combination of hardwired and wireless data links) through a network, both perform tasks. In a distributed system environment, program modules may be located in both local and remote memory storage devices.
The system offers a user interface (or a “portal”) that displays multiple user interface elements that may also be called herein “parts”. The part acts as a container for the results of execution of one or more underlying user interface controls (also called herein simply “controls”). The manner of display of the part may be customized, as may be the ordering and composition of the part with respect to other user interface elements.
The execution of the controls often involves one or more underlying queries to retrieve information that is displayed in the part, or otherwise processed. In accordance with the principles described herein, the user may modify the underlying query that retrieves the information. This allows the users to further control the user experience in fundamental ways, such as defining the actual data that is being displayed. In accordance with the principles described herein, this capability is offered in a consistent way, which honors the constraints of the portal to provide a portal in which many contributors may offer parts without sacrificing a consistent look and feel of the portal. Accordingly, the query customizations described herein may be applied to any part, regardless of the contributor of the part.
The principles described herein allow the user to filter different sets of displayed data, and do further queries on their data sources. Even though the data sources are different depending on the part, the representation of the query may share a common visual representation. For instance the common visual representation may be a set of conditions connected by logical connectors and, eventually, groupings.
The query building capability includes a query builder user interface element that is displayed to a user and represents a user interface for authoring queries over data sources. The query building capability also includes a query building component that receives query schemas from the user interface control, manifests at least some of the query schemas via the query builder user interface element, and then builds a formal representation of a query based on user edits conducted through user interaction with the query builder user interface element.
A query builder component 220 exposes an input interface whereby the user interface control 210 may provide a query schema 201 to the query builder component (reference arrow 211). The query schema 201 identifies available parameters for composing queries that the corresponding user interface control 210 is capable of using to populate the corresponding user interface element 240. The query builder component 220 then proceeds to build a query corresponding to the schema. Although only one user interface control 210 is illustrated in
The query builder component 220 builds queries by generating a query builder user interface 230 (reference arrow 212). The query builder user interface 230 is built from a particular query builder user interface class and thus there is some similarity in appearance each time the query builder component 230 generates a query builder using interface. However, the query builder user interface 230 may be customized to the corresponding user interface control 210 by presenting at least some of the available query parameters to the user. In the case of query builder user interface 230, a name field, an age field, and a newness status field are presented to the user. At this point, the user may interact with the query builder user interface 230 to edit the query parameters.
At some point, the query builder component 220 determines that a query is to be built based on the edited data in the query builder user interface 230 (reference arrow 213). The query builder component 220 then generates a query using the then current values of the available query parameters. The query is generated in a pre-existing format recognized by the user interface control 210. For instance, in
For instance, in this case, the query builder user interface 330 shows date range fields, an “assigned to” field, a state field, and tags fields. Those fields may be defined by the query schema provided by the user interface control 310. Likewise, those queries are grouped in a certain way using logical operators. Such groupings may also be defined by the query schema provided by the user interface control 310. Thus, the schema defines available fields and rules for composing a query, and the query building user interface presents at least some of those fields and rules to a user for editing.
A visual query created by a user results in an abstract query representation based on a portal-defined Abstract Syntax Tree (AST). This Abstract Syntax Tree is created by the query builder component 320, and represents the predicates of the query. The query is then passed to the user interface control 310 (i.e., the data layer or the owner of the data). The AST format may be uniform across the system so that all data sources and schemas will project the same user experience (e.g., display the same query builder control albeit driven by different data and schemas) and the same predicated definition (e.g., via the AST).
The user interface control (or some other portion of the data layer) receives the AST and translates to their query format of choice. For instance, intrinsic parts may be offered by the system itself and have a standard component for execution abstract representations of a predicate in a certain format (e.g., OData). On the other hand, an application provider may have provided a set of parts for execution within the system. The application provider also includes a component for executing abstract representations of a predicate, but perhaps in a different format than the system. The data layer may thus translate the query format to an abstract representation of choice. The results are returned to the user interface element (or part) that projects the resulting data set on the screen.
There is a high level of independence between each of the three layers illustrated in
Once the general tree representation is established, the available components (or fields) of the query are metadata-driven. By doing this, different configurations of predicates can be produced using the same stack (e.g. queries for bugs, web sites, team members, etc.).
The query builder component is data-driven and results in a consistent experience regardless of which entity generated the part. Any application can provide a schema associated with any of their parts and as a result of getting a query builder component, the application will get an updated query based on user input.
In some embodiments, the query building may not be made available to all parts. To be queriable, a part implements a certain contract that indicates that it can be queried. The contract exposes a query schema (that governs the user experience of the query builder) and receives back an AST with the query entered by the user. For instance,
Query building is a data-driven task where the user experience is controlled by the query builder component. Users provide their schema and query instance, and in return receive an updated query (described using a common predicate structure).
As mentioned above, the AST that represents the query is a uniform abstraction in the system. Once an application (often referred to as an “extension” herein) receives a query, it is the applications responsibility to get the AST (the query representation) and transform it to a query to their underlying data repository. By default the system provides some converters to popular formats, but applications parse the AST and issue the query to the backend. The query builder itself does not run the query.
For instance, referring to
The query schema identifies the fields (which includes name, type, operations, and so forth) available to construct the query. These query parameters are passed as input to the query builder component, which then drives the query builder user interface. The query instance is the actual query entered by the user. This parameter is passed as input to the query builder component to show the current query and, the query is passed back to the user interface element once the query is modified by the user.
The query builder user interface can be initiated by a gesture.
Building queries is a complex task and building them from scratch may not be an option for all users and all scenarios. Accordingly, in some embodiments, the queries generated by the query builder component can have two modes; namely, locked and unlocked.
In locked mode, the fields displayed in the query builder are the same. The user can enter the values for the fields but cannot alter the composition of the query.
In unlocked mode, the user can compose queries as desired. Users can add, remove, change filters, group filters, change operators, change logical connectors, and so forth.
The query builder control is not limited to altering data, but can also help to drive how the data is presented.
The implementation is similar to the query building already described. The query builder control receives a schema with all the available presentation options. To preserve a consistent look and feel of the portion, the presentation options provided by the schema may be constrained to what is supported by the system. After the user inputs their desired selection, the selection is returned back to the originating part to be applied. The query builder control does not have any control over how data is presented in the actual part, but just presents available options and collects preferences from the user.
Queries created with the query builder control can be saved and associated with the originator. By doing this, a user can have multiple data or presentation views that can be associated to a given part.
Accordingly, the principles described herein provide a convenient manner for allowing users to control what data is being presented in a user interface element. Furthermore, such query building may be performed in a consistent manner regardless of whether the user interface element is an intrinsic or extrinsic user interface element. Furthermore, since any user interface element that is queriable may user the query building component, so long as the user interface element abides by the contract with the query builder component, this query building may be enabled in a composable system in which there are many contributors of user interface elements.
The present invention may be embodied in other specific forms without departing from its spirit or essential characteristics. The described embodiments are to be considered in all respects only as illustrative and not restrictive. The scope of the invention is, therefore, indicated by the appended claims rather than by the foregoing description. All changes which come within the meaning and range of equivalency of the claims are to be embraced within their scope.
This application claims the benefit of each of the following provisional patent applications, and each of the following provisional patent applications are incorporated herein by reference in their entirety: 1. U.S. Provisional Application Ser. No. 61/905,116, filed Nov. 15, 2013;2. U.S. Provisional Application Ser. No. 61/884,743, filed Sep. 30, 2013;3. U.S. Provisional Application Ser. No. 61/905,111, filed Nov. 15, 2013;4. U.S. Provisional Application Ser. No. 61/905,243, filed Nov. 17, 2013;5. U.S. Provisional Application Ser. No. 61/905,114, filed Nov. 15, 2013;6. U.S. Provisional Application Ser. No. 61/905,129, filed Nov. 15, 2013;7. U.S. Provisional Application Ser. No. 61/905,105, filed Nov. 15, 2013;8. U.S. Provisional Application Ser. No. 61/905,247, filed Nov. 17, 2013;9. U.S. Provisional Application Ser. No. 61/905,101, filed Nov. 15, 2013;10. U.S. Provisional Application Ser. No. 61/905,128, filed Nov. 15, 2013; and11. U.S. Provisional Application Ser. No. 61/905,119, filed Nov. 15, 2013.
Number | Date | Country | |
---|---|---|---|
61905128 | Nov 2013 | US | |
61884743 | Sep 2013 | US | |
61905111 | Nov 2013 | US | |
61905243 | Nov 2013 | US | |
61905114 | Nov 2013 | US | |
61905116 | Nov 2013 | US | |
61905129 | Nov 2013 | US | |
61905105 | Nov 2013 | US | |
61905247 | Nov 2013 | US | |
61905101 | Nov 2013 | US | |
61905119 | Nov 2013 | US |