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

simply if statement help

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

4 Posts

4 Users

0 Reactions

64 Views

RSS

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

Not sure what i got wrong here but here it is:

{if OBSNOW("ORD PROVIDER") = "Semer MD" then
OBSNOW("CLINPROVOTHR") = "111"
else if OBSNOW("ORD PROVIDER") = "White MD" then
OBSNOW("CLINPROVOTHR") = "222"
else if OBSNOW("ORD PROVIDER") = "Lee MD" then
OBSNOW("CLINPROVOTHR") = "333"
else if OBSNOW("ORD PROVIDER") = "Picton MD" then
OBSNOW("CLINPROVOTHR") = "444"
else if OBSNOW("ORD PROVIDER") = "Herdman PA-C" then
OBSNOW("CLINPROVOTHR") = "555"
endif endif endif endif endif}

So the selection from a dropdown (OBSNOW("ORD PROVIDER")) should show OBSNOW("CLINPROVOTHR") in a data display but it doesn't. Although the text translation is working for the data display is doesn't appear in the form nor on the clinical list changes. Any help is greatly appreciated, thanks!

Posted : July 24, 2015 9:20 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

Maybe this:

{If OBSNOW(“ORD PROVIDER”) == “Semer MD” then
OBSNOW(“CLINPROVOTHR”,"111")
else if OBSNOW(“ORD PROVIDER”) == “White MD” then
OBSNOW(“CLINPROVOTHR”,"222")
else if OBSNOW(“ORD PROVIDER”) == “Lee MD” then
OBSNOW(“CLINPROVOTHR”,"333")
else if OBSNOW(“ORD PROVIDER”) == “Picton MD” then
OBSNOW(“CLINPROVOTHR”,"444")
else if OBSNOW(“ORD PROVIDER”) == “Herdman PA-C” then
OBSNOW(“CLINPROVOTHR”,"555")
endif endif endif endif endif}

You want to do OBSNOW("TERM","VALUE") for assignment. And this for checking values: OBSNOW("TERM") == VALUE . I mix those up sometimes. Also generally if you aren't assigning a value you want to use the double equal sign -- although MEL seems to be relatively passive about that.

Hopefully that helps. Those are the only two things that jumped out at me.

Brad

Posted : July 24, 2015 9:29 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Yup. Agree with your comments about "==". Well put, bhoover.

Posted : July 24, 2015 1:39 pm

mond08

(@mond08)

Posts: 74

Estimable Member

It is very true. I have seen forms run just as designed while "=" is being used instead of "==", when doing a comparison.
Dave

Posted : July 27, 2015 2:07 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