Returns triggers used to automatically perform actions when specified conditions are met.

Table-Specific Information

Select

The following queries are processed server-side while other filters are processed client-side within the provider.

SELECT * FROM Triggers WHERE Id = '123'

SELECT * FROM Triggers WHERE Active = true

SELECT * FROM Triggers ORDER BY Position

SELECT * FROM Triggers ORDER BY CreatedAt

SELECT * FROM Triggers ORDER BY UpdatedAt

Insert

The Title, ConditionsAll, and Actions columns are required to insert. This operation is allowed for logged-in users with the "agent" role.

INSERT INTO Triggers (Title, ConditionsAll, Actions) VALUES ('Roger Wilco', '[{ \"field\": \"status\", \"operator\": \"is\", \"value\": \"open\" }, { \"field\": \"priority\", \"operator\": \"less_than\", \"value\": \"high\" }]', '[{ \"field\": \"group_id\", \"value\": \"20455932\" }]')

Update

You must specify the Id of the trigger to update. Title is required. Updating an action updates the containing array, clearing the other actions. Include all your actions when updating any action. This operation is allowed for logged-in users with the "agent" role.

UPDATE Triggers SET Title = 'Roger Wilco III' WHERE Id = '123'

Delete

You must specify the Id of the trigger to delete it. This operation is allowed for logged-in users with the "agent" role.

DELETE FROM Triggers WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The Id automatically assigned when the trigger is created.
Title	String	False		The title of the trigger.
Active	Boolean	False		Indicates whether the trigger is active.
Position	Integer	False		The position of the trigger, which determines the order in which triggers execute.
ConditionsAll	String	False		An object that describes the conditions under which the trigger executes. All conditions in this object must be met.
ConditionsAny	String	False		An object that describes the conditions under which the trigger executes. Any one condition in this object must be met.
Actions	String	False		An object describing the actions the trigger performs.
Description	String	False		The description of the trigger.
CreatedAt	Datetime	True		The date and time when the trigger was created.
UpdatedAt	Datetime	True		The date and time when the trigger was last updated.