Medical Condition/Problem Report

[Hersheydmd]

Does anyone have a way to get a report from OD of all patients with a listed medical condition? eg. high blood pressure?

[Hersheydmd]

It's amazing how much necessity is the mother of invention.

Since I didn't get any help, I figured it out myself.
I did a query to find out what num High Blood Pressure is in my database:

SELECT * From Diseasedef

I found out it is #24.
So then I did a query:
SELECT PatNum, DiseaseDefNum, datetstamp From Disease Where DiseaseDefNum = 24

returned a list of all patients with high blood pressure [and the date it was entered - as long as you haven't updated OD since then].
[Note: I just found out that the datetstamp is of no consequence, as it gets updated whenever you upgrade to a newer version. Too bad, because it would have been nice to know when each medical condition was entered in OD]

[jordansparks]

Newer versions of that table have DateStart and DateStop. Are those the dates you were asking for? I don't think it's quite as important when it was entered.

[Hersheydmd]

Newer versions of that table have DateStart and DateStop. Are those the dates you were asking for? I don't think it's quite as important when it was entered.

That will work too.