Related table notifications

Patent metadata

Field	Value
Publication number	US-10162874-B2
Application number	US-201614993697-A
Country	US
Kind code	B2
Filing date	Jan 12, 2016
Priority date	Jan 15, 2015
Publication date	Dec 25, 2018
Grant date	Dec 25, 2018

Abstract

Systems, apparatuses, and methods for related table notifications are disclosed. Notifications are configured for at least two live feeds. Each of the live feeds is associated with a table of a plurality of tables. When data is changed within the table, the notifications are published to the live feeds as long as conditions established for the notifications are met.

First claim

What is claimed is:

1. An apparatus for providing notifications of changes to data through a live feed, comprising:
a processor configured to execute instructions stored in a memory, the instructions comprising:
one or more user interface routines that when executed:
present an input screen via a user interface connection, the input screen comprising a first entry field for a change to data stored within a first reference field of a plurality of reference fields; and
receive change data over the user interface connection from the first entry field responsive to the change to the data; and

one or more publication routines that when executed:
generate a notification based on:
a message comprising a variable name identifying the first reference field;
data accessed from the first reference field based on the variable name;
conditions specified by user-selectable options each defining a pre-defined selection criterion associated with the change to the data; and
a code or script provided separate from the conditions and that provides additional conditions, wherein the additional conditions specified by the code or script take precedence in modifying the message over the conditions specified by the user-selectable options when in conflict; and

publish the notification in response to a respective change to the data upon confirming that the change to the data satisfies the conditions and the additional conditions, wherein the notification is published over a communications interface to a first live feed associated with a first table of a plurality of tables, the first table having the first reference field, and to a second live feed associated with a second table of the plurality of tables, the second table having a second reference field related to the first reference field, wherein the notification, when published to the second live feed, differs from the notification published to the first live feed based in part on the message, the conditions, and the additional conditions.

2. The apparatus of claim 1 , wherein the one or more publication routines, when executed, asynchronously publish the notification over the communications interface to the second live feed associated with the second table.

3. The apparatus of claim 1 , wherein the one or more publication routines, when executed, synchronously publish the notification over the communications interface to the second live feed associated with the second table.

4. The apparatus of claim 1 , wherein an identification of the first live feed is based on the changed data.

5. The apparatus of claim 1 , wherein the one or more publication routines, when executed, automatically modify data in the second reference field in response to the change data.

6. The apparatus of claim 1 , wherein the plurality of tables comprise project management data.

7. The apparatus of claim 1 , wherein the first table comprises fields containing project identifiers and related task identifiers.

8. The apparatus of claim 7 , wherein the second table comprises fields containing the task identifiers, individual's names, and date data.

9. The apparatus of claim 7 , wherein the task identifiers are further broken down into sub-task identifiers.

10. The apparatus of claim 9 , wherein the task and sub-task identifiers comprise a state selected from the group consisting of: pending, open, work in process, closed complete, closed incomplete, and closed skipped.

11. The apparatus of claim 10 , further comprising one or more task status routines that when executed:
determine if all sub-tasks making up a task have a status of complete; and
when all of the sub-tasks making up the task have a status of complete, change the status of the task to complete.

12. The apparatus of claim 1 , wherein the code or script provided separate from the conditions provide the additional conditions separate from what can be specified by the user-selectable options used to specify the conditions.

13. The apparatus of claim 1 , wherein each pre-defined selection criterion comprises: a table of the plurality of tables, a variable, an operator, or a value.

14. The apparatus of claim 1 , wherein the executable code or script is entered via free text entry to the code entry field.

15. The apparatus of claim 1 , wherein the plurality of reference fields comprises a first set of reference fields within the first table and a second set of reference fields within the second table, wherein at least one of the second set of reference fields is related to a reference field of the first set of reference fields.

16. An apparatus for assigning notification actions for a live feed related to changes in data in related tables, comprising:
a processor configured to execute instructions stored in a memory, the instructions comprising:
one or more user interface routines that when executed:
present an input screen the input screen comprising:
one or more fields used to specify conditions for generating a notification in response to a data change within one or more tables, each field populated by a selected, pre-defined option for the respective field; and
a code entry field provided separate from the conditions populated by an executable code or script that specifies additional conditions, wherein the additional conditions supersede the conditions when a conflict arises between the additional conditions and the conditions;

receive via interaction with the input screen:
user selections of entries to the one or more fields specifying the conditions; and
the executable code or script via text entry to the code entry field;

produce a configured notification for publication to a first live feed and a second live feed based on a notification message and on the conditions and the additional notification conditions, wherein the additional conditions take precedence in modifying the notification message over the conditions when in conflict, wherein the notification, when published to the second live feed, differs from the notification when published to the first live feed based in part on the notification message, the conditions, and the additional conditions; and
store the configured notification in the memory.

17. The apparatus of claim 16 , wherein the input screen further comprises:
a message field configured to receive and store the notification message used in producing the configured notification.

18. The apparatus of claim 16 , wherein the one or more fields comprise a first subfield for entering a variable item, a second subfield for entering an operator, and a third subfield for entering a value of the variable.

19. A method for assigning notification actions for a live feed related to changes in data in related tables, comprising:
presenting an input screen on a display device, the input screen comprising:
one or more fields used to specify conditions for generating a notification in response to a data change within one or more tables, each field populated by a selected, pre-defined option for the respective field; and
a code entry field populated by an executable code or script that specifies additional conditions separate from the conditions, wherein the additional conditions supersede the conditions when a conflict arises between the additional conditions and the conditions;

receiving via interaction with the input screen:
user selections of entries to the one or more fields specifying the conditions; and
the executable code or script via text entry to the code entry field;

producing, using a processor, a configured noti

Assignees

• Servicenow Inc

Inventors

• Dirisala Siva

Classifications

• G06F17/30368

  Physics · mapped topic

• G06F3/04842

  Selection of displayed objects or displayed text elements (G06F3/0482 takes precedence) · CPC title

• G06F3/0482

  Interaction with lists of selectable items, e.g. menus · CPC title

• G06F17/30581 Primary

  Physics · mapped topic

• G06Q10/00 Primary

  Administration; Management · CPC title