Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

docdata query

Trading Post

Last Post by Anonymous 1 second ago

5 Posts

3 Users

0 Reactions

56 Views

RSS

msjannelli

(@msjannelli)

Posts: 22

Eminent Member

Topic starter

I am looking for a query that pulls chart information in readable format. We currently use CEMR 9.8.11

Does docdata.data contain this information?

Posted : May 10, 2017 3:36 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Yes, the docdata file contains the text of the encounter/document. And there can be more than one for an encounter.

I have done this before, with Crystal Reports, to read through say all office visits for a date, and then use an instr() type of function to see if I match on searched for text. Care must be given to the matching logic since certain words may appear for entirely different reasons.

Are you trying to search for a match, or just want to print out the entire note text?

Posted : May 10, 2017 3:50 am

msjannelli

(@msjannelli)

Posts: 22

Eminent Member

Topic starter

I'm just trying to print out the document in the readable format.

Posted : May 10, 2017 3:52 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Doc50 Documents Text Docdata

The above is a Crystal Report that starts the process (it filters to look at yesterday and office visits for patients with last names beginning with A).

When I tested it, I realized (again) that the docdata table includes formatting instructions. To make nicer in printing, you would need to filter these commands out.

Posted : May 10, 2017 4:28 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

If you use Oracle SQL Developer, you can run a query that returns a single document. A very simplified version would look like this:

SELECT DOCDATA.DATA FROM DOCDATA WHERE SDID = 1234567890123456

Make sure you do not put a sort (order by) on the query and then highlight the data column (selecting all values) and copy the values to a notepad window. Save the notepad as FileName.rtf and you should be able to open it in Word/Wordpad.

Most (not all) data in the docdata table is in RTF format and a single document can (and will) get split into multiple rows in the docdata table based on the number of characters in the document. Also of note is the fact that the docdata table will not contain anything if it is OnHold/InProcess.

What is your end goal?

Posted : May 18, 2017 9:15 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0