System for providing dynamic linked panels in user interface
First Claim
1. A computer system configured to display data from one or more data sources, the computer system comprising:
- one or more hardware computer processors configured to execute code in order to cause the system to;
generate a first user interface configured to display a plurality of panels including a first panel and a second panel, wherein the first panel has a first display setting and is also programmed with a first query for accessing the one or more data sources, and wherein the second panel has a second display setting and is also programmed with a second query for accessing the one or more data sources;
generate a second user interface configured to display at least one of;
a listing of variables including a first variable associated with the first panel, ora coding of the second query that comprises a first section of code that comprises the identifier of the first variable, wherein the second query is written in a first programming language and the first section of code is written in a template syntax;
in response to a first user input received via the first user interface;
execute a first query associated with the first panel to retrieve first data from the one or more databases, the execution of the first query also causing the first variable associated with the first panel to be defined with a first value;
display the first panel in the first user interface based on the first display settings of the first panel, the first panel displaying at least a portion of the first data retrieved by the first query;
execute a second query associated with the second panel to retrieve second data from the one or more databases, wherein the second data is retrieved, based at least in part, on the first value of the first variable associated with the first query of the first panel; and
display the second panel in the first user interface based on the second display settings, the second panel displaying at least a portion of the second data retrieved by the second query;
in response to a second user input received via the first user interface and changing the first variable associated with the first panel to be defined with a second value;
re-execute the second query associated with the second panel to retrieve third data from the one or more databases, wherein the third data is retrieved, based at least in part, on the second value of the first variable associated with the first query of the first panel; and
update the display of the second panel in the first user interface based on the third data retrieved by the re-executed second query of the second panel;
display code of a third query that is associated with any panel, the third query being written in the first programming language, the third query comprising;
an instruction to write new information to the one or more databases, wherein the new information includes a second variable; and
a second section of code written in the template syntax, the second section of code comprising a function call on a parameter, the parameter being the second variable; and
in response to a third user input received via the second user interface, the third user input providing a value for the second variable;
cause the function call to pre-process the second section of code;
cause the value of the second variable to be stored in an array;
cause the second section of code written in the template syntax to be replaced with a placeholder; and
cause execution of the third query in the first programming language to write the new information to the one or more data sources.
8 Assignments
0 Petitions
Accused Products
Abstract
A computer system may be configured to: execute a first query associated with a first panel; display the first panel in a user interface based on first display settings of the first panel, the first panel displaying at least a portion of the result of the first query, the result of the first query associated with a variable; execute a second query associated with a second panel, wherein the second query refers to the variable associated with the first query; display the second panel in the user interface based on second display settings of the second panel, the second panel displaying at least a portion of the result of the second query; and in response to user input changing the displayed result in the first panel: re-execute the second query; and update the display of the second panel in the user interface based on results of the re-executed second query.
739 Citations
10 Claims
-
1. A computer system configured to display data from one or more data sources, the computer system comprising:
one or more hardware computer processors configured to execute code in order to cause the system to; generate a first user interface configured to display a plurality of panels including a first panel and a second panel, wherein the first panel has a first display setting and is also programmed with a first query for accessing the one or more data sources, and wherein the second panel has a second display setting and is also programmed with a second query for accessing the one or more data sources; generate a second user interface configured to display at least one of; a listing of variables including a first variable associated with the first panel, or a coding of the second query that comprises a first section of code that comprises the identifier of the first variable, wherein the second query is written in a first programming language and the first section of code is written in a template syntax; in response to a first user input received via the first user interface; execute a first query associated with the first panel to retrieve first data from the one or more databases, the execution of the first query also causing the first variable associated with the first panel to be defined with a first value; display the first panel in the first user interface based on the first display settings of the first panel, the first panel displaying at least a portion of the first data retrieved by the first query; execute a second query associated with the second panel to retrieve second data from the one or more databases, wherein the second data is retrieved, based at least in part, on the first value of the first variable associated with the first query of the first panel; and display the second panel in the first user interface based on the second display settings, the second panel displaying at least a portion of the second data retrieved by the second query; in response to a second user input received via the first user interface and changing the first variable associated with the first panel to be defined with a second value; re-execute the second query associated with the second panel to retrieve third data from the one or more databases, wherein the third data is retrieved, based at least in part, on the second value of the first variable associated with the first query of the first panel; and update the display of the second panel in the first user interface based on the third data retrieved by the re-executed second query of the second panel; display code of a third query that is associated with any panel, the third query being written in the first programming language, the third query comprising; an instruction to write new information to the one or more databases, wherein the new information includes a second variable; and a second section of code written in the template syntax, the second section of code comprising a function call on a parameter, the parameter being the second variable; and in response to a third user input received via the second user interface, the third user input providing a value for the second variable; cause the function call to pre-process the second section of code; cause the value of the second variable to be stored in an array; cause the second section of code written in the template syntax to be replaced with a placeholder; and cause execution of the third query in the first programming language to write the new information to the one or more data sources. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
Specification