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

using less than/greater than/ between?

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

64 Views

RSS

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

So I've been successful using less than and greater than, but I need help with between values. For example:

{if OBSNOW("HGBA1C") < val("6.9") then "3044F" else if OBSNOW("HGBA1C") > val("9.1") then "3046F" else if OBSNOW("HGBA1C") > val("6.9") and < val("9.1") then "3044F" "" endif endif endif}

Of course this piece: ...if OBSNOW("HGBA1C") > val("6.9") and < val("9.1") then "3044F" "" endif... doesn't work.

Any ideas?

Thanks in advance!

Posted : October 13, 2015 4:57 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

Wow, second cup of coffee and I found my issue:

{if OBSNOW("HGBA1C") < val("6.9") then "3044F" else if OBSNOW("HGBA1C") > val("9.0") then "3046F" else if OBSNOW("HGBA1C") > val("6.9") and OBSNOW("HGBA1C") < val("9.1") then "3045F" endif endif endif}

Posted : October 13, 2015 5:42 am

Lee

(@lee-cooper)

Posts: 348

Reputable Member

While it is a matter of style, for readability and efficiency, you might want to use condition statements for this type of evaluation.

cond
case OBSNOW("HGBA1C") < 6.9 "3044F"
case OBSNOW("HGBA1C") > 9.0 "3046F"
case OBSNOW("HGBA1C") > 6.9 and OBSNOW("HGBA1C") < 9.1 "3045F"
else ""
endcond

Mostly it is cleaner, easier to work with, and you don't have to count if/endif pairs. 🙂

Posted : October 14, 2015 4:07 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

Thank you! I guess I've steered clear of cond case simply because I'm not comfortable with them, but this definitely cleans it up better and gives me something to work with in the future.

Posted : October 14, 2015 4:20 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

Just a quick question: Are you deliberately trying to exclude 6.9 from being translated into a code?

I ask because I see that you changed one of your 9.1 values to 9.0, so that you can have all values in the range >9.0 and <9.1, but you are still using >6.9 and <6.9 what happens if your value is equal to 6.9?

Posted : November 6, 2015 8:45 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

I overlooked this, thanks!

Posted : November 6, 2015 9:04 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