Criteria builder for query builder
AssigneeOracle International Corporation
InventorsAriel Gregorio Ceballos, Michael Anthony Caruso, Kenneth Klaus
Life of this patent
Estimating the term…
Abstract
Systems and methods are provided that programmatically provide a user interface for forming a query, comprising. A query builder displays a first row of query criteria, a second row of query criteria, the second row being logically connected to the first row by a first Boolean connector, and a third row of query criteria, the third row being logically connected to the second row by a second Boolean connector. In response to a user drag-and-drop operation, the query builder nests the third row of query criteria in the second row of query criteria. Thus, a drag-and-drop operation obviates the need for cumbersome groups of parentheses when defining the order of operation of the query.
Claims15
A method for programmatically providing a user interface for forming a query, comprising:
- displaying a first row of query criteria;
- displaying a second row of query criteria, the second row being logically connected to the first row by a first Boolean connector;
- displaying a third row of query criteria, the third row being logically connected to the second row by a second Boolean connector;
- in response to a user drag-and-drop operation, nesting the third row of query criteria in the second row of query criteria;
- and
- executing a query comprising the first row, the first Boolean connector, and the nested second row and third row including the second Boolean connector.
A computer-readable medium having instructions stored thereon that, when executed by a processor, cause the processor to programmatically provide a user interface for forming a query by:
- displaying a first row of query criteria;
- displaying a second row of query criteria, the second row being logically connected to the first row by a first Boolean connector;
- displaying a third row of query criteria, the third row being logically connected to the second row by a second Boolean connector;
- in response to a user drag-and-drop operation, nesting the third row of query criteria in the second row of query criteria;
- and
- executing a query comprising the first row, the first Boolean connector, and the nested second row and third row including the second Boolean connector.
A system, comprising:
- a memory containing at least one application;
- a processor communicably connected to the memory and which, when executing the application, performs an operation of generating a graphical user interface for forming queries, the operation comprising:
- displaying a first row of query criteria;
- displaying a second row of query criteria, the second row being logically connected to the first row by a first Boolean connector;
- displaying a third row of query criteria, the third row being logically connected to the second row by a second Boolean connector;
- in response to a user drag-and-drop operation, changing the order of operation of the query criteria by moving one of the first, second, and third rows;
- and
- executing a query comprising query criteria from the first, second, and third rows.
A system providing a user interface for forming a query, comprising:
- means for displaying a first row of query criteria;
- means for displaying a second row of query criteria, the second row being logically connected to the first row by a first Boolean connector;
- means for displaying a third row of query criteria, the third row being logically connected to the second row by a second Boolean connector;
- means for nesting the third row of query criteria in the second row of query criteria in response to a user drag-and-drop operation;
- and
- means for executing a query comprising the first row, the first Boolean connector, and the nested second row and third row including the second Boolean connector,
Dependencies are inferred from the claim text.