AuthorizationUpdate

cause a fire when an authorization is created or updated

authorizations

update

depricated

update authorization

'placeholder'

EventQueueTxUser

3

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

Edit | Edit Trigger Generated | New Version | Back to Trigger List