# SOAP form and the Encounter Date

**URL:** <https://community.open-emr.org/t/soap-form-and-the-encounter-date/5407>\
**Category:** OpenEMR Development\
**Created:** [January 19, 2012, 6:25pm UTC](https://community.open-emr.org/t/soap-form-and-the-encounter-date/5407 "2012-01-19T18:25:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [January 19, 2012, 6:25pm UTC](https://community.open-emr.org/t/soap-form-and-the-encounter-date/5407/1 "2012-01-19T18:25:11Z")

</div>

**anonymous** wrote on [Thursday, January 19, 2012](https://sourceforge.net/p/openemr/discussion/202506/thread/39a36bc2/#3428):

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

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [January 20, 2012, 3:22pm UTC](https://community.open-emr.org/t/soap-form-and-the-encounter-date/5407/2 "2012-01-20T15:22:39Z")

</div>

**[cbezuidenhout](https://sourceforge.net/u/cbezuidenhout/)** wrote on [Friday, January 20, 2012](https://sourceforge.net/p/openemr/discussion/202506/thread/39a36bc2/#182a):

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

- Craig  
&nbsp;&nbsp; - [TajEmo Enterprises](http://tajemo.co.za/)

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [January 20, 2012, 3:55pm UTC](https://community.open-emr.org/t/soap-form-and-the-encounter-date/5407/3 "2012-01-20T15:55:41Z")

</div>

**anonymous** wrote on [Friday, January 20, 2012](https://sourceforge.net/p/openemr/discussion/202506/thread/39a36bc2/#ba98):

Oh thanks so much!