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

List prescription data

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

4 Users

0 Reactions

66 Views

RSS

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Topic starter

Working on a project, and would like to be able to display prescription data (in a form being built using VFE). I see the LISTRXNEWFULL, which is close to what I want, except:

(1) Want to be able to do something to get a delimited list, so I can control display to only a few fields

(2) Be able to do for all prescriptions for all active medications. Perhaps like the IMMUN_GETLIST allows for stipulating a class or group.

Are there any MEL commands people know of that might set me along a good path?

Thanks.

Posted : March 11, 2016 6:58 am

virtualHITman

(@virtualhitman)

Posts: 319

Reputable Member

Joseph,

There is currently no MEL function that I am aware of that will accomplish what you are after. However, this would be a welcomed addition. Ultimately I wish GE would provide a MEL function where you could pass a SQL query string against the database and have it return the results in a pipe delimited ("|") list. This would solve a whole host of limitations with some of the current MEL functions. Can I get an AMEN! 🙂

If anyone monitoring this thread agrees, please vote this comment up.

Posted : March 11, 2016 7:27 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

HybridFax has built a program that can connect you via MEL code to the Database. You pass in a SQL query and it gives you the results. You can buy the whole faxing solution, or just the engine that interfaces with the SQL database. Shoot them an email if you are interested.

Posted : March 11, 2016 7:50 am

virtualHITman

(@virtualhitman)

Posts: 319

Reputable Member

Thanks Daniel, I'll be sure to check that out!

Posted : March 11, 2016 8:40 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

If you are interested in the SQL interface, contact me at [email protected].

Posted : March 11, 2016 9:10 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 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