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

Display only certain orders

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

12 Posts

3 Users

0 Reactions

85 Views

RSS

cmahon

(@cmahon)

Posts: 111

Estimable Member

Topic starter

Is there a way to display in a letter only certain orders that are ordered?

For example if a doctor orders the service order "CPT 23456," is there a way to display that order in a letter, with its start date, order description and authorizing provider? Thanks!

Posted : April 10, 2017 7:04 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

You can look up the ORDERS_ALL for more info on what is available, but you can certainly use it to get certain orders. if you know the specific CPT code, even better!

Put this code in the top of your letter:

{fn getOrder(cptcode){
results = ""
orderArray = getfield(ORDERS_ALL("Delimited"),"|","")
for c = 1, c <= size(orderArray), c = c+1 do
orderArray[c] = getfield(orderArray[c],"^","")
if (orderArray[c][3] == cptcode) then
results = "Details: " + orderArray[c][1] + HRET + "Date: " + orderArray[c][4] + HRET + "Authorizing Provider: " + orderArray[c][21]
endif
endfor
return results
}}

Then, in the letter body where you want this info, put

{getOrder("CPT-23456")}

and as long as the CPT matches the code you typed in, you will get the following:

Details: Colonoscopy Referral
Date: 04/21/2015
Authorizing Provider: Allen Noble PA-C

Please let me know if you have any questions on how this works, or how to tweak it.

Thank you,

Daniel

Posted : April 10, 2017 9:43 am

cmahon

(@cmahon)

Posts: 111

Estimable Member

Topic starter

You are the best!!! Works perfectly, thanks so much!

Posted : April 11, 2017 12:54 am

cmahon

(@cmahon)

Posts: 111

Estimable Member

Topic starter

Hi Dan, I just emailed you but I'm unsure if you got it. Is there a way to manipulate it to look for multiple CPT codes? I'm trying to display the last Physical Orders (CPT 99308, CPT 99309, CPT 99310, etc) Thank you!

Posted : September 27, 2017 3:57 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

Hello Courtney,

I have not received your email, but I saw that you update your post here on CHUG. if you reply to this post, I get an email that the question was updated. so here is my thoughts on getting multiple CPT codes in a letter with this code.

You could modify the code to accept a comma delimited string, or an array of CPT codes, but I would rather do the following in my letter using the already built code I sent you:

{getOrder("CPT-99308")}

{getOrder("CPT-99309")}

{getOrder("CPT-993010")}

you can re-use the code and get as many orders as you want into a single letter. If you are wanting to only show the latest CPT code by date, you would have to do some comparisons, and that would require modifying the code

Posted : September 27, 2017 10:46 am

slightbourne

(@slightbourne)

Posts: 11

Eminent Member

Hi Dan,

Thank you for your responses thus far. I am using your "{fn getOrder(cptcode)" displayed above within a data display.

It works. Yet, I am trying to add multiple CPT codes within the function and have it display the most recent CPT code ordered.

I was able to pull the most recent CPT code based off of 3 CPT codes listed within the data display, yet it is very glitchy.

Code: {getOrder("99383")};{getOrder("99382")};{getOrder("99381")} (THIS WORKS)

If I list 99381 first and 99383 as the last leg in the function, it doesn't show anything in the data display. ex: {getOrder("99381")};{getOrder("99382")};{getOrder("99383")} (WEIRD)

Essentially, I am trying to add a total of 17 CPT codes within 1 data display, showing its most recent CPT code ordered.

Do you have any insight on this?

Thank you so much in advance!

-Shereen

Posted : September 28, 2017 3:41 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

I have not seen this function do that. I will try it out in a letter my I would start by double checking the syntax of your code. I have often found that my code breaking after it works fine is due to my own mistake when changing things. Can you copy the letter you have built so I can test it on my end?

Thank you,

Daniel Carpenter

Posted : September 29, 2017 10:37 am

slightbourne

(@slightbourne)

Posts: 11

Eminent Member

Hi Daniel,

I am using the coding below within a data display oppose to a letter.

MEL expression within the data display:

{getOrder("99383")};{getOrder("99382")};{getOrder("99381")}

Coding in MEL worksheet:

{fn getOrder(cptcode){
results = ""
orderArray = getfield(ORDERS_ALL("delimited"),"|","")
for c = 1, c <= size(orderArray), c = c+1 do
orderArray[c] = getfield(orderArray[c],"^","")
if (orderArray[c][3] == cptcode) then
results = " " + orderArray[c][1] + HRET + ", " + orderArray[c][4] + HRET + ", " + orderArray[c][21]
endif
endfor
return results
}}

This coding return the most recent CPT code, yet it is very glitchy. I have a total of 17 CPT codes to add essentially.

Thank you for all of your help!

-Shereen

Posted : October 2, 2017 1:33 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

Ah I found that on my version of the software, I had to add "CPT-" before my codes, and then they worked normally. so my code looks like this: {getOrder("CPT-99214")} and then it works, otherwise it is blank.

Let's look at the data we are working with. if you make a TEST letter and put the code below in, we can see what the data my function is grabbing looks like.

{ORDERS_ALL("delimited")}

If the patient you run this letter on has the orders in their chart that you are trying to pull, we should be able to see if there is a difference in what the code is expecting, and what it is getting.

Thank you,

Daniel Carpenter

Posted : October 2, 2017 3:49 am

slightbourne

(@slightbourne)

Posts: 11

Eminent Member

Hi Daniel,

This is the coding I put within the letter:

Physical Exam Details:
{getOrder("99386")}
{getOrder("99387")}
{getOrder("99396")}
{getOrder("99397")}
{getOrder("99385")}

{ORDERS_ALL("delimited")}

...And it works in the letter. I just can't get it to work in a data display.

Any other suggestions?!

Thank you again!

Shereen

Posted : October 2, 2017 9:27 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

Oh I'm sorry, I didn't realize it was being used in a data display! sometimes the code from a data display and the code from a letter have to be slightly different to work.

If you have a data display with the connection type set to "MEL Expression", then you have to treat the text box you are typing into as if there is already an opening bracket and a closed bracket around the box. please try this code in the data display:

getOrder("99386") + HRET + getOrder("99387")+ HRET +getOrder("99396")+ HRET +getOrder("99397")+ HRET +getOrder("99385")

This should work in a data display. Make sure to build your function in the function window of the form you are making, or in a library.

Let me know how it goes.

Daniel C.

Posted : October 3, 2017 4:28 am

slightbourne

(@slightbourne)

Posts: 11

Eminent Member

Hi Daniel,

IT WORKED!! Thank you so much. The only thing I removed for the code within the data display was "HRET". I preferred not to have the line break.

I am using this within the MEL worksheet:

{fn getOrder(cptcode){
results = ""
orderArray = getfield(ORDERS_ALL("delimited"),"|","")
for c = 1, c 0 and durationdays(orderArray[c][4], str(._todaysdate)) 0 and durationdays(orderArray[c][4], str(._todaysdate)) < 731

The only problem I have now is that it only displays the most recent order placed. I am trying to list all of the orders within 2 years.

Do you have any insight on this?

-Shereen

Posted : October 9, 2017 7:24 am

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