Way to see if all prompts in notes are filled out?

[noestervemb]

Is there a query that will shows if the word "prompt" is in any of the patients notes. Wanting to make sure we get our autonotes fully filled out but i cant find a way to search for the word "prompt" in the patient notes. This would give me a list to make sure all prompts are answered and none are unanswered. The incomplete note report does not give me these even if "" marks are added.

[cmcgehee]

What are you referring to when you say "patient notes"? Are you referring to the appointment-like objects that are placed on the appointment schedule?

[noestervemb]

I am referring to the auto notes i use for patient procedures, chart notes.

[cmcgehee]

This query might work.

/*404 Procedures with key word in note for date range*/
SET @FromDate= '2009-01-01', @ToDate='2010-07-31'; /*change dates here*/
SELECT procedurelog.ProcDate,procedurelog.ProvNum,
CONCAT(patient.LName,', ',patient.FName) AS 'PatientName',
procedurecode.ProcCode,procedurecode.AbbrDesc,
procedurelog.ToothNum, LEFT(n1.Note, 30) AS 'First 30 characters of Note'
FROM procedurelog,patient,procedurecode,procnote n1
WHERE procedurelog.PatNum = patient.PatNum
AND procedurelog.CodeNum = procedurecode.CodeNum
AND procedurelog.ProcStatus = 2
AND procedurelog.ProcDate BETWEEN @FromDate AND @ToDate
AND procedurelog.ProcNum=n1.ProcNum
AND n1.Note LIKE('%prompt%') /*change keyword here*/
AND n1.EntryDateTime=(SELECT MAX(n2.EntryDateTime)
FROM procnote n2
WHERE n1.ProcNum = n2.ProcNum)
ORDER BY procedurelog.ProvNum, procedurelog.ProcDate;