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

Long delay when selecting user from drop down list

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

3 Users

0 Reactions

128 Views

RSS

akrudo

(@akrudo)

Posts: 15

Eminent Member

Topic starter

I created a drop down list of users that have NPI numbers in their accounts. This selected user will then automatically populate in the 'Authorized by' field of lab orders created during the encounter. Saves the user time so they don't have to change the authorizing provider in every lab order.

The problem is that there is a delay every time we use this drop down list. I also use this to automatically send a flag to the selected user and we get the same delay. The EHR freezes for several seconds after selecting a user from the list.

Is there a way to remove this delay? Is there something going on in my code that is causing it?

This is the two functions I used. One to populate the list and the other to pull the login id so it can be used to create the orders.

// Creates a list of Users with NPI numbers

{! fn fnAuthProvList(strUser)
{
local i
local UserList
local strAuth
local strAuthProvList = ""
local strArray = Array()

UserList = getfield(strUser, "|", "")

for i = 1, i <= size(UserList), i = i + 1 do
UserList[i] = getfield(UserList[i], "^", "")

strAuth = UserList[i][2]

strAuth = ReplaceStr(strAuth, ",", numtoascii(130))

if UserList[i][9] <> "" then
insert(strArray,1,strAuth)
endif

endfor

return sort(strArray, TRUE)
}}

// Sets gAuthProvName value to login ID from name selected

{fnAuthProvID(DOCUMENT.AUTHPROV)}

{! fn fnAuthProvID(strID)
{
local i
local IDList
local ID
local strAuth
local strAuthID
local List = GET_USER_LIST("ALL","","delimited")

IDList = getfield(List, "|", "")

for i = 1, i <= size(IDList), i = i + 1 do
IDList[i] = getfield(IDList[i], "^", "")
strAuth = IDList[i][2]
strAuthID = IDList[i][1]
strAuth = ReplaceStr(strAuth, ",", numtoascii(130))

if strID == strAuth then
gAuthProvName = strAuthID
BREAK
endif
endfor

return ""
}}

It's called using this in the drop down component:

{fnAuthProvList(GET_USER_LIST("ALL","","delimited"))}

Posted : March 7, 2023 7:03 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Have you done a MEL trace and looked at the timestamps to see where your delay is in the first function? How long is your user list? It may be the sort is the slow part. Have you tried it without the sort to see if there is any improvement?

Posted : March 7, 2023 10:57 am

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

It looks to me like you are using the function as a watcher expression so it is having to repeatedly run. I would set it up to call the function one time, write the result to a local variable, and then use that. That way, it only calls the function once and then uses a static list thereafter. A similar issue can occur when you are consistently calling historical information from observation terms. You really only need to generate the list once, but the system is having to do the work of generating it every time.

Posted : March 10, 2023 8:25 am

akrudo

(@akrudo)

Posts: 15

Eminent Member

Topic starter

This worked perfectly! Thank you. It makes total sense.

Posted : March 16, 2023 9:46 am

akrudo

(@akrudo)

Posts: 15

Eminent Member

Topic starter

Thank you. I did try but it took just as long without sorting it or looking for just users with NPI numbers. I did notice that it pulled the list, which takes a while, each time I selected a name so it did slow it down.

Posted : March 16, 2023 9:48 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