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

show last scheduled physical

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

4 Posts

2 Users

0 Reactions

87 Views

RSS

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

I'm hoping someone has some insight...

I'm trying to tweak this statement so it shows me the last physical the patient arrived to and/or is scheduled for.

so, if I put it in a letter the result displays something like:

09/23/2016, 7:30 PM, PHYSICAL EXAM NEW PT, Family Doctors, LLC, Smith MD, Joseph

I feel like I am on the right track but maybe I'm thinking too hard about it? I know the below statement will only return some numbers greater than '0' but maybe theres a get function or find function or something? Thanks in advance!!
{
if match(tolower(APPTS_BY_STATUS('arrived','FULL')),'physical')>0
then match(tolower(APPTS_BY_STATUS('arrived','FULL')),'physical')
else if match( tolower(APPTS_BY_STATUS('arrived','FULL')),'well') >0
then match(tolower(APPTS_BY_STATUS('arrived','FULL')),'well')

else if match(tolower(APPTS_BY_STATUS('scheduled','FULL')),'well') >0
then match(tolower(APPTS_BY_STATUS('scheduled','FULL')),'well') >0
else if match(tolower(APPTS_BY_STATUS('arrived','FULL')),'physical') >0
then match(tolower(APPTS_BY_STATUS('arrived','FULL')),'physical') >0
else "<NO PHYSICAL ON FILE>"
endif
endif
endif
endif
}

Posted : October 12, 2016 8:24 am

chaddix

(@chaddix)

Posts: 177

Estimable Member

A few thoughts...

1. I would recommend a COND/CASE statement instead of a nested IF/ELSE, as it will make it much easier to read and/or make changes to in the future.

2. When your IF statements are evaluating to TRUE, you are returning a MATCH statement, which will only display an integer, and not the full string of text you are looking for. The integer returned will be the character number in the string you are evaluating. Ex: MATCH("The sky is blue", 1, "blue") will return 12.

3. MEL statements are case-sensitive, so if your appointment type is "Physical" instead of "physical", nothing will be returned.

Posted : October 20, 2016 2:13 am

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

Hi, Thanks for the pointers regarding cond/case. I'll definitely apply...

The statement isn't missing any appointments because of the tolower() function. so, it's matching with anything that contains "physical".

And as you said, the match only returns an integer. Do you know or have an idea of a statement that would return any string that contains "physical"?

Thanks again!

Posted : October 20, 2016 2:29 am

chaddix

(@chaddix)

Posts: 177

Estimable Member

APPTS_BY_STATUS returns a giant string of every appointment that matches the parameters. These appointments are separated by a delimiting character...in the case of APPTS_BY_STATUS, it's a hard return.

So...from a VERY high level, what you're going to want to do is...

1. Bring the results of APPTS_BY_STATUS into a string.

2. Split this string into an array by using the GETFIELD function. Ex: apptArrayOV1 = getfield(APPTS_BY_STATUS("Confirmed", "FULL"), "\r", "")

3. Loop through this array...when you go through an element, use the COND/CASE + MATCH function to check for the appointment type and determine if this particular appointment should be included. If something in your COND/CASE evaluates to TRUE, then you can print this into your return string.

I would write it as a function and then call that function from your form/letter template. It's actually somewhat complicated...I recommend doing a MEL Trace to watch what's happening in this function. We've gotten this to work, but it takes some effort.

Perhaps someone has an easier method, but that's how we accomplish this task.

Posted : October 20, 2016 2:43 am

Share:

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

Powered by wpForo Powered by wpForo version 2.4.0