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

Using GET_USER_LIST to pull names

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

13 Posts

3 Users

0 Reactions

75 Views

RSS

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

Si I'm trying to make a dynamic choice drop down that pulls users with the role of Physician into a drop down in which users can select with the providers NPI beside it. I'm trying to use a function that wroks with most getfield type of thing (meds,probs,orders) but I can't seem to get it to work with this. Here's what I got so far:

{!fn GetProvName() {

local hold = GET_USER_LIST("PHYSICIA","Physicians","delimited")
local temp
local rslt = ""

for i = 1, i <= size(hold), i = i + 1 do
temp = getfield(hold[i], "^", "")
if (rslt <> "") then
rslt = rslt
endif
rslt = temp[2]
endfor

return rslt
}}

This gives me a blank dropdown. Any suggestions?

Posted : July 22, 2015 8:18 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

I reworked the code (had some minor errors in processing) and it seems to work. here is the function.

{!fn GetProvName() {

local hold = getfield(GET_USER_LIST("ALL","Centricity_Providers","delimited"),"|","")

local temp = ""

local rslt = ""

for i = 1, i <= size(hold), i = i + 1 do

temp = getfield(hold[i], "^", "")

temp[2] = replacestr(temp[2],",","\,")

if (rslt <> "") then

rslt = rslt + "," + temp[2]

else

rslt = temp[2]

endif

endfor

return rslt

}}

The key factor is to make sure that the GET_USER_LIST(LOC, roles,list_type) code is returning values. I found that if I had the wrong LOC or roles, the function would return a blank.

Double check your roles by going to:

Administration ->

System ->

User and Resource Management - >

Users ->

Security ->

Security Groups

The security groups are what the roles section is looking for. When I used "Physician", I got a blank list, but changing it to "Centricity_Providers" gave me a list of all my providers in that security group.

You can always add more logic to specify what kind of providers to return based on job-title, but this should get you started. Let me know if you need any further help with it.

Posted : July 22, 2015 1:18 pm

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

dcarpenter, Thanks! I think this uncovered my real issue, so we have providers roles as: "Physician (MD, DO, PA-C, NP)" this seems to break the funtion, because If I use a role that doesn't have a comma or a special character such as "Radiolologist" I get results.

Posted : July 23, 2015 2:20 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

My end goal to all of this is to pull the list with the name and the NPI. My other option is a long If then statement which I dread going down that route.

Posted : July 23, 2015 2:50 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

I definitely understand the pain of endless if statements. before you give up on this route, try using this modified code. I added the role you gave me, and appended the NPI number to each providers name. The backslashes before each comma should make the code recognize it as one role.

{!fn GetProvName() {
local hold = getfield(GET_USER_LIST("ALL",""Physician (MD\, DO\, PA-C\, NP)"","delimited"),"|","")
local temp = ""
local rslt = ""

for i = 1, i <= size(hold), i = i + 1 do
temp = getfield(hold[i], "^", "")
temp[2] = replacestr(temp[2],",","\,")
if (rslt <> "") then
rslt = rslt + "," + temp[2] + " " + temp[9]
else
rslt = temp[2] + " " + temp[9]
endif
endfor
return rslt
}}

Also, I noticed that some of my providers did not have their NPI listed in this code, even though they have one in Administration. If you see the same issue (some providers with NPI, some without) please let me know and I will let GE know it is an issue on other client's software.

Thank you,

Posted : July 23, 2015 7:14 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

For this line local hold = getfield(GET_USER_LIST("ALL",""Physician (MD\, DO\, PA-C\, NP)"","delimited"),"|","") do the quad quates need to be there enclosing the role?

Posted : July 23, 2015 9:37 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

I got to be missing something:

{!fn GetProvName(){
local hold = getfield(GET_USER_LIST("PHYSICIA",""Physician (MD, DO, PA-C, NP)"","delimited"),"|","")
local temp = ""
local rslt = ""
for i = 1, i <= size(hold), i = i + 1 do
temp = getfield(hold[i], "^", "")
temp[2] = replacestr(temp[2],",","\,")
if (rslt <> "") then
rslt = rslt + "," + temp[2] + " " + temp[9]
else
rslt = temp[2] + " " + temp[9]
endif
endfor
return rslt
}}

Tried with the ""Physician (MD, DO, PA-C, NP)"" and "Physician (MD, DO, PA-C, NP)" still a blank dropdown yet once again I use a role that doesnt have , or () I get the users.

Posted : July 23, 2015 9:51 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

Whoops! the quad quotes should not be there. darn typos! my apologies. The line should look like this:

{!fn GetProvName(){
local hold = getfield(GET_USER_LIST("PHYSICIA","Physician (MD\, DO\, PA-C\, NP)","delimited"),"|","")
local temp = ""
local rslt = ""
for i = 1, i <= size(hold), i = i + 1 do
temp = getfield(hold[i], "^", "")
temp[2] = replacestr(temp[2],",","\,")
if (rslt <> "") then
rslt = rslt + "," + temp[2] + " " + temp[9]
else
rslt = temp[2] + " " + temp[9]
endif
endfor
return rslt
}}

you can stick this line into a quick text, and if it gives you results, then the function will work.

{GET_USER_LIST("PHYSICIA","Physician (MD\, DO\, PA-C\, NP)","delimited")}

Posted : July 23, 2015 10:24 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

I get the {GET_USER_LIST("PHYSICIA","Physician (MD\, DO\, PA-C\, NP)","delimited") <-BAD VALUE OR BAD INDEX error

So that's what I was getting before. I wonder why centricity is having a hard time evaluating those characters.

Posted : July 23, 2015 10:36 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

I think I have the Answer! try replacing the location of care "PHYSICIA" with "ALL". (or if you renamed the folder that holds all of your locations of care, change the name to that LOC. ours is ALL)

if you get results, then it is a bad LOC in that field. I was able to get a blank list (which means the code ran) using your role with all the commas, but changing the LOC. when I used PYSHICIA, it gave me the bad value or index error.

give this a whirl in your quicktext:

{GET_USER_LIST("ALL","Physician (MD\, DO\, PA-C\, NP)","delimited")

good luck!

Posted : July 23, 2015 10:45 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

PHYSICIA is our ALL, I'll keep messing with it I'm just stumped, like I was saying above I can swap the role to any other role and it works fine. I'm copying the role straight off the setup in centricity. Thanks for this piece, i've been messing with GET_USER_LIST for awhile and haven't gotten it right! So you can imagine my relief.

Posted : July 24, 2015 2:17 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

Glad I can be a fellow sufferer with ya. 🙂

My best guess on this is that the commas are throwing the code off. If you had 3 security groups: MA,NURSE and PA-C, you could get all 3 groups of users by writing the code like this:

{GET_USER_LIST("PHYSICIA","MA,NURSE,PA-C","delimited")}

If you guys are able to, changing the security role for providers to a name without comma's might be the fix. Especially since you said it was working on other specialties without commas.

If that is not an option, you'll have to get everyone in the clinic and sort them by job title. not impossible, but not quite as easy.

Have a great Friday!

Posted : July 24, 2015 5:37 am

dmdalrymple

(@dmdalrymple)

Posts: 22

Eminent Member

Any thoughts on getting function to work in VFE? I think only comma separated values will work.

Posted : October 8, 2015 9:51 am

24 Forums
9,940 Topics
39.9 K Posts
4 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