Trigger example

CREATE TRIGGER au_surveyQns_i
AFTER INSERT ON surveyQuestions
REFERENCING NEW AS N
FOR EACH ROW
WHEN (1 = (SELECT isActive FROM triggerControl WHERE triggerName='au_surveyQns_i'))
BEGIN ATOMIC
DECLARE QUESTIONSET VARCHAR(100);
SET QUESTIONSET = (SELECT description FROM surveyquestionset WHERE ID = N.surveyquestionsetid);
INSERT INTO CCAuditTrailChangedItem (functionId, actionId, sourceId, changeField, newValue, createdOn, createdBy)
VALUES ('0007', '0010', N.Id, CONCAT(questionSet , 'Question' ), N.description, N.lastModifiedOn, N.lastModifiedBy);

END#

inside wsrp

inside wsrp

Using java script in ant

Using java script in ant