SELECT hin as 'Health#',
demographic_no as 'Demographic#',
last_name as 'Last Name',
first_name as 'First Name',
{location}
FROM eChart, demographic
WHERE demographicNo=demographic_no
{status}
&& ({location} LIKE '%{search}%'
{searchOption2}
{searchOption3}
{searchOption4}
{searchOption5}
{searchOption6}
)
&& demographic_no NOT IN (
SELECT demographic_no
FROM dxresearch
WHERE dxresearch.status='A'
&& dxresearch_code IN (
select dxResearchCode
FROM quickList
WHERE quickListName='{register}'
)
)
GROUP BY demographicNo
ORDER BY demographic.last_name, demographic.first_name;
Ignore
AND LIKE
( AND LIKE
AND LIKE )
OR LIKE
( OR LIKE
OR LIKE )
AND NOT LIKE
( AND NOT LIKE
AND NOT LIKE )
OR NOT LIKE
( OR NOT LIKE
OR NOT LIKE )
Ignore
AND LIKE
( AND LIKE
AND LIKE )
OR LIKE
( OR LIKE
OR LIKE )
AND NOT LIKE
( AND NOT LIKE
AND NOT LIKE )
OR NOT LIKE
( OR NOT LIKE
OR NOT LIKE )
Ignore
AND LIKE
( AND LIKE
AND LIKE )
OR LIKE
( OR LIKE
OR LIKE )
AND NOT LIKE
( AND NOT LIKE
AND NOT LIKE )
OR NOT LIKE
( OR NOT LIKE
OR NOT LIKE )
Ignore
AND LIKE
( AND LIKE
AND LIKE )
OR LIKE
( OR LIKE
OR LIKE )
AND NOT LIKE
( AND NOT LIKE
AND NOT LIKE )
OR NOT LIKE
( OR NOT LIKE
OR NOT LIKE )
Ignore
AND LIKE
( AND LIKE
AND LIKE )
OR LIKE
( OR LIKE
OR LIKE )
AND NOT LIKE
( AND NOT LIKE
AND NOT LIKE )
OR NOT LIKE
( OR NOT LIKE
OR NOT LIKE )
CPP Medical History
CPP Social History
CPP Family History
CPP Ongoing Concerns
CPP Allergies
Encounters
Active patients
Active and suspended patients
Inactive patients
All patients
select quickListName, quickListName from quickList group by quickListName order by quickListName;