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

building an (obsterm) function

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

8 Posts

4 Users

0 Reactions

70 Views

RSS

Scott Forest

(@sforest)

Posts: 527

Honorable Member

Topic starter

ok, so I tried to build a function that would take care of multiple cases so I don't have it written out everywhere but when I change everything to (obsterm) instead of say ("Chief Cmplnt") it doesn't work anymore. Here is the function:

fnrecent(obsterm)

{ if DURATIONDAYS(last_signed_obs_date(obsterm),STR(._TODAYSDATE)) <=2 AND OBSNOW(obsterm) == "" THEN OBSNOW(obsterm,OBSPREV(obsterm)) ELSE "" ENDIF }

now if instead of building the function, I just put the obsterm in, it works

{ if DURATIONDAYS(last_signed_obs_date("Chief Cmplnt"),STR(._TODAYSDATE)) <=2 AND OBSNOW("Chief Cmplnt") == "" THEN OBSNOW("Chief Cmplnt",OBSPREV("Chief Cmplnt")) ELSE "" ENDIF }

thoughts?

Posted : July 3, 2017 8:19 am

hermes

(@hermes)

Posts: 32

Eminent Member

Based upon your code, have you actually defined this function with the keyword "fn" then the name of your function? Your function should look like this:

fn fnrecent(obsterm){
if DURATIONDAYS(last_signed_obs_date(obsterm),STR(._TODAYSDATE)) <=2 AND OBSNOW(obsterm) == ""
THEN OBSNOW(obsterm,OBSPREV(obsterm))
ELSE ""
ENDIF
}

then invoke this function by calling it:

fnrecent("CHIEF COMPLNT")

Posted : July 3, 2017 8:43 am

Scott Forest

(@sforest)

Posts: 527

Honorable Member

Topic starter

doesn't work... I am so frustrated...

Posted : July 3, 2017 9:20 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

You code looks correct as long as you are calling the function with the observation name in double quotes. Also, observations are usually in all uppercase, at least on my system, and your example is mixed case.

If it is not working still, delete any existing MEL trace file on your PC and turn on mel tracing (CTRL-ALT-M). Trigger the function to run, open the mel trace file and then Seach for the word "error" in it and paste the lines before/after it here.

Posted : July 3, 2017 12:46 pm

Scott Forest

(@sforest)

Posts: 527

Honorable Member

Topic starter

good call. I did a mel trace after pulling the form apart and found that

>{!fnrecent("InjurySustnd")} execute>call FNRECENT("InjurySustnd") >{fn fnrecent(obsterm)\par \{\par if DURATIONDAYS(last_signed_obs_date(OBSTERM),._TODAYSDATE) call LAST_SIGNED_OBS_DATE("InjurySustnd") results>"07/06/2017" execute>call DURATIONDAYS("07/06/2017", 07/06/2017) results>ERROR: 32783 INVALID OPERATION OR BAD SYMBOL TYPE: DURATIONDAYS ERROR: 32783 INVALID OPERATION OR BAD SYMBOL TYPE: DURATIONDAYS

any thoughts? Does it not like the quotes around the date?

Posted : July 6, 2017 2:46 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

The mel output shows that you are missing your str() on the second half of the function. Is that the case?
It should look likeSTR(._TODAYSDATE)

I think the issue is that one of your dates is a string and the other is a date. DURATIONDAYS() is looking for strings.

EDIT: Just saw your question at the end of your comment. It requires the quotes around the date because the date needs to be a string.

Posted : July 6, 2017 2:54 am

Scott Forest

(@sforest)

Posts: 527

Honorable Member

Topic starter

what the... how the... ugh... it was there when I first wrote it...

Posted : July 7, 2017 7:18 am

chrishuff1

(@chrishuff1)

Posts: 201

Reputable Member

This.

Posted : July 10, 2017 12:35 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