System and method for database access using a history walker

Patent metadata

Field	Value
Publication number	US-11336523-B2
Application number	US-202016923442-A
Country	US
Kind code	B2
Filing date	Jul 8, 2020
Priority date	Oct 4, 2017
Publication date	May 17, 2022
Grant date	May 17, 2022

Abstract

Systems and methods for a history walker interface to a time-based data structure are disclosed. A time-based data structure may contain information about updates to a set of records that change periodically over time. For example, a set of records that record state transitions of a task item as the task item progresses through its life cycle. An example task item may be represented by a change request or incident report in a help desk software application. The task item begins with an “open” state and may transition through any number of states (e.g., assigned, on-hold, test, customer response requested, etc.) on its way to ultimately being “closed” as completed. A history walker interface may assist application developers when creating applications to indicate how the task item transitioned through its different states throughout its lifecycle.

First claim

What is claimed is:

1. A system, comprising:
one or more hardware processors; and
a non-transitory memory storing instructions that, when executed by the one or more hardware processors, causes the one or more hardware processors to perform actions comprising:
providing a first representation of a graphical user interface (GUI) to a client device, wherein the first representation of the GUI displays a timeline for each item of one or more items associated with a time-based data structure;
requesting update information associated with a portion of a particular timeline from a history walker interface configured to retrieve the update information from the time-based data structure, wherein the update information is related to an update to a particular item of the one or more items, and wherein the update is positioned along the particular timeline;
receiving the update information from the history walker interface, wherein the update information is indicative of one or more additional updates that precede the update, or proceed the update, or both; and
providing a second representation of the GUI to the client device, wherein the second representation of the GUI comprises the update and the one or more additional updates positioned along the particular timeline.

2. A method, comprising:
providing a first representation of a graphical user interface (GUI) to a client device, wherein the first representation of the GUI displays a timeline for each item of one or more items associated with a time-based data structure;
requesting update information associated with a portion of a particular timeline from a history walker interface configured to retrieve the update information from the time-based data structure, wherein the update information is related to an update to a particular item of the one or more items, and wherein the update is positioned along the particular timeline;
receiving the update information from the history walker interface, wherein the update information is indicative of one or more additional updates that precede the update, or proceed the update, or both; and
providing a second representation of the GUI to the client device, wherein the second representation of the GUI comprises the update and the one or more additional updates positioned along the particular timeline.

3. A non-transitory computer-readable medium comprising computer readable instructions, that when executed by one or more processors, causes the one or more processors to perform operations comprising:
providing a first representation of a graphical user interface (GUI) to a client device, wherein the first representation of the GUI displays a timeline for each item of one or more items associated with a time-based data structure;
requesting update information associated with a portion of a particular timeline from a history walker interface configured to retrieve the update information from the time-based data structure, wherein the update information is related to an update to a particular item of the one or more items, and wherein the update is positioned along the particular timeline;
receiving the update information from the history walker interface, wherein the update information is indicative of one or more additional updates that precede the update, or proceed the update, or both; and
providing a second representation of the GUI to the client device, wherein the second representation of the GUI comprises the update and the one or more additional updates positioned along the particular timeline.

4. The system of claim 1 , wherein the second representation of the GUI comprises field values for the update, or each of the one or more additional updates, or both, and indicates field value changes between the update and the one or more additional updates.

5. The system of claim 1 , wherein the second representation of the GUI is configured to display a dialog box in response to a selection of a particular update of a plurality of closely occurring updates of the update and the one or more additional updates, and wherein the dialog box enables navigation of the plurality of closely occurring updates.

6. The system of claim 1 , wherein the actions comprise generating the first representation of the GUI in response to receiving a selection of the time-based data structure and the update.

7. The system of claim 1 , wherein the one or more items comprise tasks associated with one or more service level agreements (SLAs), and wherein the first representation of the GUI and the second representation of the GUI indicate compliance with the one or more SLAs.

8. The system of claim 1 , wherein the first representation of the GUI comprises a selectable option to retrieve field value changes between the update and the one or more additional updates.

9. The system of claim 1 , wherein the first representation of the GUI and the second representation of the GUI indicate whether each update of the update and the one or more additional updates are a task update or a task update with a state change, and whether each item of the one or more items is in-progress, completed, or canceled.

10. The method of claim 2 , wherein the second representation of the GUI comprises field values for the update, or each of the one or more additional updates, or both, and indicates field value changes between the update and the one or more additional updates.

11. The method of claim 2 , wherein the second representation of the GUI is configured to display a dialog box in response to a selection of a particular update of a plurality of closely occurring updates of the update and the one or more additional updates, and wherein the dialog box enables navigation of the plurality of closely occurring updates.

12. The method of claim 2 , comprising generating the first representation of the GUI in response to receiving a selection of the time-based data structure and the update.

13. The method of claim 2 , wherein the first representation of the GUI and the second representation of the GUI indicate whether each update of the update and the one or more additional updates are a task update or a task update with a state change and whether each item of the one or more items is in-progress, completed, or canceled.

14. The non-transitory computer-readable medium of claim 3 , wherein the second representation of the GUI comprises field values for the update, or each of the one or more additional updates, or both, and indicates field value changes between the update and the one or more additional updates.

15. The non-transitory computer-readable medium of claim 3 , wherein the second representation of the GUI is configured to display a dialog box in response to a selection of a particular update of a plurality of closely occurring updates of the update and the one or more additional updates, and wherein the dialog box enables navigation of the plurality of closely occurring updates.

16. The non-transitory computer-readable medium of claim 3 , wherein the one or more items comprise tasks associated with one or more service level agreements (SLAs), and wherein the first representation of the GUI and the second representation of the GUI indicate compliance with the one or more SLAs.

17. The non-transitory computer-readable medium of claim 3 , wherein the first representation of the GUI comprises a selectable option to retrieve field value changes between the update and the one or more additional updates.

18. The system of claim 7 , wherein each task comprises one or more color-coded segments representing an elapsed timeline a

Assignees

• Servicenow Inc

Inventors

• Bell Nigel
• Richard Cameron
• Occhialini Jason

Classifications

• G06Q10/06314 Primary

  Calendaring for a resource · CPC title

• H04L41/0859 Primary

  by keeping history of different configuration generations or by rolling back to previous configuration versions · CPC title

• H04L67/55

  Push-based network services · CPC title

• G06F16/248

  Presentation of query results · CPC title

• G06Q40/12

  Accounting · CPC title