Getting better search results from multi term queries - Connections

Support has been upgraded!

The Support Forum is closed. Not to worry! Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.

Premium Support

Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?

Please open a Support Ticket in your user account.

Click here to open a support ticket.

Free Support

Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.

Please open a new support topic in the WordPress support forums for Connections.

Click here to open a support topic.

This topic is: resolved

Tagged: 0.7.6.6, FULLTEXT, InnoDB, MyISAM, search, storage engine

This topic has 16 replies, 5 voices, and was last updated 12 years, 9 months ago by Steven Zahm.

Viewing 7 posts - 11 through 17 (of 17 total)

← 1 2

Author

Posts
05/20/2013 at 1:33 pm #260394

Steven Zahm
Keymaster

@ ANA

Look for the search method in the class.retrieve.php file.

05/20/2013 at 1:41 pm #260396

Ana
Guest

Thanks, I will let you know how does it goes. I also want to reset the value to blank, after the search is done, thanks, -Ana Maria

05/20/2013 at 2:21 pm #260405
Steven Zahm
Keymaster
@ Ana

You need to edit the class.template-parts.php file.

Look for this line:
```
$out .= '<input type="text" id="cn-search-input" name="cn-s" value="' . esc_attr( $searchValue ) . '" placeholder="' . __('Search', 'connections') . '"/>';
```
- This reply was modified 13 years, 3 months ago by Steven Zahm.
06/27/2013 at 7:34 am #263715

IT Department
Participant

Will these search improvements be implemented in upcoming versions of Connections?

06/27/2013 at 8:37 am #263725

Steven Zahm
Keymaster

@ roy

Are speaking about FULLTEXT queries? That has been in Connections for quite some time now. But, to take advantage of it more fully you have to turn off the keyword search on the Connections : Settings admin page under the Search tab. The disclaimer is that this will only have an effect if the database tables are setup with the MyISAM storage engine, which is the MySQL default. Some host default to the InnoDB which until very recently did not support FULLTEXT queries. So, if you disable keyword search and you do not get any results when performing queries, you have to use keyword search.

Hope that helps.

11/08/2013 at 12:04 pm #273271

IT Department
Participant

I did that, but my results are odd. If I use LIKE QUERY it seems to perform an or search (I get all Oceanic-entries and all Moscow-entries; see below). And if I switch to FULLTEXT, I get results only for one term search words. If I search for example for “oceanic moscow” there are no results, even if I have a company “Oceanic” in the city of Moscow. In the options I checked the boxes for searching in Organization and Adress City. If I search for “Oceanic” or “Moscow” only there are results. But how to do searches with 2 or more words combined for more specific results?

11/08/2013 at 1:19 pm #273273

Steven Zahm
Keymaster

@ roy

That sounds about right. The LIKE query is OR. Making it AND makes the query results to small by being too specific.

FULLTEXT is multiterm, just not across fields. Entering “Oceanic” and “Moscow” would yield results for only entries that contain both terms in the same field. Since one term is in the organization field and the other is in the city field would equal no results.
Author

Posts