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

Need most recent obs value from an array of obs terms

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

7 Posts

4 Users

0 Reactions

57 Views

RSS

cprice7

(@cprice7)

Posts: 71

Estimable Member

Topic starter

I'm hoping to get some help returning the most recent obs value from 5 different obs terms into a VFE data display.

so far I have been successful at creating an array and sorting it with the following code:

{global surgDateArr=
array(lastobsdate("Surg Dx"),lastobsdate("Surg Dx #1"),lastobsdate("Surg Dx #2"),lastobsdate("Surg Dx #3"),lastobsdate("Surg Dx #4"))
sort(surgDateArr,FALSE)}

In a data display I can see the most recent date is first in the list which belongs to Surg Dx #2 obs term. Now how can I tell it to display the value of that first item?

Thanks in advance for any guidance!

Crystal Price

Posted : September 21, 2017 11:26 am

swhite

(@sbrooks)

Posts: 84

Trusted Member

I believe, the issue is that you can't sort a date properly.
In a false sort where you trying to get the max value in position 1, 02/01/2007 would sort before 01/01/2017 because 02 is greater than 01 in the sort.
I've solved this in the past with a function that transforms the date in YYYY.MM.DD.
Example: Array the obsdate based on "/" and restructure the date with something like this: arrayX[3]+"."+arrayX[1]+"."+arrayX[2] .
Then your array to be sorted will contain strings that can be sorted properly.
When you pull the first value from that array it will still be in the reverse data format.
So array that return on "." then put the date back into American date format with array[2]+"/"+Array[3]+"/"+Array[1].

Posted : September 21, 2017 12:05 pm

cprice7

(@cprice7)

Posts: 71

Estimable Member

Topic starter

Swhite,

I believe you have identified an issue I didn't even realize I would have further down the line. Thank you for bringing this to my attention. I understand what you are saying, but unfortunately I have no clue how to build that code you describe. Can you please share the code you used in the past for this if it's available?

Once I can sort the date of the obs terms correctly, I also need to figure out how to display the value of the most recent obs term from the 5 listed above, if anyone has input on that as well please share.

Thanks you so much!

Crystal

Posted : September 22, 2017 3:49 am

swhite

(@sbrooks)

Posts: 84

Trusted Member

This is a sample of the code I used dates in to the yyyy.mm.dd format:
The dateIn parameter is your date in MM/DD/YYYY.

local OutA
OutA = ""
OutA = getfield(dateIn, "/","")
if size(OutA) = 3 then
dateBit = OutA[3] + "." +
(if size(OutA[1]) < 2 then "0" + OutA[1] else OutA[1] endif) + "." +
(if size(OutA[2]) < 2 then "0" + OutA[2] else OutA[2] endif)
else dateBit = dateBit endif

I'll post the reversal back to the American date next.

Posted : September 22, 2017 5:39 am

swhite

(@sbrooks)

Posts: 84

Trusted Member

Here is a sample of the code I used to put the date back into American Date format:
The parameter yymmddDt is your date in YYYY.MM.DD format.

{fn fnAmericanDate(yymmddDt){
local retAmDt
retAmDt = ""
local ZarrayX
ZarrayX = getfield(yymmddDt,".","")
if size(ZarrayX) = 3
then
retAmDt =ZarrayX[z][2] +"/"+ZarrayX[z][3]+"/"+ZarrayX[z][1]
else retAmDt = retAmDt endif
return retAmDt}}

Posted : September 22, 2017 5:42 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

There is another way to look at this too - a sort of modified bubble sort. Modified, because we don't actually care about keeping an ordered list, just which is the most recent value, but the logic is the similar.

1. Start by assuming that the first value is the most recent.

2. Put the date of that value in a temp variable (for explanation we will call this the primary date)

3. Put the value of the value or if you prefer the array reference in a temp variable (we will call this primary value)

4. Check the primary date against the remaining items in the array. You can do this with either durationdays() or date1 > date2

a. if primary date is older than the item being checked against it becomes the primary date and the primary value is also updated

b. if the primary date is newer than the item being checked against it stays the primary date

c. need to know what you want to do if more than one term has the same date

One you have finished looping through the array the temp values should hold the most recent date and value. You would need to test to see if this is any more efficient than the other method suggested. If you have situations where you are looking through many obs terms this will be slow.

Posted : September 26, 2017 2:26 am

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

Hello,

I wasn't sure if you got this to work effectively for you. Let me know if you did not. I have a short, simple function that will accomplish this. email me at [email protected]

Posted : June 25, 2018 6:41 am

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