Author Topic: search by 'display_name' OR 'email' addresse (Read 1968 times)

TrAshiBa · May 02, 2007, 06:53:36 am

Hi,

When I use the function "crm_contact_search" with civicrm 1.6, I only give one parameter which is "sort_name"

$params = array( 'sort_name' => $keyword )
and the search matches the 'keyword' with 'sort_name' and 'email' fields. It was wonderful, it was that I am looking for.

But now, I am using civiCRM 1.7 ( 1.7.beta.9327 ), I replace the parameter ' sort_name' by 'display_name' mentioned by Swati Vaidya in the mailing list. The fact is the parameter does a matching only with 'display_name ', I wanted to make a matching with the 'email' field too.

If I use 2 parameters, the search criteria is AND'ed as mentioned in the wiki.civicrm.org.

Does someone have a tip to suggest to have a OR'ed search criteria ?

Thanks in advance for any help

Donald Lobo · May 02, 2007, 10:41:05 am

The API does not support sending in a query with OR parameters in v1.7

However you can call the code directly and get support for the above. Here are some pointers that will get you started

1. Check api/v2/Contact.php, function civicrm_contact_search. This gives u a rough idea on how to call the Query class directly

2. The first params, inputParams needs to be as follows:

$params =
array(
array( 'display_name', 'LIKE', '%foo%', 0, 0 ),
array( 'email' , 'LIKE', '%foo%', 1, 0 ),
);

The 4th parmeter specifies what group the clause belongs to, and all groups are then OR'ed together

Contact us on IRC if u need more detailed help/instructions

regards

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: search by 'display_name' OR 'email' addresse (Read 1968 times)

TrAshiBa

search by 'display_name' OR 'email' addresse

Donald Lobo

Re: search by 'display_name' OR 'email' addresse