Notifications
Clear all
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
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
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
Have you done any MEL tracing to see if there is any information there?
Posted : June 8, 2021 9:39 am
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
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
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
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
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
Topic starter
Actually found a tb-ppd lurking removed it, and we are in business
Posted : June 8, 2021 10:36 am
Topic starter
tb-ppd was it, now where to go from here lol
Posted : June 8, 2021 10:41 am
