System for providing dynamic linked panels in user interface
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.
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 to cause the computer system to:
provide a first user interface configured to display a first panel associated with a first query and a second panel associated with a variable, wherein the variable is also associated with the first query, and wherein the first query comprises at least a first section of code written in a template syntax and a second section of code written in a programming language;
receive a first user interaction with the second panel;
update a value of the variable associated with both the second panel and the first query, based at least in part on the first user interaction;
execute the first query associated with the first panel to cause first data to be retrieved from the one or more data sources;
update the first panel in the first user interface to include at least a portion of the first data retrieved from the one or more data sources; and
in response to a second user interaction with at least one of the first panel or the second panel, execute a second query comprising a third section of code written in the programming language and a fourth section of code written in the template syntax, wherein the third section of code includes an instruction to write new information to the one or more data sources, and wherein the fourth section of code comprises a function call on a parameter referencing the new information.
2. The computer system of claim 1 , wherein the template syntax comprises at least one of: Handlebars, Mustache, or a semantic template language.
3. The computer system of claim 1 , wherein the one or more hardware computer processors are further configured to execute code to cause the computer system to:
write the new information to the one or more data sources.
4. The computer system of claim 3 , wherein the one or more hardware computer processors are further configured to execute code to cause the computer system to:
process the parameter according to the function call before executing the third section of code.
5. The computer system of claim 4 , wherein processing the parameter according to the function call comprises:
storing the new information in an array; and
replacing a coding of the third section of code with different code.
6. The computer system of claim 5 , wherein processing the parameter according to the function call further comprises:
preserving a type of the new information.
7. The computer system of claim 4 , wherein processing the parameter according to the function call further comprises:
changing the parameter to have a string format.
8. The computer system of claim 3 , wherein Java DataBase Connectivity (JDBC) code is used to write the new information to the one or more data sources.
9. The computer system of claim 1 , wherein the function call is written in the template syntax.
10. The computer system of claim 1 , wherein:
the first panel is referenced as a template that is rendered by a template engine, and
the function call is registered with the template engine.
11. The computer system of claim 1 , wherein the one or more hardware computer processors are further configured to execute code to cause the computer system to:
prior to executing the first query associated with the first panel, invoke one or more functions to determine whether a table, row, or a column referenced in the first query exists in the one or more data sources.
12. The computer system of claim 1 , wherein the one or more hardware computer processors are further configured to execute code to cause the computer system to:
generate the first user interface according to a style defined in a cascading style sheet,
wherein the first user interface is configured to display the first panel according to first display settings associated with the first panel, the first display settings configured to format the first data as part of at least one of: a chart, a control, a map, a table, or a text box.
13. The computer system of claim 1 , wherein the programming language comprises Structured Query Language (SQL) or JavaScript Object Notation (JSON).
14. The computer system of claim 1 , wherein the one or more hardware computer processors are further configured to execute code to cause the computer system to:
display the second panel in the first user interface according to display settings associated with the second panel.
15. The computer system of claim 14 , wherein the variable is included in the first section of code in first query.
16. The computer system of claim 14 , wherein execution of the first query is altered based on the update to the value of the variable associated with both the second panel and the first query.