Disabling subsets of query conditions in an abstract query environment
View Patent ↗Embodiments of the invention provide techniques for temporarily disabling conditions in abstract queries. In one embodiment, a query interface is configured to present an abstract query, and to allow a user to select conditions of the abstract query to be temporarily disabled. By executing an abstract query having disabled conditions, the user may be able to determine the effect of individual changes to the abstract query without having to re-compose the abstract query after each change. The conditions to be disabled may be selected individually, by field, or by value. Each disabled element may be displayed with a visual indicator communicating that it is disabled. The user may then select specific disabled conditions to be re-enabled.
1. A computer-implemented method, comprising:
presenting, in a query interface, an abstract query comprising a plurality of conditional expressions arranged within multiple nested logical levels separated by one or more logical operators;
receiving a selection of a first conditional expression of the plurality of conditional expressions and a command type, wherein the command type indicates one of (i) disabling each conditional expression that includes a first logical field from being evaluated during query execution and (ii) disabling each conditional expression that includes the first logical field and a value specified for the first logical field from being evaluated during query execution;
analyzing the abstract query in its entirety to identify, based on the command type and a first logical field included in the first conditional expression, a subset of one or more conditional expressions of the plurality of conditional expressions; and
presenting the abstract query in the query interface, wherein the subset of one or more conditional expressions is presented with an indication communicating that each conditional expression in the subset is disabled, such that each of the one or more disabled conditional expressions is maintained in a respective original location of the user interface;
wherein metadata defined by a data abstraction model identifies a relationship between the first logical field and a second logical field, and wherein a command to disable the first conditional expression disables at least one second conditional expression referencing the second logical field.
2. The computer-implemented method of claim 1 , further comprising:
executing the abstract query excluding the one or more disabled conditional expressions; and
returning a set of results of executing the abstract query to the query interface.
3. The computer-implemented method of claim 1 , wherein the command type indicates to disable conditions in the abstract query based on a specified user role.
4. The computer-implemented method of claim 1 , wherein the first conditional expression and the at least one second conditional expression each map to a common underlying physical database structure when the abstract query is executed.
5. A non-transitory computer-readable medium containing a program, which when executed, performs an operation for selectively disabling query conditions in an abstract query, the operation comprising:
presenting, in a query interface, an abstract query comprising a plurality of conditional expressions arranged within multiple nested logical levels separated by one or more logical operators;
receiving a selection of a first conditional expression of the plurality of conditional expressions and a command type, wherein the command type indicates one of (i) disabling each conditional expression that includes a first logical field from being evaluated during query execution and (ii) disabling each conditional expression that includes the first logical field and a value specified for the first logical field from being evaluated during query execution;
analyzing the abstract query in its entirety to identify, based on the command type and a first logical field included in the first conditional expression, a subset of one or more conditional expressions of the plurality of conditional expressions; and
presenting the abstract query in the query interface, wherein the subset of one or more conditional expressions is presented with an indication communicating that each conditional expression in the subset is disabled, such that each of the one or more disabled conditional expressions is maintained in a respective original location of the user interface;
wherein metadata defined by a data abstraction model identifies a relationship between the first logical field and a second logical field, and wherein a command to disable the first conditional expression disables at least one second conditional expression referencing the second logical field.
6. The non-transitory computer-readable medium of claim 5 , wherein the operation further comprises:
executing the abstract query excluding the one or more disabled conditional expressions; and
returning a set of results of executing the abstract query to the query interface.
7. The non-transitory computer-readable medium of claim 5 , wherein the command type indicates to disable conditions in the abstract query based on a specified user role.
8. The non-transitory computer-readable medium of claim 5 , wherein the first conditional expression and the at least one second conditional expression each map to a common underlying physical database structure when the abstract query is executed.
9. A system comprising:
a processor; and
a memory containing a program, which, when executed on the processor, performs an operation for selectively disabling query conditions in an abstract query, the operation comprising:
presenting, in a query interface, an abstract query comprising a plurality of conditional expressions arranged within multiple nested logical levels separated by one or more logical operators;
receiving a selection of a first conditional expression of the plurality of conditional expressions and a command type, wherein the command type indicates one of (i) disabling each conditional expression that includes a first logical field from being evaluated during query execution and (ii) disabling each conditional expression that includes the first logical field and a value specified for the first logical field from being evaluated during query execution;
analyzing the abstract query in its entirety to identify, based on the command type and a first logical field included in the first conditional expression, a subset of one or more conditional expressions of the plurality of conditional expressions; and
presenting the abstract query in the query interface, wherein the subset of one or more conditional expressions is presented with an indication communicating that each conditional expression in the subset is disabled, such that each of the one or more disabled conditional expressions is maintained in a respective original location of the user interface;
wherein metadata defined by a data abstraction model identifies a relationship between the first logical field and a second logical field, and wherein a command to disable the first conditional expression disables at least one second conditional expression referencing the second logical field.
10. The system of claim 9 , wherein the operation further comprises:
executing the abstract query excluding the one or more disabled conditional expressions; and
returning a set of results of executing the abstract query to the query interface.
11. The system of claim 9 , wherein the command type indicates to disable conditions in the abstract query based on a specified user role.
12. The system of claim 9 , wherein the first conditional expression and the at least one second conditional expression each map to a common underlying physical database structure when the abstract query is executed.