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

Functions / Return process

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

2 Users

0 Reactions

98 Views

RSS

jmazurow

(@jmazurow)

Posts: 86

Estimable Member

Topic starter

Hi. I am wondering why the following will not return the value from the first set of if statements.
If OSWESTRY 1 is populated, say, value 5, the result for score does not populate in the form. However, if I populate OSWESTRY 2 ( second set of statements), then the sum is returned.
Not sure why it won't return a result if just the first term is populated. Any ideas ?
Thanks... John

{!fn fnscore() {

local summ1 = ""
local summ2 = ""
local score = ""

if match(sub(obsnow("OSWESTRY 1"),1,1),"0")>0 then summ1 = "0" else "" endif
if match(sub(obsnow("OSWESTRY 1"),1,1),"1")>0 then summ1 = "1" else "" endif
if match(sub(obsnow("OSWESTRY 1"),1,1),"2")>0 then summ1 = "2" else "" endif
if match(sub(obsnow("OSWESTRY 1"),1,1),"3")>0 then summ1 = "3" else "" endif
if match(sub(obsnow("OSWESTRY 1"),1,1),"4")>0 then summ1 = "4" else "" endif
if match(sub(obsnow("OSWESTRY 1"),1,1),"5")>0 then summ1 = "5" else "" endif
if summ1 "" then score = val(summ1) else score = 0 endif

if match(sub(obsnow("OSWESTRY 2"),1,1),"0")>0 then summ2 = "0" else "" endif
if match(sub(obsnow("OSWESTRY 2"),1,1),"1")>0 then summ2 = "1" else "" endif
if match(sub(obsnow("OSWESTRY 2"),1,1),"2")>0 then summ2 = "2" else "" endif
if match(sub(obsnow("OSWESTRY 2"),1,1),"3")>0 then summ2 = "3" else "" endif
if match(sub(obsnow("OSWESTRY 2"),1,1),"4")>0 then summ2 = "4" else "" endif
if match(sub(obsnow("OSWESTRY 2"),1,1),"5")>0 then summ2 = "5" else "" endif

if summ2 "" then score = score + val(summ2) else "" endif
return score
}}

Posted : March 30, 2015 3:15 am

drobinson

(@drobinson)

Posts: 41

Eminent Member

The last if statements on summ1 and summ2 both show this :

if summ1 "" then

I think you would need to say something like this:

if summ1 <> "" then

I also just noticed all your numbers have a double quote then the number then a single quote ex: "0' You may have to change it to double quote then the number then double quote ex: "0"

Posted : March 30, 2015 3:23 am

jmazurow

(@jmazurow)

Posts: 86

Estimable Member

Topic starter

All quotes seem to be fine.
{!fn fnscore() {
local summ1 = ""
local summ2 = ""
local score = ""

OBSNOW("HEIGHT","33")
if match(sub(obsnow("OSWESTRY 1"),1,1),"0")>0 then summ1 = "0" else "" endif
if match(sub(obsnow("OSWESTRY 1"),1,1),"1")>0 then summ1 = "1" else "" endif
if match(sub(obsnow("OSWESTRY 1"),1,1),"2")>0 then summ1 = "2" else "" endif
if match(sub(obsnow("OSWESTRY 1"),1,1),"3")>0 then summ1 = "3" else "" endif
if match(sub(obsnow("OSWESTRY 1"),1,1),"4")>0 then summ1 = "4" else "" endif
if match(sub(obsnow("OSWESTRY 1"),1,1),"5")>0 then summ1 = "5" else "" endif
if summ1"" then score = val(summ1) else "" endif

score = val(summ1)
if match(sub(obsnow("OSWESTRY 2"),1,1),"0")>0 then summ2 = "0" else "" endif
if match(sub(obsnow("OSWESTRY 2"),1,1),"1")>0 then summ2 = "1" else "" endif
if match(sub(obsnow("OSWESTRY 2"),1,1),"2")>0 then summ2 = "2" else "" endif
if match(sub(obsnow("OSWESTRY 2"),1,1),"3")>0 then summ2 = "3" else "" endif
if match(sub(obsnow("OSWESTRY 2"),1,1),"4")>0 then summ2 = "4" else "" endif
if match(sub(obsnow("OSWESTRY 2"),1,1),"5")>0 then summ2 = "5" else "" endif
if summ2"" then score = score + val(summ2) else "" endif

return score
}}

Still, if I just enter a value for OSWESTRY 1, the score does not show. Very odd.

Posted : April 1, 2015 5:36 am

drobinson

(@drobinson)

Posts: 41

Eminent Member

You still have summ1 "" and summ2 "" at the end on each part of the function:

if summ1"" then score = val(summ1) else "" endif

Replace this with:

if summ1 <> "" then score = val(summ1) else "" endif

Do the same for summ2.

Posted : April 1, 2015 5:43 am

jmazurow

(@jmazurow)

Posts: 86

Estimable Member

Topic starter

There is a not equal to symbol. For some reason, cutting and pasting here did not show it, but it is there.

Posted : April 1, 2015 7:05 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