SYSTEM FOR PROVIDING DYNAMIC LINKED PANELS IN USER INTERFACE

• US 20160062555A1
• Filed: 08/31/2015
• Published: 03/03/2016
• Est. Priority Date: 09/03/2014
• Status: Active Grant

• Current Assignee: Palantir Technologies Incorporated
• Original Assignee: Palantir Technologies Incorporated
• Inventors: Ward, Lindsay, Cicerone, Derek, Biswal, Punyashloka, Li, Sixin, Cameron, Geoff, Storr, Adam, Ramaswamy, Ashwin
• Granted Patent: US 9,454,281 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2425 Iterative querying; Query formulation based on the results of a preceding query
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: G06F 3/0481 based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
• CPC Class Codes: G06F 40/14 Tree-structured documents parsing G06F40/205; validation G06F40/226
• CPC Class Codes: G06F 40/151 Transformation
• CPC Class Codes: G06F 40/186 Templates
• CPC Class Codes: G09G 2354/00 Aspects of interface with display user
• CPC Class Codes: G09G 5/14 Display of multiple viewports

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.

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 user interface configured to display a plurality of panels including a first panel and a second panel, each of the plurality of panels having respective display settings and queries including code for querying one more data sources;

execute a first query associated with the first panel;

display the first panel in the 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 being associated with a variable;

execute a second query associated with the second panel, wherein the second query refers to the variable associated with the first query of the first panel;

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 associated with the second panel; and

update the display of the second panel in the user interface based on results of the re-executed second query of the second panel.

2. The system of claim 1, wherein the code is further configured to:

receive a third query from the first panel for writing data to the one or more data sources;

process one or more parameters in the third query by invoking a function; and

perform the third query with the processed one or more parameters to write data to the one or more data sources.

3. The system of claim 2, wherein the processing of the one or more parameters in the third query is performed at least in part by:

replacing the one or more parameters with respective placeholders; and

storing respective values corresponding to the one or more parameters in an array.

4. The system of claim 2, wherein the processing of the one or more parameters in the third query is performed at least in part by changing respective values corresponding to the one or more parameters to string format.

5. The system of claim 2, wherein each of the plurality of panels is referenced as a template that is rendered by a template engine, and the function is registered with the template engine.

6. The system of claim 1, wherein the code is further configured to:

prior to running the query of the first panel, invoke one or more functions to determine whether a table, a row, or a column referenced in the query exists in the one or more data sources.