Details
-
Type: Improvement
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 1.5
-
Fix Version/s: 1.7
-
Component/s: Technical infrastructure
-
Labels:None
Description
Advanced Search and Search Builder should include ability to search for any term in the Notes tab.
For Advanced Search, add a new collapsible section (below Address Fields) called "Notes". Contains a single text field for the "Note Text:" In advanced search, we will automatically supply the LIKE operator, so we should also add leading and trailing percent signs to search term IF the user hasn't entered one or both. (If user enters "Board Meeting" - we transform to "%Board Meeting%". If they enter "Board Meeting%", leave string as is. This allows them to specify ONLY a leading or trailing wildcard if they want to.
For Search Builder, the user should enter the exact search term including wildcards as desired.
We need to handle this as a "special field" similar to how we handle Groups and Tags.
The basic query is something like this:
select distinct left join on civicrm_note, where subject like '$noteText';