Tests loading with wrong specimen and/or test type (From BLIS-Kenya Ripo)

[ereng]

Some tests load the wrong specimen and/or test type or do not load them at all (#491148).

[briankip]

@mapesa explain further

[briankip]

@mapesa ?

[mapesa]

This is too old but give me a few minutes to see if I can simulate it using the given ID. If not we can close it.

[mapesa]

@briankip Follow the following steps to reproduce the bug.

1. Run the following query to inject a new record to the db similar to that referenced above (#491148).

INSERT INTO blis_revamp_prod.external_lab_request (labNo, parentLabNo, requestingClinician, investigation, requestDate, orderStage, patientVisitNumber, patient_id, full_name, dateOfBirth, gender, phoneNumber, cost, receiptNumber, receiptType, system_id) SELECT 320767, 0, requestingClinician, investigation, now(), orderStage, patientVisitNumber, patient_id, full_name, dateOfBirth, gender, phoneNumber, cost, receiptNumber, receiptType, system_id FROM blis_revamp_prod.external_lab_request WHERE id = 36815;

2. On the "Test Queue" page, click the "Receive Request" button for the corresponding entry (it should be the first on the list).
3. NB: The "Specimen Registration" form loads with "Synovial Fluid" as the Specimen Type instead of Stool. No tests are loaded. This is wrong since the test requested is "Stool for C/S"

[ereng]

The compatible specimen saved in Test Catalog -> Test Type -> Edit is "Synovial Fluid" not "stool." And it's loading the test "Stool for C/S" On changing the compartible specimen to "Stool", the compartible specimen is then loaded and not the test... Just finding out why?...

[ereng]

@mapesa There was a slight difference between "Stool for C/S "(the white space after the test name) saved in 'Test Catalog -> Test Type' from the "Stool for C/S" from the external lab request so the comparison '==' would not pass

I guess it's sorted, the test names should be exactly the same.

[mapesa]

Cool. You can close it. We need to remember to make the same changes on the Bungoma server.

• Rename 'Stool for C/S' test.
• Assign to it the appropriate specimen type.