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

Passing and setting variable with MEL function

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

3 Posts

3 Users

0 Reactions

67 Views

RSS

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Topic starter

For those who have been following, I am working on a component to try to build a results letter. One of my my final steps (I hope) is to determine what results are recent. Thus, trying to lookup info on many labs (OBS) and based on the date, set a flag field (as a default) to print the result or not. There is a place where DOCUMENT.LOOKBACK is set by the user to say 10 or 14 (days) to only highlight recent results.

My first attempt was a one line command (it worked) that set the flag (DOCUMENT.DISPLAY_01) based on the rules.

//{if LAST_SIGNED_OBS_VALUE("CHOLESTEROL") = "" then DOCUMENT.DISPLAY_01 = "" else if val(durationdays(str(._TODAYSDATE),LAST_SIGNED_OBS_DATE("CHOLESTEROL"))) > -1 * val(DOCUMENT.LOOKBACK) then DOCUMENT.DISPLAY_01 = "yes" else DOCUMENT.DISPLAY_01 = "" endif endif}

But I want to do as a function to simplify the process.

Thus, the call:

{SetLookback("CHOLESTEROL","DOCUMENT.DISPLAY_01")}

and the defined function on the rightside of the VFE:

{fn SetLookback(FOBS,FDISP) {
if LAST_SIGNED_OBS_VALUE(FOBS) = ""
then FDISP = ""
else if val(durationdays(str(._TODAYSDATE),LAST_SIGNED_OBS_DATE(FOBS))) > -1 * val(DOCUMENT.LOOKBACK)
then FDISP = "yes"
else FDISP = ""
endif
endif}}

Is there something simple I am missing?

TIA.

Posted : May 29, 2018 6:59 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

So here are 2 things that strike me right off the bat that may be causing you issues.

#1. You are passing in a variable to the function ({SetLookback(“CHOLESTEROL”,”DOCUMENT.DISPLAY_01″)}). This will pass the VALUE of DOCMENT.DISPLAY_01. but you cannot update the actual variable. You can pass in the name of the document variable and process it as MEL code using the eval function.

#2. When you use a document variable in a form, it will change the name of the document variable from "DOCUMENT.DISPLAY_01" to a longer, unique name, such as DOCUMENT.DISPLAY_014757y39827365. This prevents multiple forms from stepping on eachothers toes. I have built lots of forms with a DOCUMENT.COMMENTS somewhere in there, and this is how CPS sorts them out.

You can get around this by checking the "Make available to other forms" checkbox in VFE. but I don't have a tested example of fixing problem #1. I may have to play with it a bit and see if I can get a working example with using 'eval'.

Let me know if you have any questions.

Thank you,

Daniel C.

Posted : May 29, 2018 11:59 am

Lee

(@lee-cooper)

Posts: 348

Reputable Member

Daniel alluded to the issue. You are using the text "DOCUMENT.DISPLAY_01" instead of passing the value of DOCUMENT.DISPLAY_01.

It looks like you want to return the results of the function to DOCUMENT.DISPLAY_01, so you would modify the function call to:

{DOCUMENT.DISPLAY_01 = SetLookback(“CHOLESTEROL”)}

I believe that will yield the result you are seeking.

Posted : May 31, 2018 5:34 pm

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