Create, update, delete, and query from TicketUpdatesAutomationRules 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 TicketUpdatesAutomationRules table:

SELECT * FROM TicketUpdatesAutomationRules

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, Conditions, Performer, and Events are mandatory to Insert into TicketUpdatesAutomationRules table. For instance:

INSERT INTO TicketUpdatesAutomationRules (Name, Actions, Conditions, Performer, Events) 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"]}]}]', '{"type": 1}', '[{"field_name": "reply_sent"}]')

Update

Following is an example of how to update TicketUpdatesAutomationRules table:

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

Delete

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

DELETE FROM TicketUpdatesAutomationRules WHERE Id = '2043002030021'

Columns

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