Author Topic: Give option for search using wildcard or "LIKE" for core and custom fields (Read 1621 times)

farmrchrys · June 24, 2009, 11:11:42 am

It might be nice to offer admins a choice, possibly on the fly (check box next to input field) or set in custom data field creation or preferences so that someone could enter a partial search term (similar to basic search name and email fields) rather than typing exactly the search term - without having to use wildcards. A post I read (http://forum.civicrm.org/index.php?topic=8162.0) gives a clue how to do this by hard coding, but having it in core would be good.

Chrys

lcdweb · August 04, 2009, 08:12:29 pm

Related comment --

Text-type custom fields currently are searched using wildcards, but note/memo type fields are not. Yet I think those are just as important to search that way (think searching keywords in an organization description).

To do this, I've edited: CRM/Core/BAO/CustomQuery.php
Around line 427, replace the "Memo" case with the following:

Code: [Select]

$value = CRM_Utils_Type::escape( strtolower(trim($value)), 'String' ); 
                            if ( $wildcard ) {
                                $value = strtolower( addslashes( $value ) );
                                $value = "%$value%";
                                $op  = 'LIKE';
                            } 
					
		$this->_where[$grouping][] = CRM_Contact_BAO_Query::buildClause( $fieldName, $op, $value, 'String' );
		$this->_qill[$grouping][]  = "$field[label] $op $qillValue"; 
                continue;

CiviCRM Community Forums (archive)

News:

Author Topic: Give option for search using wildcard or "LIKE" for core and custom fields (Read 1621 times)

farmrchrys

Give option for search using wildcard or "LIKE" for core and custom fields

lcdweb

Re: Give option for search using wildcard or "LIKE" for core and custom fields