SOAP form and the Encounter Date

OpenEMR Development
1

anonymous wrote on Thursday, January 19, 2012:

Does anyone know a way to run a  query and get the Encounter  Date for a particular SOAP form? Or, all the encounter dates for all the soap forms?  Thanks in advance.

2

cbezuidenhout wrote on Friday, January 20, 2012:

you could try :

For a single SOAP form :

SELECT fe.date FROM form_soap fs
JOIN forms f ON fs.id = f.form_id
JOIN form_encounter fe ON fe.encounter = f.encounter
WHERE fs.id = 16;

just change 16 to the soap form’s ID

For all SOAP forms :

SELECT fe.date FROM form_soap fs
JOIN forms f ON fs.id = f.form_id
JOIN form_encounter fe ON fe.encounter = f.encounter;

Hope that helps

3

anonymous wrote on Friday, January 20, 2012:

Oh thanks so much!