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

APPTS_BY_STATUS help

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

2 Users

0 Reactions

56 Views

RSS

asears

(@asears)

Posts: 49

Trusted Member

Topic starter

I'm trying to show only PT appointments in a data display. Our PT appointment types all begin with PT, so I was going to try to break down the APPTS_BY_STATUS list into arrays in order to do so, but I can't seem to get it to work.

This is what is in the data display:
{arrived_list(APPTS_BY_STATUS("scheduled","FULL"))}

And this is the function I created:
{!fn arrived_list(strList){


local counter

local strArrivedList

local result = ""

strArrivedList = getfield(strList,"\r","")
for

counter = 1, counter <= size(strArrivedList), counter = counter + 1

do

strArrivedList[counter] = getfield(strArrivedList[counter], ",","")

if match(strArrivedList[counter][3],"PT")>0 then

result = strArrivedList[counter][1] + ", "+strArrivedList[counter][2]+", "+strArrivedList[counter][3]+", "+strArrivedList[counter][4]+", "+strArrivedList[counter][5]+hret

else ""

endif

endfor

return result }}

Posted : June 23, 2015 3:23 am

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

what does it end up actually returning when you use that? I think I have a function that can do that

Posted : June 23, 2015 10:05 am

asears

(@asears)

Posts: 49

Trusted Member

Topic starter

The data display is blank.

I'd like it to return:
date, time, appt type, facility, provider
date, time, appt type, facility, provider

but only PT appointments.

Posted : June 23, 2015 10:34 am

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

Ok and is PT a separate location of care or would that be based on the summary line for the appointment?

Posted : June 23, 2015 10:38 am

asears

(@asears)

Posts: 49

Trusted Member

Topic starter

Yes, PT has 3 separate locations and their names all end in "PT". Just like their appointment types all begin with "PT". I was trying to narrow down the results to only appointments that had an appointment type that contained "PT" (match function). I tried with facility that contained "PT" as well and that didn't work either.

Posted : June 23, 2015 10:42 am

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

Hey Aubrey, sorry but every time I try to post the function, it cuts out part of the text so I sent you an email. Let me know!

Posted : June 23, 2015 1:19 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