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

Function to View Problem List Based on Entry Date

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

2 Users

0 Reactions

68 Views

RSS

smcalister

(@smcalister)

Posts: 16

Eminent Member

Topic starter

Looking for help modifying a function that will filter problems in a data display based on the date of entry. Here is the current function that I am using to filter descriptions with an "*" and need to add a date filter.
{fnProbListFilter(PROB_AFTER("delimited"))}

in fuction library fnProbListFilter(strlist)
{!
local lCounter
local lProbArray
local lStart
local lBuffer
local lFormattedList = ""

/* Create array of problems */
lProbArray = getfield(strList, "|", "")

for lCounter = 1, lCounter <= size(lProbArray), lCounter = lCounter + 1 do

/* Create array for each problem */
lProbArray[lCounter] = getfield(lProbArray[lCounter], "^", "")

/*Confirm coded problem */
if match(lProbArray[lCounter][2],"*") = 0 or ProbArray[lCounter][10] <= 06/01/2015 then

/* Need to remove commas from problem name */
lBuffer = ReplaceStr(lProbArray[lCounter][2], ",", ";")

/* Append problem and ICD-9 code to formatted list */
lFormattedList = lFormattedList + lBuffer + " (" + lProbArray[lCounter][3] + ")" + " (" + lProbArray[lCounter][8] + ")" + " Entered/Modified: " + lProbArray[lCounter][10] + HRET

else ""
endif
endfor

/* Remove trailing comma */
if (lCounter > 1) then
lFormattedList = remove(lFormattedList, size(lFormattedList))
endif

/* Return comma separated list */
return (lFormattedList)
}

My attempt at the date, isn't working.

Thanks,
Sheri

Posted : June 4, 2015 5:56 am

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

when you say you want to filter the results, do you mean you want values only after a certain date, within a certain number of days/years of todays date, or find values for a specific date?

you will need to use lProbArray[lCounter][2] which will return the date of that particular obs value

Posted : June 4, 2015 7:25 am

smcalister

(@smcalister)

Posts: 16

Eminent Member

Topic starter

I want to see problems from the problem list entered before a specific date, not an obsterm from the flowsheet.

Posted : June 4, 2015 12:43 pm

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

im trying to post a function but it keeps deleting part of my post. what is your email address?

Posted : June 4, 2015 12:58 pm

smcalister

(@smcalister)

Posts: 16

Eminent Member

Topic starter

Ken ~ I did see part of your response in a "new answer" email from the forum, but not sure if it was the complete answer. Please feel free to email me your response.

Sheri
[email protected]

Posted : June 5, 2015 4:34 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