Measurement Display in Lab Viewer Omits Manually Entered Values

Preconditions

None

Steps to Reproduce

None

Expected Result

None

Observed Result

None

Additional Comments

Problem Summary:
When you click a measurement within a lab (e.g. HDL, LDL, etc), the result window that appears doesn't show values that were manually entered by users through the measurements section, it only shows result that came from labs. This differs from the display when you click measurements in the measurements section where it shows the both types. Screenshots attached.

Expected Result:
The result window should show all results, regardless of whether or not they came from a lab or were manually entered by a user.

Actual Result:
The display only shows results from labs; results that were manually entered are not shown.

Steps to Reproduce:
(1) Upload the attached lab and assign it to a patient chart. The lab contains one HDL result.
(2) Go to Admin-->Customize oscarMeasurements and configure OSCAR to allow users to enter HDL results in the Measurements section of the Encounter Screen.
(3) In the chart from (1), manually and an HDL measurement through the measurements section.
(4) Click HDL in the measurements section ... note that two results are displayed, the one from the lab and the one that was manually entered.
(5) Open the lab uploaded in (1). Click "HDL CHOLESTEROL" ... note that only one result is displayed, the result entered in (3) is not displayed.

Reproduced In:
12_1 Deb 436 (fresh install) + Ubuntu 12 LTS (fresh install)

Additional Information:
– The reason manually entered values are not displaying is because the query relies on the measurement having an entry in the measurementsExt table. Values entered through the measurements section do not have an entry in the measurementsExt table. An example query is shown below:
SELECT DISTINCT e2.val AS lab_no FROM measurements m JOIN measurementsExt e1 ON m.id=e1.measurement_id AND e1.keyval='identifier' JOIN measurementsExt e2 ON m.id=e2.measurement_id AND e2.keyval='lab_no' WHERE e1.val='2165' AND m.demographicNo='1'

Assignee

Unassigned

Reporter

Sourceforge Migration

Labels

OSCAR Build Date

None

OSCAR Build Tag

None

Client Browser

None

Client OS

None

Are you or your organization planning on submitting a fix for this bug in the next 30 days?

None

Validated by Reporter

None

SourceForge Reporter

trimaracorp

SourceForge Assigned To

None

SourceForge Date Created

None

SourceForge ID

3,525

Affects versions

Priority

7
Configure