We are running reports from the Clinical Report and it is returning the same number of results no matter the date range that is chosen. This was reported before in 2013. It is happening again.
@visolveemr Any suggestions.
When I dump the sqlstatement I see this:
select
concat(pd.fname, ' ', pd.lname) AS patient_name,
pd.pid AS patient_id,
DATE_FORMAT(FROM_DAYS(DATEDIFF(NOW(),pd.dob)), '%Y')+0 AS patient_age,
pd.sex AS patient_sex,
pd.race AS patient_race,pd.ethnicity AS patient_ethinic,
concat(u.fname, ' ', u.lname) AS users_provider,
REPLACE(REPLACE(concat_ws(',',IF(pd.hipaa_allowemail = 'YES', 'Allow Email','NO'),IF(pd.hipaa_allowsms = 'YES', 'Allow SMS','NO') , IF(pd.hipaa_mail = 'YES', 'Allow Mail Message','NO') , IF(pd.hipaa_voice = 'YES', 'Allow Voice Message','NO') ), ',NO',''), 'NO,','') as communications from patient_data as pd left outer join users as u on u.id = pd.providerid
left outer join facility as f on f.id = u.facility_id where 1=1 ORDER BY patient_id