Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-1460

Search Notes field in Advanced Search

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 1.5
    • Fix Version/s: 1.7
    • 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';

        Attachments

          Activity

            People

            • Assignee:
              kiran.jagtap Kiran Jagtap
              Reporter:
              bpatrick Brad Patrick
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: