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

MEL Code To Find Next Most Recent Obs

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

5 Users

0 Reactions

102 Views

RSS

dmishler

(@dmishler)

Posts: 44

Trusted Member

Topic starter

Hi,
I'm trying to write a MEL expression to find the most recent of two obs terms, and then find the next most recent. I think I probably need to put the two obs terms into an array and then compare them... but I'm having trouble putting that into practice.
Has anyone done something similar and can help out?

Thanks!

Posted : April 6, 2015 12:15 pm

Jim Poulos

(@jpoulos)

Posts: 118

Estimable Member

Have you tried using the LIST_OBS() function for each OBS TERM, return the result into an array and then looping through the array for the most recent and the next oldest OBS (i.e., loop at most twice)?

Posted : April 6, 2015 1:04 pm

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

Just FYI, LIST_OBS returns all values for an obsterm, already descending date sorted. So if you only need the 2 most recent values for an obsterm, you only need the first 2 rows returned by LIST_OBS for that obsterm. - Beverly

Posted : April 6, 2015 1:07 pm

joeg1962

(@joeg1962)

Posts: 843

Noble Member

The following code will display the last three BP readings. Perhaps you can use this as a guide.

{local sA1, sA2, a1, a2, s1="", i=0, imax=0 sA1 = getfield(LIST_OBS("BP SYSTOLIC","signed","list","valuedate"),")",HRET) sA2 = getfield(LIST_OBS("BP DIASTOLIC","signed","list","valuedate"),")",HRET) imax = (if size(sA1)<=3, size(sA1), 3) s1="" for i=1,i<=imax,i=i+1 do a1 = getfield(str(sA1[i]),"(","") a2 = getfield(str(sA2[i]),"(","") s1=s1+(if s1<>"",HRET,"")+a1[1]+"(systolic) / "+a2[1]+" (diastolic) ("+a1[2]+")" endfor s1}

Which would create:

120 (systolic) / 80 (diastolic) (02/06/2015 4:31:42 PM) 134 (systolic) / 78 (diastolic) (11/17/2014 3:51:10 PM) 125 (systolic) / 78 (diastolic) (11/17/2014 3:25:39 PM)

Posted : April 8, 2015 3:06 am

afujii

(@afujii)

Posts: 1

New Member

Can anyone help me with this code but using the {APPT_BY_STATUS(“no show”)} function to return the patient's last three no show appointments?

Posted : June 27, 2016 7:48 am

Share:

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