Description | Event | Condition |
|---|---|---|
| Will activate when the Requestor City or Receiver City is a specific city and a Callsign is a specific one | Assign Asset | CASE WHEN (SELECT group_concat(WithTransferItem(id, '(SELECT Pick_up_City FROM TCEntryPlan)'),',')
|
| When a Call Type is a specific and going to a specific airport | Assign Asset | CASE WHEN Calltype IN ('FW Interfacility', 'Scene') THEN CASE WHEN (SELECT group_concat(withTransferItem(ID, '(SELECT pick_up_name FROM TcEntryPlan)'), ', ') FROM transferItem) LIKE '%airport name here%' THEN 1 ELSE 0 END ELSE 0 END |
| If Assigned as a call type of Standby or disposition of Standby and not Launched with in X Minutes. For this trigger you will add a delay time of your choosing | Assign Asset | CASE WHEN CallType = 'Standby/Move-Up' OR disposition LIKE '%Standby%' THEN 1 ELSE 0 END |
| This is a Time of day to initiate trigger. It will be true between 0700 and 2200 (including endpoints) local to the server time and certain calltype | Assign Asset | CASE WHEN CallType NOT IN ('Calltype Name', 'Calltype Name', 'Calltype Name', 'Calltype Name') THEN strftime('%H','now','localtime') >= '07' AND strftime('%H','now','localtime') < '21' ELSE 0 END |
| Will trigger if a calltype is Scene and the distance is greater than or equal to 25 | Assign Asset | Case when Calltype = 'Scene' and (select sum(distancenm(WpFrom.Latitude,WpFrom.Longitude,WpTo.Latitude,WpTo.Longitude)) from requestplan as WpFrom INNER JOIN RequestPlan AS WpTo ON WpFrom.RouteIndex + 1 = WpTo.RouteIndex AND distancenm(WpFrom.Latitude,WpFrom.Longitude,WpTo.Latitude,WpTo.Longitude)>=25 AND WpFrom.Latitude!=0 AND WpFrom.Longitude!=0 AND WpTo.Latitude!=0 AND WpTo.Longitude !=0 AND WpTo.RouteIndex <= (select routeindex from RequestPlan WHERE intent = 'patient' order by routeindex asc limit 1)) >= 25 then 1 else 0 end |
| If Pickup waypoint is greater than 24.9 | Assign Asset | case when Distancenm((select latitude from requestplan where RouteIndex = 0), (select longitude from requestplan where RouteIndex = 0), (select latitude from requestplan where intent = 'patient'), (select longitude from requestplan where intent = 'patient')) > 24.9 then 1 else 0 end |
| Will trigger when a certain team name is assigned to the request | Assign Asset | CASE WHEN (SELECT COUNT(*) FROM CrewAboard WHERE TeamName ='Team Name' ) > 0 THEN 1 ELSE 0 END |
| Will trigger if pickup to dropoff is greater than 60 nm | Assign Asset | case when receivername = 'Children''s Hospital of Georgia' and DistanceNM( (SELECT Latitude FROM RequestPlan WHERE Intent = 'patient'), (SELECT Longitude FROM RequestPlan WHERE Intent = 'patient'), (SELECT Latitude FROM RequestPlan WHERE Intent = 'patientDropOff'), (SELECT Longitude FROM RequestPlan WHERE Intent = 'patientDropOff') ) > 60 then 1 else 0 end |
Trigger- Example of Assign Asset
Comments
0 comments
Please sign in to leave a comment.