IneoMData
api
audit
events
queue
trigger
Log in
Edit Generated Trigger
Trigger Name
AuthorizationUpdate
Trigger Version
4
Description
cause a fire when an authorization is created or updated
Trigger Deploy Status
deployed
Table Name
authorizations
Trigger Type
update
Fire Activity
update authorization
Fire Acctivity Headers
'placeholder'
Fire Activity Username
EventQueueTxUser
Override Generted Trigger
Trigger Generated
CREATE TRIGGER AuthorizationUpdate ON authorizations AFTER UPDATE AS BEGIN SET NOCOUNT ON; DECLARE @NOW DATE SET @NOW = GETDATE() INSERT INTO [000106IneoAudit].[dbo].[EventQueue]( EventSource, EventID, FireActivity, FireActivityHeaders, EventStatus, UserName, CreateDate, UpdateDate ) SELECT 'authorizations.authorizationUpdate.1', i.ID, 'update authorization', '{"igm-username":"EventQueueTxUser", "igm-authid":"' + i.authorizationid + '", "igm-clientid":"' + ltrim(str(i.clientid)) + '"}', 1, 'EventQueueTxUser', @NOW, @NOW FROM INSERTED AS i END
Back to Trigger List