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

search builder: unable to search activity details

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.3.5
    • Fix Version/s: 4.4.0
    • Component/s: CiviCRM Search
    • Labels:
      None

      Description

      we don't have a clause to escape fields of type "Text" in CRM_Utils_Type::escape() which causes a fatal. simply adding the case to the existing String/Memo case doesn't work because the query is built without wrapping the value in quotes (e.g. ( LOWER(civicrm_activity.details) LIKE searchterm ) )

      we could wrap the term in quotes in the escape function case, but I think we want to look higher up the tree to figure out why it's not treating Text type fields as a string when building the query

        Attachments

          Activity

            People

            • Assignee:
              kurund Kurund Jalmi
              Reporter:
              lcdweb Brian Shaughnessy
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: