Notifications
Clear all
Topic starter
Does anyone know how to pull a flowsheet into Crystal?
THANKS!!!
Posted : November 19, 2013 12:05 am
Are you referring to getting the data from the screren: Settings -> Chart -> Flowsheet views -> Change??
If so that was exactly what I was trying to do this week. I managed to find the related tables but the problem is how the data is stored.
The sql query I came up with (which doesn't work)
SELECT OBSHEAD.NAME, OBSHEAD.DESCRIPTION
FROM OBSHEAD WHERE TO_CHAR(OBSHEAD.HDID) IN
(SELECT TEXT from HIEROBJS where OBJECTID = 1655728761756170)
The problem is that HEIROBJS.TEXT is a CLOB field and not a varchar or integer. The field
consists of HDID values separated by commas. It is possible that the above query or something
like it would possible work on a smaller dataset than the particular text field I was trying to pull
which was 3500 entries consisting of 32000 characters in the field. The person who was asking
for the data ended up taking groups of screenshots of all 3500 entries.
Posted : November 19, 2013 7:39 am
Topic starter
We are trying to use FLOWSHEET VIEWS to pull it into a report to view a custom flowsheet within the report....
Not sure how else to do this other than using a sub report maybe within the main report and pulling in the obs terms we want in a cross-tab format?
Do you know the best way to pull i n a cross tab report?
Posted : November 21, 2013 3:04 am
Faerie_Autumn said:
We are trying to use FLOWSHEET VIEWS to pull it into a report to view a custom flowsheet within the report....
Not sure how else to do this other than using a sub report maybe within the main report and pulling in the obs terms we want in a cross-tab format?
Do you know the best way to pull i n a cross tab report?
I just stumbled across a solution to my problem and I think it might help you.
The list of Flowsheets is in HIEROBJS. The Relevant fields HIEROBJS.NAME and HIEROBJS.OBJECTID.
If you want a report of the name and description of all of the obs terms in a flowsheet you can use a query like this:
SELECT OBSHEAD.NAME, OBSHEAD.DESCRIPTION FROM OBSHEAD WHERE OBSHEAD.HDID IN (SELECT HDID from LINKLOGIC_EXPORT_FLOWSHEET where OBJECTID = 1655728761756170)
If you actually want to report on the value of the obs terms from the flowsheet in patient records, use the view called FLOWSHEET_OBSERVATION. It has a column called flowsheetid which is the OBJECTID from HIEROBJS. If you just pull it on a particular flowsheetid you will probably get way too much info.
Posted : November 26, 2013 2:02 am
Topic starter
I will try this out and see what happens!
You don't happen to have a problems, meds, allergies report by patient do you? If so, could you share?
THANKS!
Posted : November 27, 2013 12:37 am
No I don't. Sorry.
Posted : November 27, 2013 1:48 am
