Search for "AAA BBB" returns all the AAA and all the BBB!

[xavier]

Hi,

(clarification, hopefully)

My problem is that when I search on two works, it returns all the names containing the first word, and the ones containing the second one. Moreover, the one(s) containing both aren't at the top. As we have a lot of organisations that contains "generic" words (eg european, health, youth, institute, association...), it becomes nearly impossible to find anything.

Last, but not the least, you can't create a relation anymore between an employee and her employer, as the list contains too many items, and it can't displays it back. I've tried changing the settings in the search:
/civicrm/admin/setting/misc?reset=1

But I haven't been able to improve, in one way of another.
eg on:
http://drupal.demo.civicrm.org/civicrm/contact/search/basic?_qf_Basic_display=true&qfKey=e5361be4bc57d4f185d178b250528834Searched
searched John johnson.

expects all the John johnson (ie. one), but gets all the john and all the johnson

The there a way to force an AND instead of an OR between the words ?

X+



Is there a way of requesting a strict search (google syntax "john doe") instead of john OR doe ?

That's a hell annoying when you're looking for some specific organisation (eg "european health"), as half of the organisations here are european something bla bla.



X+

[xavier]

I've tried to clarify the problem. I'm pretty sure it did work differently on the 2.0.x, but it might be only that it searched at the start of the name instead than at any place (eg. 2.0: like query% instead of 2.1 like %query%)

Anyway, in some cases, it just makes the search not very efficient, but on others (eg adding a relationship, it brakes the functionality as soon as you have enough contacts that contains a word that is contained in the name you're trying to associate with).

Any idea ?

X+

[Donald Lobo]

1. we added a few more configuration options. You can tweak the behavior here: http://drupal.demo.civicrm.org/civicrm/admin/setting/misc?reset=1

2. We also added a feature to make any string in " (double quote) to be an exact search

3. the previous behavior of all strings with a space being split and wild card being prepended (and appended) is the behavior u r seeing

lobo

[xavier]

Hi,

The quote is to search exactly the right name (eg if I search "AA BB" it won't show "AA BB CC", right ?)

I'm not clear about how to reach what I want, please bear with me while I'm trying.

My goal is that if I search
"Foundation Youth Europe"

I find the "foundation of youth in Europe"
and the "youth foundation for a swingy Europe"

but not a list of all the foundations , starting with the "Asbestos Foundation" and ending with the "Zebra Foundation" melted with all the europe things and all the youth bla bla

I suppose it translates by splitting, but having AND instead of OR. Is there an option I didn't find ?

I've tried you settings, but didn't made it better for my need

X+

[Donald Lobo]

I dont think we handle the below currently. The fastest solution is a custom search

alternatively, u can hack the code at: CRM/Contact/BAO/Query.php, line 2170 or so and modify the query there

lobo

[xavier]

thanks for the lead.

I'll first try to hack it to see if things improve, and hopefully produce a patch.

More info soon

X+

[xavier]

Hi,

I didn't find an sql only way.

the full text feature of mysql doesn't work on innodb. Has someone tried the Sphinx Search plugin  ?

In the meantime, I simply changed the code not to split on the " ". not perfect, but works better (well, now I can associate a company and an individual .

X+

[Donald Lobo]

have not tried sphinx, but have experimented with solr (http://lucene.apache.org/solr/) in the past. some of my experimental code is here:

http://svn.civicrm.org/civicrm/trunk/tools/solr/

I think  using hooks to publish the xml to the solr engine should not be too hard and will be super cool

lobo

[xavier]

Not very clear, but seems you can plug it straight on the db.
http://wiki.apache.org/solr/DataImportHandler

To be continued...

[Donald Lobo]

cool. that seems relatively new, but very cool. The delta-change query will be the crux, we dont keep a detailed record of last modified time for many of the objects, so writing a sql query for that aspect might be a bit hard

lobo