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

SOLVED - V20 and IMMUN_GETLIST("", "last") not working?

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

11 Posts

3 Users

0 Reactions

102 Views

RSS

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

So I utilize {IMMUN_GETLIST("", "last")} quite a bit this no longer pulls data. Has anyone else run into this?

Update 1: AhHa! To add to this it only seems to be some charts and not all. No change in code, just some charts IMMUN_GETLIST pulls data and some don't. I've tried going in and touching each immunization in the chart it doesn't work on but that didn't correct it.

Update 2: Whatever this is seems to also be plaquing the symbol IMMUN_GETVALUE_GIVEN as it doesn't pull data on the same chart IMMUN_GETLIST doesn't.

Update 3: {IMMUN_GETVALUE_GIVEN('Influenza', 'AdministeredDate', 'List')} give me the "-9" error which is "Result formatting failure" --- interesting

Update 4: {IMMUN_GETLIST()} works

Update 5: {IMMUN_GETLIST ("","all")} works

Update 6: doesn't appear to be front end side as manually removing each vaccine and adding one back doesn't fix the issue.

Update 7: this is my culprit (ultimately the immunization tb-ppd). After spot checking several charts this immunization group name does indeed seem to be the cause of the issue

1735233465436220^1735233465436220^^tb-ppd^tb-ppd^1^Y^^N^^ ^^^^^^96^^^intradermally^^left inner forearm^^Aventis Pasteur^^123456^3/29/2007^^^2/27/2007 1:37 PM^^0.1 ml. migrated from obs^^^^^Y^^3/7/2007 11:52 AM^^^^0^N^^1488202658203820^1735233465436220^^^^

Posted : June 8, 2021 1:12 am

mjharunk

(@mjharunk)

Posts: 191

Reputable Member

I have not encountered this in our athenaFlow v20 TEST environment, but it is very concerning since we have a lots of custom VFE content using those data symbols as well as quicktexts.

I will be on the lookout as we continue to validate prior to go-live. If you come across the variable that's affecting certain charts we'd be willing to test in our system for confirmation.

Posted : June 8, 2021 7:38 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

Will do, that's the first plan, find the similarity causing the issue in the charts where it's not working. Been using that symbol since the immunization swap in functions, quicktext, etc with no issues.

Posted : June 8, 2021 7:41 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Have you done any MEL tracing to see if there is any information there?

Posted : June 8, 2021 9:39 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

Doing it the simplest way I can think this was the results:

06/08/2021 17:46:20.230->{IMMUN_GETLIST ('','last')}
06/08/2021 17:46:20.231-execute>call IMMUN_GETLIST("", "last")
06/08/2021 17:46:20.517-results>""
06/08/2021 17:46:20.518-execute>end
06/08/2021 17:46:20.519-results>""

then on a chart where it works:
06/08/2021 17:48:03.190->{IMMUN_GETLIST ('','last')}
06/08/2021 17:48:03.192-execute>call IMMUN_GETLIST("", "last")
06/08/2021 17:48:03.215-results>"1740425594936440^1740425594936440^Human Papillomavirus^hpv#2 dose^hpv#2 dose^2^U^^N^^ ^^^^^^62^^^^^^^^^^^^^11/19/2013 3:35 PM^^gard 2 test. migrate etc etc etc.......

Posted : June 8, 2021 9:47 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

{IMMUN_GETVALUE_GIVEN('Influenza', 'AdministeredDate', 'List')}

does give me a -9 which is the result formatting error

Posted : June 8, 2021 9:51 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

If you did a migration from obs terms to the IMMUNIZATION table, you might run some SQL queries on the patients you are having issues with against the table. You may have some badly formatted data, such as invalid dates, stray characters in fields, etc. that are causing this to be a patient-specific problem. Might need some data clean-up.

Posted : June 8, 2021 10:07 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

I will try wiping the test patient I am seeing it in then adding one. Crazy if that is it because the tool ran in 2015 and everything was swapped no issues.

Posted : June 8, 2021 10:11 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

Interesting enough removing every vaccine and adding one back, still same results, no data gets pulled.

Posted : June 8, 2021 10:26 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

Actually found a tb-ppd lurking removed it, and we are in business

Posted : June 8, 2021 10:36 am

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

tb-ppd was it, now where to go from here lol

Posted : June 8, 2021 10:41 am

Share:

24 Forums
9,942 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.1