Triggers- Example of Commit Request/Patient Initially

Description	Event	Condition
Used with a delay. This example is for FV Transport requests. If a call came in and a specific time stamp has not been selected than it will fire	Commit request initially	CASE WHEN RequestorCaller LIKE 'FlightCall%' AND (select count(*) FROM Times WHERE Type = 'Ticket Created') =1 THEN CASE WHEN (SELECT COUNT(*) FROM Times WHERE Type = 'Call Started') = 0  THEN 1 ELSE 0 END ELSE 0 END
Must use with a delay. This will notifiy of a new unassigned patient	Commit patient initially	CASE WHEN (SELECT COUNT(*) FROM tcentryplan WHERE request_number != '') = 0 THEN 1 ELSE 0 END
Can be used if need to trigger an action based off of patient age	Commit patient initially	(CAST(text('age') AS integer) < 29) AND (dropdown('age_unit') = 'days')
If you would like the action on the request side based on age	Commit request initially	(SELECT COUNT(*) FROM transferitem WHERE "1"=withTransferItem(ID, "(cast(text('age') AS Integer)<18 AND dropdown('age_unit') = 'years') OR dropdown('age_unit') IN ('months', 'days') "))
This will be used with Commit patient or Commit patient initially.  The below will occur when a patient is created or saved when their weight is greater than 136 kg or 300 lbs.	Commit patient initially	((cast(text('weight') as integer) > 136) AND (dropdown('weight_unit') = 'kg')) OR ((cast(text('weight') as integer) > 300) AND (dropdown('weight_unit') = 'lbs'))) AND ((text('weight') != initialtext('weight'))
Pickup Location Within Certain County and Scene Call type	Commit request initially	CASE WHEN (SELECT group_concat(withTransferItem(id, '(select pick_up_county from TcEntryPlan)'), ', ') FROM transferItem) like '% CountyName%' OR (SELECT group_concat(withTransferItem(id, '(select pick_up_county from TcEntryPlan)'), ', ') FROM transferItem) like '% CountyName%' OR (SELECT group_concat(withTransferItem(id, '(select pick_up_county from TcEntryPlan)'), ', ') FROM transferItem) like '% CountyName%' OR (SELECT group_concat(withTransferItem(id, '(select pick_up_county from TcEntryPlan)'), ', ') FROM transferItem) like '% CountyName%' OR (SELECT group_concat(withTransferItem(id, '(select pick_up_county from TcEntryPlan)'), ', ')  FROM transferItem) like '% CountyName%' OR (SELECT group_concat(withTransferItem(id, '(select pick_up_county from TcEntryPlan)'), ', ')  FROM transferItem) like '% CountyName%' OR (SELECT group_concat(withTransferItem(id, '(select pick_up_county from TcEntryPlan)'), ', ') FROM transferItem) LIKE '% CountyName%' THEN 1 ELSE 0 END AND CASE WHEN  calltype='Scene' THEN 1 ELSE 0 END