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 comprising:
one or more hardware computer processors configured to execute instructions to cause the computer system to:
provide a first user interface configured to display a first panel associated with a query, wherein the query comprises a first section of code written in a first programming language and a second section of code written in a template syntax, and wherein the second section of code comprises a function call;
receive a first user interaction with the first panel initiating execution of the query; and
in response to receiving the first user interaction:
process a parameter of the query according to the function call to change the second section of code, wherein changing the second section of code includes replacing the parameter of the query with a placeholder; and
execute the query, including the changed second section of code, to write data to, or update data in, a data source based at least in part on the first user interaction.
2. The computer system of claim 1 , wherein processing the parameter according to the function call further comprises:
storing a value corresponding to the replaced parameter in an array.
3. The computer system of claim 2 , wherein processing the parameter according to the function call further comprises:
replacing a coding of the second section of code with different code.
4. The computer system of claim 3 , wherein processing the parameter according to the function call further comprises:
preserving a type of data.
5. The computer system of claim 1 , wherein processing the parameter according to the function call comprises:
changing a value of the parameter of the query to a string format.
6. The computer system of claim 1 , wherein the template syntax comprises at least one of: Handlebars, Mustache, or a semantic template language.
7. 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.
8. The computer system of claim 1 , wherein the one or more hardware computer processors are configured to execute instructions to further cause the computer system to:
provide a second user interface configured to display and enable editing of a coding of the query that comprises the first and second sections of code.
9. A computer-implemented method comprising:
by one or more hardware computer processors executing instructions:
providing a first user interface configured to display a first panel associated with a query, wherein the query comprises a first section of code written in a first programming language and a second section of code written in a template syntax, and wherein the second section of code comprises a function call;
receiving a first user interaction with the first panel initiating execution of the query; and
in response to receiving the first user interaction:
processing a parameter of the query according to the function call to change the second section of code, wherein changing the second section of code includes replacing the parameter of the query with a placeholder; and
executing the query, including the changed second section of code, to write data to, or update data in, a data source based at least in part on the first user interaction.
10. The computer-implemented method of claim 9 , wherein processing the parameter according to the function call further comprises:
storing a value corresponding to the replaced parameter in an array.
11. The computer-implemented method of claim 10 , wherein processing the parameter according to the function call further comprises:
replacing a coding of the second section of code with different code.
12. The computer-implemented method of claim 11 , wherein processing the parameter according to the function call further comprises:
preserving a type of data.
13. The computer-implemented method of claim 9 , wherein processing the parameter according to the function call comprises:
changing a value of the parameter of the query to a string format.
14. The computer-implemented method of claim 9 , wherein the template syntax comprises at least one of: Handlebars, Mustache, or a semantic template language.
15. The computer-implemented method of claim 9 , 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.
16. The computer-implemented method of claim 9 further comprising:
by the one or more hardware computer processors executing instructions:
providing a second user interface configured to display and enable editing of a coding of the query that comprises the first and second sections of code.