Create, update, delete, and query from TimeTriggersAutomationRules table

Table Specific Information

Note: Only users with admin privileges can access the following Table.

Select

Following is an example to select all entries from TimeTriggersAutomationRules table:

SELECT * FROM TimeTriggersAutomationRules

The API allows only a subset of columns to be used as filter criteria in the WHERE clause. The filters listed can also be combined using AND OR. The following columns can be used:

• Id

Insert

Name, Actions, and Conditions are mandatory to Insert into TimeTriggersAutomationRules table. For instance:

INSERT INTO TimeTriggersAutomationRules (Name, Actions, Conditions) VALUES ('Test', '[{"field_name": "status", "value": 5}]', '[{"name": "condition_set_1", "match_type": "any", "properties": [{"field_name": "to_email", "resource_type": "ticket", "operator": "contains", "value": ["@lyftron.com"]}]}]')

Update

Following is an example of how to update TimeTriggersAutomationRules table:

UPDATE TimeTriggersAutomationRules SET Name = 'Test2' WHERE Id = '2043002030021'

Delete

Following is an example of how to delete from the TimeTriggersAutomationRules table:

DELETE FROM TimeTriggersAutomationRules WHERE Id = '2043002030021'

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Bigint	False	Unique ID of the TimeTriggersAutomationRule.
Actions	String	False	Actions of the TimeTriggersAutomationRule.
Active	Boolean	False	Active of the TimeTriggersAutomationRule.
AffectedTicketsCount	Int	False	AffectedTicketsCount of the TimeTriggersAutomationRule.
Conditions	String	False	Conditions of the TimeTriggersAutomationRule.
Name	String	False	Name of the TimeTriggersAutomationRule.
Outdated	Boolean	True	Outdated of the TimeTriggersAutomationRule.
Position	Int	False	Position of the TimeTriggersAutomationRule.
Summary	String	True	Summary of the TimeTriggersAutomationRule.
CreatedAt	Datetime	True	TimeTriggersAutomationRule creation timestamp.
UpdatedAt	Datetime	True	TimeTriggersAutomationRule updated timestamp.