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

Visibility based off an order

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

8 Posts

6 Users

0 Reactions

69 Views

RSS

tosh

(@tosh)

Posts: 51

Trusted Member

Topic starter

Hello,

I was wondering if there is a way write a code that will check when the last time an order was made within 24 months. And display information depending on if it is true or not.

Can this be done?

Thanks!

Posted : January 31, 2017 10:33 am

virtualHITman

(@virtualhitman)

Posts: 319

Reputable Member

The short answer is yes, but it would require some coding. You will probably want to use the ORDERS_ALL() function and then parse through the orders and store the appropriate parameters into variables (e.g. order status and start date of order) so you can identify the order you are looking for in particular and record when it was completed. Use DURATIONDAYS() function to determine if order was completed within past 24 months (i.e. 730 days). If order was performed multiple times, you could use an array or sorting algorithm to pick the most recent one. Your output to the user could be a popup box or a data display. I have used these functions extensively to create a summary of clinical recommendations for our providers.

Posted : January 31, 2017 11:43 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Be glad to furnish you a code example, follows suggestions above.

Posted : January 31, 2017 11:54 am

tosh

(@tosh)

Posts: 51

Trusted Member

Topic starter

Thank you so much, I know where to start now.

I appreciate your help!

Tosh

Posted : January 31, 2017 12:13 pm

bhoover

(@bhoover)

Posts: 360

Honorable Member

One other thing to note. You might want to pull ORDERS_ALL() into a variable and then use that in your visibility regions, particularly if you are stacking several on top of each other to show one versus another. I have had some performance issues when using ORDERS_ALL(), PROB_AFTER(), etc in visibility regions that way.

Posted : February 1, 2017 12:33 am

Lee

(@lee-cooper)

Posts: 348

Reputable Member

Be certain to use break in your loop after finding the order. ORDERS_ALL returns every order on the patient, meaning if a patient has been established for a period of time, the loop iteration count can be high. Clock cycles are precious in the EMR and we rarely are afforded an opportunity to manage them, so 'carpe break' when you can! 🙂

Posted : February 1, 2017 3:10 am

cliffstark

(@cliffstark)

Posts: 194

Reputable Member

I'd like to say, VirtualHITman (Greg) was able to assist with this issue and even offered(performed) offline assistance to help with changing colors of a data display based off an order array. He worked on it over a weekend and sent me the fix. Definitely a lifesaver!!! Thank you!

Posted : July 16, 2018 3:26 am

virtualHITman

(@virtualhitman)

Posts: 319

Reputable Member

Thanks Cliff. Glad everything worked out for you!

Posted : July 16, 2018 4:57 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