US 12,265,527 B2
Nested query modification tool
Prashant Singh, Lexington, MA (US); Rasika Vaidya Kaura, Dublin, CA (US); and Henrik Michael Ammer, Auburn, WA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Mar. 15, 2024, as Appl. No. 18/606,905.
Application 18/606,905 is a continuation of application No. 18/326,795, filed on May 31, 2023.
Application 18/326,795 is a continuation of application No. 17/958,073, filed on Sep. 30, 2022, granted, now 11,714,806, issued on Aug. 1, 2023.
Application 17/958,073 is a continuation of application No. 17/449,201, filed on Sep. 28, 2021, granted, now 11,494,373, issued on Nov. 8, 2022.
Claims priority of provisional application 63/200,474, filed on Mar. 9, 2021.
Claims priority of provisional application 63/155,817, filed on Mar. 3, 2021.
Claims priority of provisional application 63/148,864, filed on Feb. 12, 2021.
Claims priority of provisional application 63/147,564, filed on Feb. 9, 2021.
Prior Publication US 2024/0220487 A1, Jul. 4, 2024
Int. Cl. G06F 16/242 (2019.01); G06F 3/0482 (2013.01); G06F 3/0486 (2013.01); G06F 16/2453 (2019.01); G06F 16/2458 (2019.01); G06F 16/248 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/2428 (2019.01) [G06F 3/0482 (2013.01); G06F 3/0486 (2013.01); G06F 16/24535 (2019.01); G06F 16/2458 (2019.01); G06F 16/248 (2019.01); G06F 16/258 (2019.01); G06F 2203/04803 (2013.01)] 20 Claims
OG exemplary drawing
 
1. One or more non-transitory machine-readable media storing instructions which, when executed by one or more processors, cause performance of operations comprising:
displaying, in a first region of a graphical user interface (GUI), a plurality of visual representations corresponding respectively to a plurality of nested queries, the plurality of visual representations comprising:
a first visual representation representing a first query of the plurality of nested queries; and
a second visual representation representing a second query of the plurality of nested queries, wherein the second query is a child query of the first query;
wherein the second visual representation is displayed relative to the first visual representation to depict the second query being the child query of the first query;
receiving a first input associated with a selected query, wherein the selected query is one of the first query and the second query;
responsive to receiving the first input:
displaying, in a second region of the GUI and concurrently with displaying the first visual representation and the second visual representation in the first region of the GUI, a plurality of rows representing a respective plurality of query conditions for a rule for filtering records retrieved by executing the selected query; and
displaying, in the second region of the GUI and concurrently with displaying the first visual representation and the second visual representation in the first region of the GUI, a query condition-modification field;
responsive to detecting (a) a second input in the query condition-modification field to modify the plurality of query conditions, and (b) a third input including a first value:
concurrently modifying the plurality of query conditions to include the first value as at least one of:
an object name for an object from which to retrieve the records based on executing the selected query;
an attribute name for an attribute of the object;
a criterion to be applied to the attribute; and
a particular value associated with the criterion to filter a set of records corresponding to the selected query based on the criterion.