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

Listing last 3 appointments or appointment by location/pcp

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

7 Posts

3 Users

0 Reactions

71 Views

RSS

heggea

(@heggea)

Posts: 52

Trusted Member

Topic starter

I am looking to list the last 3 appointments a patient has had or preferably last appointment with their PCP. The code I am using lists either just the last appointment or all last appointments by status. We are a multispecialty clinic so listing all last appointments is not helpful. Does someone have a code that they are using to do this?

This is the code that I am currently using in a quick text but I am unsure how to pull by PCP or just last 3 visits.

{global alist = getfield(APPTS_BY_STATUS("completed","FULL"),"\r","")
global asz = size(alist)
global tempa
global rslt=""
for count = 1, count < asz, count = count + 1
do
tempa = getfield(alist[count],",","")
days = DURATIONDAYS(str(._TODAYSDATE),tempa[1])
if days<0 then
rslt = rslt + tempa[1] + " at" + tempa[2] + " Type:" + tempa[3] + " with" + tempa[5]
else "" endif
endfor
rslt
}

Posted : December 3, 2019 11:26 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

I don't have code for this specific purpose, but could you get the values that you need by limiting your output with the values in index 2 (location) or index 3 (visit type) of your tempa array? You could nest an if statement:

if days<0 then

if tempa[2] == "Location where there are PCP Appts" then

rslt = rslt + tempa[1] + ” at” + tempa[2] + ” Type:” + tempa[3] + ” with” + tempa[5]

else

“”

endif

endif

Also to limit to 3 items you could use a while statement instead of a for. You would need to check that your counter is less than 4 and also not outside of the size of your array. Hope this is helpful.

Brad

Posted : December 4, 2019 1:23 am

heggea

(@heggea)

Posts: 52

Trusted Member

Topic starter

Thank you for your response. I did try your example but I must be doing something wrong since it just continues to return the same thing as before. I haven't written an endwhile statement before so I am not sure how to do that.

{global alist = getfield(APPTS_BY_STATUS(“completed”,”FULL”),”\r”,””)
global asz = size(alist)
global tempa
global rslt=””
for count = 1, count < asz, count = count + 1
do
tempa = getfield(alist[count],”,”,””)
days = DURATIONDAYS(str(._TODAYSDATE),tempa[1])
if days<0

then if tempa[4] == "Primary Care Clinic" then

rslt = rslt + tempa[1] + ” at” + tempa[2] + ” Type:” + tempa[3] + ” with” + tempa[5]
else “” endif endif
endfor
rslt
}

Posted : December 5, 2019 12:39 pm

heggea

(@heggea)

Posts: 52

Trusted Member

Topic starter

FYI for anyone interested in this I did finally get it to work. Here is the code:

{global alist = getfield(APPTS_BY_STATUS("completed","FULL"),"\r","")

global asz = size(alist)

global tempa

global rslt=""

for count = 1, count < 4, count = count + 1

do

tempa = getfield(alist[count],",","")

days = DURATIONDAYS(str(._TODAYSDATE),tempa[1])

if days<0 then

rslt = rslt + tempa[1] + " at" + tempa[2] + " Type:" + tempa[3] + " with" + tempa[5]

else "" endif

endfor

rslt

}

Posted : December 9, 2019 6:37 am

chicks

(@chicks)

Posts: 31

Eminent Member

What do you do when there are 0 completed statuses?

Posted : January 13, 2020 10:27 am

heggea

(@heggea)

Posts: 52

Trusted Member

Topic starter

For the zero completed you might need to change your options. If your clinic doesn't change the status of the visits to completed then maybe try "arrived".

Just a quick word for warning though: The code above returns three visits but it actually returns the first 3 visits not the last 3. I still haven't figured that out. I just didn't notice at first.

Posted : January 17, 2020 7:09 am

chicks

(@chicks)

Posts: 31

Eminent Member

Thank you heggea!!

Posted : January 17, 2020 10:21 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