# General Query Issue

**URL:** <https://community.open-emr.org/t/general-query-issue/19869>\
**Category:** Day-to-Day Users\
**Created:** [January 25, 2023, 12:21am UTC](https://community.open-emr.org/t/general-query-issue/19869 "2023-01-25T00:21:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dmnlbh](https://community.open-emr.org/letter_avatar_proxy/v4/letter/d/e99b99/32.png) [@dmnlbh](https://community.open-emr.org/u/dmnlbh)\
**Post date:** [January 25, 2023, 12:21am UTC](https://community.open-emr.org/t/general-query-issue/19869/1 "2023-01-25T00:21:50Z")

</div>

We have several queries that pull data related to encounters for us, and I find that if there is no insurance (ie, client is self/cash pay or pays on a sliding scale), those clients do not show up in the data pulls. I’m finding that seems to be the common identifier as of now, so I thought I would get feedback on how to address this.

SELECT  
pdat.fname,  
pdat.lname,  
pc.pc\_pid,  
pdat.DOB,  
pc.pc\_eventDate,  
pc.pc\_startTime,  
pc.pc\_endTime,  
pc.pc\_apptstatus,  
pc.pc\_title,  
pc.pc\_room,  
pc.pc\_hometext,  
CONCAT(u.fname, ’ ', u.mname, ’ ', u.lname) as Provider,  
insdat.type AS Ins ,  
ic.name AS Carrier,  
insdat.plan\_name AS Program,  
insdat.policy\_number AS PolNr,  
pdat.procode AS Class  
FROM  
insurance\_data insdat  
inner join patient\_data pdat on insdat.pid = pdat.pid  
inner join insurance\_companies ic ON ic.id = insdat.provider  
LEFT JOIN  
openemr\_postcalendar\_events pc ON pdat.pid = pc.pc\_pid  
LEFT JOIN users u ON u.id = pc.pc\_aid  
WHERE pc.pc\_eventDate = “2022-10-10”  
ORDER BY pc.pc\_startTime ASC  
;

---

<div class="post-metadata">

**Author:** ![Param\_CapMinds](https://community.open-emr.org/user_avatar/community.open-emr.org/param_capminds/32/17750_2.png) [@Param\_CapMinds](https://community.open-emr.org/u/Param_CapMinds)\
**Post date:** [January 25, 2023, 1:52pm UTC](https://community.open-emr.org/t/general-query-issue/19869/2 "2023-01-25T13:52:54Z")

</div>

Hi Dava Muserallo,

You can try this query it will provide result  
SELECT  
pdat.fname,  
pdat.lname,  
pc.pc\_pid,  
pdat.DOB,  
pc.pc\_eventDate,  
pc.pc\_startTime,  
pc.pc\_endTime,  
pc.pc\_apptstatus,  
pc.pc\_title,  
pc.pc\_room,  
pc.pc\_hometext,  
CONCAT(u.fname, ’ ', u.mname, ’ ', u.lname) as Provider,  
insdat.type AS Ins ,  
ic.name AS Carrier,  
insdat.plan\_name AS Program,  
insdat.policy\_number AS PolNr,  
pdat.procode AS Class  
FROM  
insurance\_data insdat  
inner join patient\_data pdat on insdat.pid = pdat.pid  
inner join insurance\_companies ic ON ic.id = insdat.provider  
LEFT JOIN  
openemr\_postcalendar\_events pc ON pdat.pid = pc.pc\_pid  
LEFT JOIN users u ON u.id = pc.pc\_aid  
WHERE pc.pc\_eventDate = ‘2022-10-10’  
ORDER BY pc.pc\_startTime ASC;

Thanks  
Param  
[help@capminds.com](mailto:help@capminds.com)

---

<div class="post-metadata">

**Author:** ![robert.down](https://community.open-emr.org/user_avatar/community.open-emr.org/robert.down/32/15055_2.png) [@robert.down](https://community.open-emr.org/u/robert.down)\
**Post date:** [January 26, 2023, 4:46am UTC](https://community.open-emr.org/t/general-query-issue/19869/3 "2023-01-26T04:46:20Z")

</div>

A pro tip for pasting code or SQL here on the discourse forums: you can wrap the code in 3 back ticks and syntax highlighting and other features will kick in. Below is an example, I have three back ticks followed immediately by “sql” indicating the code type and then a new line with the SQL and close with 3 more back ticks on a new line. It makes for a bit better aesthetics.

```sql
SELECT
pdat.fname,
pdat.lname,
pc.pc_pid,
pdat.DOB,
pc.pc_eventDate,
pc.pc_startTime,
pc.pc_endTime,
pc.pc_apptstatus,
pc.pc_title,
pc.pc_room,
pc.pc_hometext,
CONCAT(u.fname, ’ ', u.mname, ’ ', u.lname) as Provider,
insdat.type AS Ins ,
ic.name AS Carrier,
insdat.plan_name AS Program,
insdat.policy_number AS PolNr,
pdat.procode AS Class
FROM
insurance_data insdat
inner join patient_data pdat on insdat.pid = pdat.pid
inner join insurance_companies ic ON ic.id = insdat.provider
LEFT JOIN
openemr_postcalendar_events pc ON pdat.pid = pc.pc_pid
LEFT JOIN users u ON u.id = pc.pc_aid
WHERE pc.pc_eventDate = ‘2022-10-10’
ORDER BY pc.pc_startTime ASC;

```