Required Field Rule Query Examples

 

The examples below are of queries that can be used to customize your CAD.

Calltype equals Interfacility and Scene, Reason for Close = 'Transport Complete and Patient field with the save as name of ('txtetagiven') is blank:

CASE WHEN CallType IN ('Interfacility', 'Scene') AND ReasonForClose = 'Transport Complete' THEN (SELECT COUNT(*) FROM transferitem WHERE withTransferItem(id, "type = 'Patient' AND text('txtetagiven') = ''")) = 0 ELSE 1 END

Other Service Declined Radio Button is required:

GETINT('otherServiceDeclined') IS NOT NULL

Flight Information Tab is Required except for with a calltype of Unused/Training, Administrative, Training:

CASE WHEN CallType IN ('Unused/Training','Administrative','Training') or Reasonforclose = 'Unused/Error' THEN 1 ELSE (Callsign !='' AND Asset !='' AND BaseName !='') END

Required Field Rule with First Name Required:

CASE WHEN Calltype IN ('Interfacility','Scene') and ReasonForClose - 'Complete' THEN (SELECT COUNT(*) FROM transferItem WHERE withTransferItem(id,'text(''firstName'')')='')=0 ELSE 1 END

Patient Tab Available and ignore the escort:

CASE WHEN ReasonForClose='Mission Complete' THEN (SELECT COUNT(*) FROM transferItem WHERE withTransferItem(id,'text(''patient_save_as_name'')')= '' AND withTransferItem(id, 'Type') = 'Patient') =0 ELSE 1 END

Required text field with a time stamp:

(SELECT COUNT(*) FROM Times WHERE ifnull(notes,'')='')=0

Crew Time Sequence:

IFNULL((select timeutc from times where type = 'Acknowledge') >= (select timeutc from times where type = 'Launch Page'),1 )

Multiple Time Stamps Needs to be added:

CASE when ((reasonforclose like '%Complete%' or reasonforclose like 'Aborted%') and Calltype NOT In ('Training','Maintenance')) THEN (((Select Count(*) FROM times WHERE Type = ('Crew Notified'))>0) and ((SELECT Count(*) FROM times WHERE Type = ('Transport Accepted'))>0)) ELSE 1 END