Note: Issue Issue-specific to Oracle database
In version 6.3 and before, there was a bug which 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’ ' 12345' (hypothetical 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 fixed set manually from the database.
...
Step 1: Delete the incorrect MRN search keywords.
| Code Block | ||
|---|---|---|
| ||
delete from os_search_entity_keywords where entity = 'collection_protocol_registration' and name = 'medicalRecordNumber' |
...