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
|
Comments
0 comments
Please sign in to leave a comment.