I find the serarch engine in our Open Clinica installations (OC3.8 and also in OC 3.12.2) difficult.
Depending on if there is a dash (‘-‘) entered in any of the fields that is included in a search, the behavior of the search engine is different.
For example if you search for a user, it will search through the fields: ‘User name’, ‘First Name’, ‘Last Name’.
If the user name is for example ‘Frank-Test’ it will not find the user if you search for the string ‘Fran’ or ‘est’, but only when you search for the whole words ‘frank’ or ‘test’
Whereas if the user name would have been ‘Frank_Test’ you would find this record if you search for any string within the name. So searching for ‘est’, ‘Test’, ‘ran’ or even just ‘f’ would find this record.
Does anybody know …:
1) If this is indeed the intended behavior of OpenClinica?
2) If this can possibly be changed by configuring the Postgress database differently? or
3) if there is something else going on?