catalog insensitive search by name

[mantid-builder]

This issue was originally TRAC 8939

Original Reporter: Jay Rainey

Currently, in the algorithm, UI, and related classes the Investigators name field is refereed to as InvestigatorSurname, which is mis-leading (in fact, it's what the field was previously used as).

If I attempt to search via Investigators name the results returned are not correct, for example, if I search for jay rainey, it does not return any results. However, if I search for Jay Rainey it returns the correct results.

The search for the investigators name therefore needs to be made case insensitive.

---

Keywords: ICAT

[mantid-builder]

@NickDraper (2014-02-14T10:59:49):
Bulk move of tickets out of triage (new) to assigned at the introduction of the triage state

---

Jay Rainey (2014-04-28T08:26:58):
An [https://code.google.com/p/icatproject/issues/detail?id=133 issue] has been raised regarding usage of LOWER/UPPER. Once ICAT 4.3.3 gets rolled out to ICATDEV (likely some point this week) then this ticket can be addressed.

---

Jay Rainey (2014-06-09T09:00:53):
Rename investigatorSurName to investigatorName. Refs http://trac.mantidproject.org/mantid/ticket/8939.

e7f7389

---

Jay Rainey (2014-06-09T09:00:53):
Updated algorithm and interface references to surname. Refs http://trac.mantidproject.org/mantid/ticket/8939.

• Also updated the error label name for DataFileName.

fe0974b

---

Jay Rainey (2014-06-09T09:00:54):
Updated references to surname in catalogs. Refs http://trac.mantidproject.org/mantid/ticket/8939.

c7b9b67

---

Jay Rainey (2014-06-09T09:00:54):
Improved logging messages in CatlogDownloadDataFiles. Refs http://trac.mantidproject.org/mantid/ticket/8939.

0b65f79

---

Jay Rainey (2014-06-09T09:40:49):
The previous commits above deal with updating the '''surname''' attribute in the ICAT Search algorithm to the more generic '''name'''.

The next part of this ticket ('''which is not yet done''') deals with updating the [https://github.com/mantidproject/mantid/blob/c7b9b679eb1e8de2edc38e53e0379e9653c0c8fe/Code/Mantid/Framework/ICat/src/ICat4/ICat4Catalog.cpp#L201-L208 search query] that is sent to ICAT to be '''lowercase''', e.g. using ''LOWER()''. This ensures that if the user enters '''"Jay"''' or '''"jay"''' into the '''investigators name''' field the query will return the correct results.

As noted in comment:2, there has been an [https://code.google.com/p/icatproject/issues/detail?id=133 issue opened] for the exact cause of this problem. The change has been made and will be introduced to ICAT '''4.3.3'''. Therefore, this ticket cannot be completed until ICAT '''4.3.3''' is released onto the production server. To find out when this will be done you will need to get in contact with Tom Griffin.

When working on this ticket, please use the following branch as it already has the name changes:

• [https://github.com/mantidproject/mantid/compare/master...feature;8939_icat_insensitive_name_search feature/8939_icat_insensitive_name_search]

  ---

@NickDraper (2014-12-08T10:25:32):
Moved to the backlog at the code freeze of R3.3

[Anders-Markvardsen]

may need to be closed