Displaying multiple editable queries in a graphical user interface

Patent metadata

Field	Value
Publication number	US-11269871-B1
Application number	US-201916513532-A
Country	US
Kind code	B1
Filing date	Jul 16, 2019
Priority date	Jul 16, 2019
Publication date	Mar 8, 2022
Grant date	Mar 8, 2022

Abstract

Systems and methods are disclosed for performing multiple queries in a single graphical user interface (GUI) displayed in a client browser. The client browser causes the display of a first user interface field in a first area of the GUI, where the first user interface field can be used to enter or edit a first query. The client browser also causes first query results generated by a data intake and query system executing the first query to be displayed in the first area. The client browser further causes the display of a second user interface field in a second area of the GUI, where the second user interface field can be used to enter or edit a second query. The client browser also causes second query results generated by the data intake and query system executing the second query to be displayed in the second area.

First claim

What is claimed is:

1. A method, comprising
causing display, within a first area of a graphical user interface, of a first user interface field for editing a first query that identifies a first set of data, the first set of data comprising raw machine data associated with a timestamp, the first area corresponding to a first panel of a workbook, wherein the first panel provides a logical association between the first query, first query results corresponding to the first query, and a first graphical display object;
based at least in part on execution of the first query, causing display of the first graphical display object within an expanded first area based on the first query results;
causing display, within a second area of the graphical user interface, of a second user interface field for editing a second query that identifies a second set of data, the second area corresponding to a second panel of the workbook and displayed concurrently with an unmodified display of the first area, wherein the second panel provides a logical association between the second query, second query results corresponding to the second query, and a second graphical display object, and wherein the workbook provides a logical association between the first panel and the second panel; and
based at least in part on execution of the second query, causing display of the second graphical display object within an expanded second area based on the second query results.

2. The method of claim 1 , wherein the first set of data and the second set of data are stored in a time series data store.

3. The method of claim 1 , wherein the second set of data is independent of the first set of data.

4. The method of claim 1 , wherein the first query is entered by a first user using a first client device, and wherein the second query is entered by a second user using a second client device separate from the first client device.

5. The method of claim 1 , wherein the first query is entered by a first user using a first client device, wherein the second query is entered by a second user using a second client device separate from the first client device, and wherein the second user was granted access to the workbook via an invitation sent by the first user.

6. The method of claim 1 , wherein the first query is entered by a first user using a first client device, wherein the second query is entered by a second user using a second client device separate from the first client device, and wherein the workbook was designated as publicly accessible by the first user.

7. The method of claim 1 , wherein the first query is entered by a first user using a first client device, wherein the second query is entered by a second user using a second client device separate from the first client device, and wherein the second user does not have permission to edit the first query.

8. The method of claim 1 , wherein the first query is entered by a first user using a first client device, wherein the second query is entered by a second user using a second client device separate from the first client device, and wherein the second user does not have permission to edit the first query because the first user instructed the first query to be locked.

9. The method of claim 1 , wherein the first query is entered by a first user using a first client device, wherein the second query is entered by a second user using a second client device separate from the first client device, and wherein the first user and the second user can concurrently edit the first query and the second query.

10. The method of claim 1 , wherein the first query and the second query are executed concurrently.

11. The method of claim 1 , wherein the second query is executed after the first query.

12. The method of claim 1 , wherein the second query is executed after the first query, and wherein the second set of data is a portion of the first set of data.

13. The method of claim 1 , wherein the second query is executed after the first query, and wherein the second set of data is the first query results generated in response to execution of the first query.

14. The method of claim 1 , wherein the second query is executed after the first query, and wherein the second query is executed each time the first query is modified and a new set of first query results are generated.

15. The method of claim 1 , wherein the second query is executed after the first query, and wherein causing display of the second graphical display object further comprises:
appending an identifier corresponding to the first query results in front of the second query to form a modified second query; and
based at least in part on execution of the modified second query, causing display of the second graphical display object within the expanded second area based on the second query results.

16. The method of claim 1 , wherein the first query is executed less frequently than the second query.

17. The method of claim 1 , wherein the first query results are stored in a cache layer of a client browser and in a metadata catalog in a data intake and query system.

18. The method of claim 1 , wherein the first graphical display object and the second graphical display object are concurrently visible.

19. The method of claim 1 , wherein the first graphical display object comprises a table.

20. The method of claim 1 , wherein the first graphical display object comprises a table, and wherein the first query results populate the table.

21. The method of claim 1 , further comprising, in response to selection of a button in the graphical user interface, causing display, within a third area of the graphical user interface, of a third user interface field for editing a third query, the third area corresponding to a third panel of the workbook.

22. The method of claim 1 , further comprising, in response to selection of a button in the graphical user interface, associating at least one of an image, a file, or a comment with the first panel.

23. The method of claim 1 , further comprising:
in response to selection of a button in the graphical user interface by a first user, associating a comment with the first panel;
causing display of the comment adjacent to the first area of the graphical user interface; and
in response to modification of the displayed comment by a second user using a second client device separate from the first client device, modifying the displayed comment.

24. The method of claim 1 , wherein the first query and the second query are executed using different processing threads.

25. The method of claim 1 , further comprising:
receiving change data indicating a change to the workbook that has occurred;
retrieving workbook data associated with the workbook from a workbook data store;
modifying the workbook data to include the change data; and
storing the modified workbook data in the workbook data store.

26. The method of claim 1 , further comprising:
receiving change data indicating a change to the workbook that has occurred; and
storing the change data in workbook data store in association with workbook data corresponding to the workbook.

27. The method of claim 1 , wherein the first panel provides a logical association between the first query, the first query results, the first graphical display object, and at least one of an image, a comment, or a file.

28. The method of claim 1 , further c

Assignees

• Splunk Inc

Inventors

• Bigdelu Nasim
• Mohan Hema Krishnamurthy
• Moshgabadi Amin
• Mullen Clark Eugene
• Singamneni Siri
• Streit Daniel

Classifications

• G06F16/252

  between a Database Management System and a front-end application · CPC title

• G06F16/2428 Primary

  Query predicate definition using graphical user interfaces, including menus and forms (G06F16/2423 takes precedence) · CPC title

• G06F16/2425 Primary

  Iterative querying; Query formulation based on the results of a preceding query · CPC title