...
Table of Contents | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Incorrect results in global search when searching MRN due to a bug in v6.3
Expand | ||
---|---|---|
| ||
In version 6.3 and before, there was a bug |
...
that caused incorrect results to come up in the global search on searching for an MRN (Medical Record Number). For example, a user wants to look for a participant with MRN |
...
' 12345' ( |
...
imaginary numbers) |
...
; the global search would show a participant with PPID' 10102', which does not have the MRN. This issue is fixed in v7.0, hence for versions prior to that; this issue needs to be |
...
set manually from the database. The table OS_SEARCH_ENTITY_KEYWORDS is used to show the results for the items searched in the global search. How to fix the search issue? Please execute all the below SQLs on a test environment and then on the production server. Step 1: Delete the incorrect MRN search keywords.
Step 2: Feed the correct MRN search keywords pointing to the correct registration records
|
Specimen migrated using fast-loader, not global searchable using its Barcode.
Expand | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
How to fix the search issue? Please execute all the below SQLs on a test environment and then on the production server. Step 1: Delete Barcode entries of already present specimens. As only executing the insert statement will lead to duplicate entries.
Step 2: Insert Specimen Barcode and required details in os_search_entity_keywords table.
|