System for providing dynamic linked panels in user interface
First Claim
Patent Images
1. A computer system comprising:
- one or more hardware computer processors configured to execute code in order to cause the system to;
generate user interface data configured to be rendered as a user interface, the user interface simultaneously including at least a first display portion and a second display portion, wherein;
the first display portion includes a plurality of panels comprising a first panel configured to generate a visual representation of data displayed in the first panel according to display settings for the first panel,the data is retrievable from a database according to a query associated the first panel,the first panel is associated with code configured to use the data to assign a value to a variable of the first panel, andthe variable of the first panel is configured for use in a query associated with a second panel of the plurality of panels, andreceive a first user input assigning the value to the variable of the first panel;
in response to receiving the first user input, generate a visual representation of second data displayed in the second panel by executing the query of the second panel using the value of the variable of the first panel to retrieve the second data from the database;
based at least in part on the query of the second panel using the variable of the first panel, determine that the second panel has a downstream dependency on the first panel;
display, in the second display portion, a graphical visualization of relationships among the plurality of panels, the graphical visualization including nodes and edges, at least some of the nodes representing respective ones of the plurality of panels, at least some of the edges representing dependency relationships among respective pairs of the plurality of panels;
receive a second user input selecting the first panel in the first display portion; and
in response to receiving the second user input, visually indicate, in the second display portion, a node associated with the first panel;
receive a selection of a filter criteria indicating downstream or neighboring dependencies, wherein the second display portion is further configured to, in response to the selection of the filter criteria;
display, in the graphical visualization, nodes satisfying the filter criteria; and
filter out from the graphical visualization a node that does not satisfy the filter criteria;
receive an edit to the query of the first panel;
execute the edited query of the first panel;
identify panels that have downstream dependencies on the first panel, wherein the panels that have downstream dependencies on the first panel include the second panel;
execute queries of the panels that have the downstream dependencies on the first panel; and
display the second display portion simultaneously with a third display portion, the third display portion including;
a comparison of first timing information associated with executing the query of the first panel before receiving the edit and updated first timing information associated with executing the edited query of the first panel; and
a comparison of second timing information associated with executing the query of the second panel before receiving the edit and updated second timing information associated with executing the query of the second panel after receiving the edit.
8 Assignments
0 Petitions
Accused Products
Abstract
A system is configured to provide a dashboard creation system. Panels associated with queries for retrieving information from a database are shown in a user interface. Various other user interfaces show query code, panel display settings, function code, dependencies, etc. The dependencies can be extracted and used to provide autocomplete and partial refreshing. A timing table shows execution times. Panel outputs and code updates can be shown and compared.
702 Citations
16 Claims
-
1. A computer system comprising:
one or more hardware computer processors configured to execute code in order to cause the system to; generate user interface data configured to be rendered as a user interface, the user interface simultaneously including at least a first display portion and a second display portion, wherein; the first display portion includes a plurality of panels comprising a first panel configured to generate a visual representation of data displayed in the first panel according to display settings for the first panel, the data is retrievable from a database according to a query associated the first panel, the first panel is associated with code configured to use the data to assign a value to a variable of the first panel, and the variable of the first panel is configured for use in a query associated with a second panel of the plurality of panels, and receive a first user input assigning the value to the variable of the first panel; in response to receiving the first user input, generate a visual representation of second data displayed in the second panel by executing the query of the second panel using the value of the variable of the first panel to retrieve the second data from the database; based at least in part on the query of the second panel using the variable of the first panel, determine that the second panel has a downstream dependency on the first panel; display, in the second display portion, a graphical visualization of relationships among the plurality of panels, the graphical visualization including nodes and edges, at least some of the nodes representing respective ones of the plurality of panels, at least some of the edges representing dependency relationships among respective pairs of the plurality of panels; receive a second user input selecting the first panel in the first display portion; and in response to receiving the second user input, visually indicate, in the second display portion, a node associated with the first panel; receive a selection of a filter criteria indicating downstream or neighboring dependencies, wherein the second display portion is further configured to, in response to the selection of the filter criteria; display, in the graphical visualization, nodes satisfying the filter criteria; and filter out from the graphical visualization a node that does not satisfy the filter criteria; receive an edit to the query of the first panel; execute the edited query of the first panel; identify panels that have downstream dependencies on the first panel, wherein the panels that have downstream dependencies on the first panel include the second panel; execute queries of the panels that have the downstream dependencies on the first panel; and display the second display portion simultaneously with a third display portion, the third display portion including; a comparison of first timing information associated with executing the query of the first panel before receiving the edit and updated first timing information associated with executing the edited query of the first panel; and a comparison of second timing information associated with executing the query of the second panel before receiving the edit and updated second timing information associated with executing the query of the second panel after receiving the edit. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)
Specification