Author Topic: strict search parameter (Read 1114 times)

xavier · May 13, 2009, 08:26:24 am

Hello,

I have contacts with a field (eg employer), and I want to list all the contacts where this field has a value X.

with the profile /civicrm/profile?gid=A&force=1&current_employer=X is "translated" into

where current_employer like "%X%", so if I look for "new york", I get all the employees of "new york", "new york police", "new york whatelse"...

is there a way of changing so it does a strict search instead of a %like% ? (changing the code won't be a problem)

Tia

X+

Donald Lobo · May 13, 2009, 11:43:43 am

CRM/Profile/Selector/Listings.php, line 180

Code: [Select]

       $queryParams =& CRM_Contact_BAO_Query::convertFormValues( $this->_params, 1 );

You can change that to:

Code: [Select]

       $queryParams =& CRM_Contact_BAO_Query::convertFormValues( $this->_params, 0 );

Note that this removes all wildcards from all params. If you want to do it for one specific parameter only, your best bet would be to fix the convertFormValues function in Query.php

lobo

xavier · May 13, 2009, 12:08:02 pm

Works great !

xavier · May 14, 2009, 12:04:06 am

For the custom fields, works great but the current employer is still like %X%

Trying to find...

Donald Lobo · May 14, 2009, 08:27:08 am

try adding some debugging code to:

CRM/Contact/BAO/Query.php, line 1439 onwards

will give u an idea of whats happening and why

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: strict search parameter (Read 1114 times)

xavier

strict search parameter

Donald Lobo

Re: strict search parameter

xavier

Re: strict search parameter

xavier

but not for the current_employer

Donald Lobo

Re: strict search parameter