Notifications
Clear all
Topic starter
Is it possible to report on the text in handouts? A co-worker had changed the title from - Clinical Visit Summary. All I am able to report is from the document summary which lists 'Handout Printed', but text to identify the handout printed. The query I used is below -
SELECT DISTINCT
PatientProfile.searchname, AUDIT_EVENT_DETAIL.EVENT_VALUE_1, AUDIT_EVENT_DETAIL.EVENT_VALUE_2,
dbo.Convert_ID_to_date([DOCUMENT].CLINICALDATE) AS clinicaldate, [DOCUMENT].SUMMARY
FROM AUDIT_EVENT INNER JOIN
PatientProfile ON AUDIT_EVENT.PID = PatientProfile.PId INNER JOIN
[DOCUMENT] ON AUDIT_EVENT.SDID = [DOCUMENT].SDID INNER JOIN
AUDIT_EVENT_DETAIL ON AUDIT_EVENT.EVENT_ID = AUDIT_EVENT_DETAIL.EVENT_ID
WHERE ([DOCUMENT].SUMMARY = 'Handout Printed') AND (dbo.Convert_ID_to_date([DOCUMENT].CLINICALDATE) BETWEEN '10/20/2012' AND '10/25/2012') AND
(AUDIT_EVENT_DETAIL.EVENT_VALUE_2 = 'Added Text Block')
ORDER BY CLINICALDATE, PatientProfile.searchname,[DOCUMENT].SUMMARY
Adding the obs table doesn't return any additional information.
Thank you in advance.
John
Outside IN
DBA/ Data Analyst
@outsidein.org" rel="nofollow" target="_blank">johnk@outsidein.org
Posted : November 15, 2012 2:20 am
In my report, I had to specify the doctype from DOCUMENT.DOCTYPE based on which doc type you are looking for.
Posted : November 26, 2012 4:10 am
