Author Topic: Current employer: ajax don't work when too many organisations (Read 1505 times)

xavier · December 01, 2008, 11:49:05 pm

Hi,

Got a "european commission" organisation, and a bunch of "delegation of the european commission in X" (X being a country, and they are quite a few of them).

When trying to set the current employer, the autocomplete list is too long to display European commission, the one I want (the delegations being before the European commission).

So I can't update the current employer. Any idea how to force a strict search ? I've tried with quotes around, didn't work.

In general the "More" on the autocomplete is unuseful. Is it possible to replace it by "strict search/limit results" or something like that ?

I can't either update it from the relationship, because it doesn't update the current employer field.

Any idea ?

X+

xavier · December 02, 2008, 12:00:07 am

Related to that http://forum.civicrm.org/index.php/topic,5789.0.html

I'd be great to be able to search on the website name (eg "@civicrm.org" would retrieve civicrm llc)

Easy to hack ?

X+

Kurund Jalmi · December 02, 2008, 03:19:07 am

Quote

Is it possible to replace it by "strict search/limit results" or something like that ?

If you are on CiviCRM v2.1, you can modify CRM/Core/Page/AJAX.php search() , line around 219..

Hth

Kurund

xavier · October 29, 2009, 09:55:13 am

And for those trying to do the same on 3.0.x :

Code: [Select]

Index: CRM/Contact/Page/AJAX.php
===================================================================
--- CRM/Contact/Page/AJAX.php   (revision 24659)
+++ CRM/Contact/Page/AJAX.php   (working copy)
@@ -261,7 +261,6 @@
             }

             if ( $organization ) {
-
                 $query = "
 SELECT CONCAT_WS(' :: ',sort_name,LEFT(street_address,25),city) 'sort_name',
 civicrm_contact.id 'id'
@@ -269,7 +268,7 @@
 LEFT JOIN civicrm_address ON ( civicrm_contact.id = civicrm_address.contact_id
                                 AND civicrm_address.is_primary=1
                              )
-WHERE civicrm_contact.contact_type='Organization' AND organization_name LIKE '%$contactName%'
+WHERE civicrm_contact.contact_type='Organization' AND organization_name LIKE '$contactName%'
 {$addStreet} {$addCity} {$whereIdClause}
 ORDER BY organization_name ";
             } else if ( $shared ) {

CiviCRM Community Forums (archive)

News:

Author Topic: Current employer: ajax don't work when too many organisations (Read 1505 times)

xavier

Current employer: ajax don't work when too many organisations

xavier

Re: Current employer: ajax don't work when too many organisations

Kurund Jalmi

Re: Current employer: ajax don't work when too many organisations

xavier

Re: Current employer: ajax don't work when too many organisations