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

USEROK issues

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

2 Users

0 Reactions

71 Views

RSS

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

I want to get something like the following USEROK script to work in a text component. It's important that a pop-up doesn't occur if the patient has a GFR <15 and a Dx of N18.5 OR a GFR <15 and a Dx of N18.6.

The problem I am having is my condition fires even when no GFR value is present. It also doesn't matter if I have one of the diags in the problem list. Hope someone can help.

{

cond

case str(LASTOBSVALUE("GFR")) < 15 AND str(LASTOBSVALUE("GFR")) > 0 AND match(PROB_AFTER(""),"ICD10-N18.5")=0 or
str(LASTOBSVALUE("GFR")) < 15 AND str(LASTOBSVALUE("GFR")) > 0 AND match(PROB_AFTER(""),"ICD10-N18.6")=0
USEROK("Your patient's last GFR was <15, and a diagnoses of ICD10-N18.5 or ICD10-N18.6 is missing from the problem list. To remove this reminder, update the patient's problem list with ICD10-N18.5 or N18.6 if on dialysis.")

else ""

endcond
}

Posted : July 6, 2017 2:13 am

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

You need more parenthesis I think, and you don't want a string, you want to compare a value to either 0 or 15, try this -

case (

(LASTOBSVALUE(“GFR”) < 15 AND LASTOBSVALUE(“GFR”) > 0 AND match(PROB_AFTER(“delimited”),”ICD10-N18.5″)=0)

or
(LASTOBSVALUE(“GFR”) < 15 AND LASTOBSVALUE(“GFR”)> 0 AND match(PROB_AFTER(“delimited”),”ICD10-N18.6″)=0)

)

If there are still issues try val(LASTOBSVALUE("GFR")) > 0 etc...

Posted : July 6, 2017 3:28 am

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

Thank you for the response!

I got the following to work in a text component. I switched to an "if then else" statement because I figure providers will want to just go straight to the problem list to stop the pop-up from coming back, right away. My issue now is that it returns FALSE, in the text translation if the statement is not true.
{

if LASTOBSVALUE("GFR") < 60 AND LASTOBSVALUE("GFR") >= 30 AND match(PROB_AFTER(""),"ICD10-N18.3")=0

then if USERyesNO("Your patient's last GFR was <60 and >=30, and the diagnoses ICD10-N18.3 is missing from the problem list. To remove this reminder, update the patient's problem list with ICD10-N18.3") = "Yes"

then UPDATE_PROBLEMS()

else ""

endif
endif
}

{

if LASTOBSVALUE("GFR") < 30 AND LASTOBSVALUE("GFR") >= 15 AND match(PROB_AFTER(""),"ICD10-N18.4")=0

then if USERyesNO("Your patient's last GFR was <30 and >=15, and the diagnoses CKD stage 4 is missing from the problem list. To remove this reminder, update the patient's problem list.") = "Yes"

then UPDATE_PROBLEMS()

else ""

endif
endif
}

{
if
(
LASTOBSVALUE("GFR") < 15
AND LASTOBSVALUE("GFR") > 0
AND match(PROB_AFTER(""),"ICD10-N18.5")=0
AND match(PROB_AFTER(""),"ICD10-N18.6")=0
)

then if USERYESNO("Your patient's last GFR was <15, and a diagnoses CKD stage 5 or ESRD is missing from the problem list. To remove this reminder, update the patient's problem list.") = "Yes" then UPDATE_PROBLEMS()

else ""

endif
endif
}

Posted : July 6, 2017 10:44 am

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

you just need one more else "" at the end, so the end should be -

endif

else ""

endif

}

Posted : July 7, 2017 12:18 am

rspartos

(@rspartos)

Posts: 85

Estimable Member

Topic starter

Thanks so much!! thought I needed an extra `else""`, but I originally added it right after the other `else""` and killed the expression, causing mel garble where the `FALSE` was before.

Here's the corrected, workable version of the expressions I am using in a text component. Thanks again!

{

if LASTOBSVALUE("GFR") < 60 AND LASTOBSVALUE("GFR") >= 30 AND match(PROB_AFTER(""),"ICD10-N18.3")=0
then if USERyesNO("Your patient's last GFR was <60 and >=30, and the diagnoses CKD stage 3 is missing from the problem list. To remove this reminder, update the patient's problem list.") = "Yes"

then UPDATE_PROBLEMS()

else ""

endif

else ""

endif
}

{

if LASTOBSVALUE("GFR") < 30 AND LASTOBSVALUE("GFR") >= 15 AND match(PROB_AFTER(""),"ICD10-N18.4")=0
then if USERyesNO("Your patient's last GFR was <30 and >=15, and the diagnoses CKD stage 4 is missing from the problem list. To remove this reminder, update the patient's problem list.") = "Yes"

then UPDATE_PROBLEMS()

else ""

endif

else ""

endif
}

{
if
(
LASTOBSVALUE("GFR") < 15
AND LASTOBSVALUE("GFR") > 0
AND match(PROB_AFTER(""),"ICD10-N18.5")=0
AND match(PROB_AFTER(""),"ICD10-N18.6")=0
)

else ""

endif

else ""

endif
}

Posted : July 7, 2017 5:57 am

24 Forums
9,940 Topics
39.9 K Posts
11 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