Results Unit ID shows instead of Text Value

[apothik (Robb Rich)]

Hi - I did a search and found a similar issue from 2016 but I’m still seeing the ID instead of the text value when I go to the Patient Results, and also when I open the Procedure Orders to show the historic entries. I’m using version 6.0.0

Here is the issue I found in the forum: On viewing the lab orders results from the patient encounter, the "Unit ID" is displayed instead of the actual unit names

Here is what I see when entering lab results and reviewing them through the patient Lab Result section.

Thanks,
Robb

[juggernautsei (Sherwin Gaddis)]

Can you back out on the first screenshot so I can see which page that is?

[apothik (Robb Rich)]

Hi Sherwin,
Here are some better screenshots.

Thanks
Robb

[juggernautsei (Sherwin Gaddis)]

Robb,

There is not an issue. The system is show the result values in the last column

[sjpadgett (Jerry P)]

He wants the Units to display the name for the unit id.
Configuration stores the discrete result unit as the id for the Procedures Unit list. In interface/orders/orders_results.php the procedure/results lookup query doesn’t include a join on the list Procedures Unit unit id for the display value so, it’d need to be added.
Look in interface/orders/orders_results.php around L-392 to modify.

[apothik (Robb Rich)]

Hi Jerry and Sherwin,
In Administration > Forms > Lists > Procedure Units I was anticipating the value entered in the ‘Title’ field would be what showed up.

In interface/orders/orders_results.php it looks like the result_units is around line 508/626 but it’s not clear it’s pulling from the ‘list_options’ table.

Thanks
Robb

[sjpadgett (Jerry P)]

I’ll just write a query and give to you. I may as well fix in master and for next patch.
Couple hours, okay?

[sjpadgett (Jerry P)]

@apothik
Try this and let me know soon and i’ll get in next patch.
orders_results.php (36.8 KB)

[apothik (Robb Rich)]

Hi Jerry,
Thank you so much. That worked exactly how I was hoping. Did I have something configured incorrectly, or was that something that wasn’t meant to work that way?

Thanks
Robb

[sjpadgett (Jerry P)]

No, it’s a bug. Will be in patch 3.

[apothik (Robb Rich)]

Hi Jerry,
Thanks for the update. If I may ask one more question: I am trying to adjust the CSS in public/themes/misc/labdata.css, but no matter what changes I make to colors, font sizes, weights, etc., it’s never reflected on the table view. I’ve cleared the browser cache, tried different browsers, and removed the Application Storage in the Console. Is there a way to clear the cache of OpenEMR?

Thanks
Robb