Selective query loading across query interfaces

Patent metadata

Field	Value
Publication number	US-11544248-B2
Application number	US-201916260971-A
Country	US
Kind code	B2
Filing date	Jan 29, 2019
Priority date	Jan 30, 2015
Publication date	Jan 3, 2023
Grant date	Jan 3, 2023

Abstract

A method includes receiving, in a first query interface, a query composed by the user by typing commands into a query box of the first query interface and based on the receiving of the query, causing events corresponding to query results of the query to be displayed in the first query interface with fields corresponding to the events. Based on the selection by the user of an option, a second query interface is displayed with a table that includes events that correspond to query results of a loaded query. The table includes columns corresponding to event attributes, rows corresponding to events. Cells are populated with the data items of event attributes, where one of the columns corresponds to a field of the fields displayed in the first query interface. The table also includes interactive regions selectable by the user to add one or more commands to the loaded query.

First claim

The invention claimed is:

1. A computer-implemented method comprising:
based on a character string that specifies commands of a query and is provided to a query box of a first query interface, causing display of a first query interface comprising a first set of events that corresponds to results of the query; and
in response to selection of an option that is located on the first query interface and associated with the query corresponding to the first set of events, causing the display of the first query interface to transition to a display of a second query interface comprising the query loaded into the second query interface and a table of a second set of events that corresponds to results of the query provided via the first query interface loaded into the second query interface, wherein the table comprises:
rows and columns of cells that display values of event attributes that are associated with the second set of events, wherein the columns correspond to the event attributes, and the rows correspond to the events, and wherein interactive regions of the table each correspond to at least one of the displayed values and is user selectable, via the second query interface, to modify the query loaded into the second query interface to add at least one command to the loaded query sequentially after the commands composed using the first query interface.

2. The computer-implemented method if claim 1 , wherein the character string specifies commands of a pipelined query language composed by typing the commands into the query box.

3. The computer-implemented method if claim 1 , wherein the first set of events that corresponds to results of the query is displayed in the first query interface with fields associated with the first set of events, and the event attributes comprise the fields displayed in the first query interface.

4. The computer-implemented method of claim 1 , further comprising:
based on the selection of the option, causing display of one or more form elements, each form element corresponding to at least one of the fields, the form elements allowing the user to select a subset of the fields;
wherein the display of the table includes a respective column in the columns of the table for each selected field in the subset of the fields based on the user selecting the subset of the fields, and the event attribute of the respective column is the selected field.

5. The computer-implemented method of claim 1 , further comprising:
based on the selection of the option, causing display of form elements corresponding to fields associated with the first set of events, the form elements allowing user selection of a subset of the fields; and
causing at least one column to be added to the columns of the table for each field in the subset of fields based on the user selection.

6. The computer-implemented method of claim 1 , further comprising based on the selection of the option, causing a command to be automatically added to the query to result in the loaded query, the command causing a field associated with the first set of events and displayed in the first query interface to not be one of the event attributes that are associated with the second set of events.

7. The computer-implemented method of claim 1 , wherein the query box is a search bar and the query is a search query.

8. The computer-implemented method of claim 1 , further comprising:
receiving, from the first query interface, a selection of a field from fields displayed with the first set of events; and
in response to the selection of the field, causing values of the field to be displayed in association with the events;
wherein a column is included in the columns in the second query interface based on the selection of the field in the first query interface.

9. The computer-implemented method of claim 1 , further comprising:
receiving, from the first query interface, a selection of a field from fields displayed with the first set of events; and
in response to the selection of the field, causing values of the field to be removed from display in association with the first set of events;
wherein the selection causes the columns to exclude a column for the field in the second query interface.

10. The computer-implemented method of claim 1 , further comprising based on the selection of the option, causing display of a command entry list in the second query interface, at least one command entry in the command entry list representing the query composed in the first query interface.

11. The computer-implemented method of claim 1 , wherein the option is represented by a button in the first query interface.

12. The computer-implemented method of claim 1 , further comprising:
causing an update to the loaded query to include one or more commands based on a selection of one or more of the interactive regions;
causing the updated query to be saved in association with a query object;
receiving a selection of a pipeline entry representing the query object in a selection interface; and
in response to the selection of the pipeline entry, loading the updated query into the first query interface using the query object.

13. The computer-implemented method of claim 1 , further comprising:
causing an update to the loaded query to include one or more commands based on a selection of one or more of the interactive regions;
causing the updated query to be saved in association with a query object; and
loading the updated query into the first query interface using the query object, wherein at least a portion of the updated query is represented in the query box.

14. The computer-implemented method of claim 1 , further comprising:
causing an update to the loaded query based on a selection of one or more of the interactive regions;
causing the updated query to be saved in association with a query object, the updated query comprising saved commands; and
loading the updated query into the first query interface using the query object, the updated query being loaded as an input query, wherein the first query interface allows user input to add one or more commands to the saved commands of the updated query, and precludes the user input from modifying the saved commands of the updated query.

15. The computer-implemented method of claim 1 , further comprising based on the selection of the option, automatically modifying the query such that the loaded query is executable to prevent a field displayed with the first set of events in the first query interface from being displayed with the second set of events using the columns.

16. The computer-implemented method of claim 1 , wherein the query defines an extraction of the values from the second set of events using a regular expression.

17. The computer-implemented method of claim 1 , wherein execution of the query applies a late-binding schema to the first set of events.

18. The computer-implemented method of claim 1 , wherein the loaded query is represented in a pipelined query language and each of the interactive regions is selectable to add one or more pipelined commands to the loaded query.

19. The computer-implemented method if claim 1 , wherein the first set of events that corresponds to results of the query is displayed in the first query interface with fields associated with the first set of events, and the event attributes comprise the fields displayed in the first query interface.

20. The computer-implemented method of claim 1 , further comprising:
based on the selection of the option, causing display of one or more form

Assignees

• Splunk Inc

Inventors

• Miller Jesse
• Robichaud Marc V
• Burke Cory
• James Alexander
• Lloyd Jeffrey Thomas

Classifications

• G06F16/24544

  Join order optimisation · CPC title

• G06T2200/24

  involving graphical user interfaces [GUIs] · CPC title

• G06F16/00

  Information retrieval; Database structures therefor; File system structures therefor · CPC title

• G06F16/2372 Primary

  Updates performed during offline database operations · CPC title

• G06F16/3334

  Selection or weighting of terms from queries, including natural language queries · CPC title