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

Find() function

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

3 Posts

2 Users

0 Reactions

56 Views

RSS

bhoover

(@bhoover)

Posts: 360

Honorable Member

Topic starter

Can someone provide an example or otherwise explain how the find() function works. I have an old form, I did not develop, I'm trying to modify which uses it. I looked through the help file and found that it talked about getting a value out of an object. Also:

"Objects and their fields are described in text files named MLDEFS*.TXT in the EMR directory."

I didn't find an EMR directory in the CPS 12 installation. Does someone know the path?

Thanks

Posted : March 13, 2015 9:38 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

I used the Find() function early in my programming efforts for Centricity. It is based on using Objects in the MELDEFS*.txt files. Nothing is documented. This requires examining all of the objects to determine if there is one that will retrieve data from tables you are interested in. I stopped using Find(), aside from simply the frustration of locating at appropriate object, when after an upgrade, the Find() stopped functioning.

We thus developed a much more flexible approach to data extraction. A SQL string is constructed to retrieve data from Centricity. The routine is called via RUNTEXTPROCESS() which executes the string against the database, with the results returned as a text string. The SQL string can be as complicated as you want to make it. I presented this at Fall CHUG. If you want more information, contact me.

John W. Fitzgerald, MD

[email protected]

Posted : March 13, 2015 10:07 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

Topic starter

Thank you for the information. I will avoid using it myself. The functionality that was developed in the form I have to modify can be redeveloped using other techniques.

Posted : March 16, 2015 2:30 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