Example advanced SQL statement configuration

To define these SQL statement as an Advanced Database Lookup SQL:

select * from recorder_table where patientid =’001’ and date=’2013-7-1’ and doctorid =’003’

Placeholder fields can be used similar to these examples:

  • SQL Statement:
    select * from patient_table where patientid =patientid and date=date and doctorid=doctorid
  • In:
    patientid,date,doctorid
  • Out:
    patientid,date,doctorid,patientname,doctorname,result