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

Mel vomit in Patient Banner, please help

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

11 Posts

3 Users

0 Reactions

83 Views

RSS

TheDaver

(@thedaver)

Posts: 9

Active Member

Topic starter

Hello all,

I have some Mel code in a patient banner that displays the patients next appointment and who it is with. For a very few patients, it breaks, and I don't know why. Here is my code.

{if match(APPT_NEXT(), ":") > 0 then arr=getfield(APPT_NEXT(),",","")
arr[1]+","+arr[2]+arr[5]+","+sub(arr[6],1,2)+"."
else
"None"
endif}

It seems to be breaking for patients whose next appointment is a nurse visit, so there is no doctor assigned. How would I modify this to not break if there isn't a doctor resource assigned to the appointment?

Thank you.

Posted : May 21, 2019 3:30 am

SLHV

(@slhv)

Posts: 478

Honorable Member

I'm not very familiar with the array format, so I'd have to look up what you're putting in the arr variable or what arr 1, 2, 5, and 6 are. That won't stop my first guess though.

First thought is a special character issue in a field. Does the nurse's name happen to have a special character like an apostrophe or space? Does one of your fields contain a leading or trailing space that isn't obvious?

-dp

Posted : May 21, 2019 4:32 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

The 5th and 6th fields in APPT_NEXT are not documented within GE Help (or at least my site).

Because of what you are saying, I am wondering if you are not getting all 6 fields every time. What happens if you create a quicktext (simple to test) that does something like:

{APPTS_BY_STATUS("scheduled","FULL")} and execute the QT when in that patient chart?

I wonder if you will see all six fields for every entry.

Posted : May 21, 2019 4:41 am

TheDaver

(@thedaver)

Posts: 9

Active Member

Topic starter

Thank you for the reply. There aren't any special characters or leading/trailing spaces. There is a space in the middle though, "Cascade Nurse"

Posted : May 21, 2019 5:21 am

TheDaver

(@thedaver)

Posts: 9

Active Member

Topic starter

Thank you for your reply. I entered that quick text into a form on the patients chart, and it populated the patients upcoming appointments, including the nurse visit with no doctor. Here is what the output is:

05/22/2019, 9:30 AM, MAT-Work in, Cascade Center, Cascade Nurse
05/23/2019, 3:00 PM, MAT New Pt Eval/Admit - 60, Cascade Center, Crawford CSWA, Lisa
05/28/2019, 3:30 PM, Physical, SouthRiver Community Health Center, Russell PA, Jonathan F

Posted : May 21, 2019 5:26 am

TheDaver

(@thedaver)

Posts: 9

Active Member

Topic starter

Ok, so it looks like it's breaking when there isn't a value in array position 6. I'm new to MEL, so I'm having a hard time figuring out how to check for an empty array value, so it doesn't break the banner.

Posted : May 21, 2019 6:04 am

SLHV

(@slhv)

Posts: 478

Honorable Member

In your first line (5/22/19 @ 9:30am) there are only 5 fields.

Could it be a problem with referencing arr[6] when it is null?

-dp

Posted : May 21, 2019 6:04 am

TheDaver

(@thedaver)

Posts: 9

Active Member

Topic starter

That's what it looks like. I'm fairly new to MEL, how do I code against that?

Posted : May 21, 2019 6:17 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

To determine the number of elements in your array, take a look at the SIZE command, and the 2nd example below (from HELP files)

description

Returns the size of its argument.

type

MEL utility function

syntax

size(value)

arguments

value

A string or array to get the size of.

returns

A long which is the size of the string or array

example 1

{global x = "hello"

size(x)

returns

example 2

global x = array(1,2,3)

size(x)

returns

Posted : May 21, 2019 6:30 am

TheDaver

(@thedaver)

Posts: 9

Active Member

Topic starter

So I could check if the array size is 5 or 6, and create separate banners based on each total, is that the idea?

Posted : May 21, 2019 6:59 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Yes, checking the array size would be one approach.

Posted : May 21, 2019 7:01 am

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