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

How to get all orders to display with date

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

92 Views

RSS

cmahon

(@cmahon)

Posts: 111

Estimable Member

Topic starter

Hello,

Is there a way to display all of the orders in a patients chart, with the date that the order was signed, the status of the order and if possible the provider who signed it? The more information the better.

Any help is much appreciated 🙂
Thank you in advance!

Posted : December 10, 2015 6:44 am

drobinson

(@drobinson)

Posts: 41

Eminent Member

{ORDERS_AFTER("delimited")} will give you all information of current active orders. You would then have to use it in a function to parse through the data and format the data to what you want to display. It will not give you information or data on already completed orders however.

Posted : December 10, 2015 7:32 am

cmahon

(@cmahon)

Posts: 111

Estimable Member

Topic starter

Thank you Dan! Tried this and it works great! Do you have any examples of functions that format this data? I am getting a lot of MEL vomit working with this part.

Posted : December 10, 2015 12:27 pm

chaddix

(@chaddix)

Posts: 177

Estimable Member

Hi Courtney,

Here is a function we use that will return a comma-delimited list of Referrals and populate a document variable named DOCUMENT.REFERRAL_LIST. It's pretty basic, but you should be able to customize it to whatever you need.

{
!DOCUMENT.REFERRAL_LIST = getReferralOrders(ORDERS_AFTER("delimited", "R"))
}

!fn getReferralOrders(o)
{
local retStr = ""
local oArr
local oArrPlus

cond
case o == "": /*Do Nothing*/
case match(o, 1, "|") == 0:
oArr = getfield(o, "^", "")
retStr = oArr[25] + ": " + replacestr(oArr[1], ",", "")
if oArr[13] <> "" then
retStr = retStr + ". " + replacestr(oArr[13], ",", "")
endif
else:
oArrPlus = getfield(o, "|", "")
for x = 1, x <= size(oArrPlus), x = x + 1 do
oArr = getfield(oArrPlus[x], "^", "")
if retStr <> "" then retStr = retStr + "," endif
retStr = retStr + oArr[25] + ": " + replacestr(oArr[1], ",", "")
if oArr[13] <> "" then retStr = retStr + ". " + replacestr(oArr[13], ",", "") endif
endfor
endcond

return retStr
}

Posted : December 11, 2015 8:29 am

cmahon

(@cmahon)

Posts: 111

Estimable Member

Topic starter

Thank you!! That is pretty much exactly what I need to work off of!

Posted : December 11, 2015 9:35 am

cmahon

(@cmahon)

Posts: 111

Estimable Member

Topic starter

Hi, is there anyway to code for only seeing the orders that were placed in the last 6 months and of those, only the orders that are In Process? Each time I try to code this it doesn't come out exactly right. Much appreciated!

Posted : January 27, 2016 3:56 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