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