wet_haystack: Custom fulltext search index builder

slabanosa · 2012-02-01 14:54:21

Not sure if it is allowed to post it here, so delete me if I’m wrong but here’s a quick word of caution for those working with MLP: wet_haystack will break your search functionality when used with the MLP mod

wet · 2012-02-01 15:02:07

Thanks for the report. I have added this fact to the initial post and to wet_haystack’s documentation.

johnstephens · 2014-02-21 20:31:30

Dear Informed Textpattern Prodigies,

I’m having some trouble, and I did some tests. Here’s what I found.

I have a custom field that lists names in a common citation format. When wet_haystack is active, Textpattern’s search can find articles with some names, but not others

Case A

Custom field content: John Stephens
Search query: John Stephens
Result: Search returns the articles with “John Stephens” in the custom field

Case B

Custom field content: Stephens, John
Search query: John Stephens
Result: Search does not return the articles with “Stephens, John” in the custom field

My goal is to get the search query for case B to return results where the last name is first in the custom field. Can you suggest any way I could get this to work?

Thank you!

uli · 2014-02-22 00:14:09

Hi John,

what you describe as case B seems to be the normal behaviour of the standard TXP search, so not haystack dependent. Have you taken a look at smd_fuzzy_find already?

johnstephens · 2014-02-22 01:08:01

Yes, fuzzy_find is already in place, but I have other articles that include those names, so it doesn’t trigger. Should I move this query to the “How Do I” forum?

uli · 2014-02-22 02:05:42

Then there’s yet ob1_advanced_search :) From its PDF manual:

words
Defines if the user can use word searches (all words, exact phrase and at least one word).

Download links in this post.

I’ve not tested whether this still works, and it might act vicious, see last post of the thread.

element · 2014-08-13 10:41:34

Using Txp 4.5.5 and PHP 5.4, extension doesn’t seem to search in custom fields any more, despite being selected.

johnstephens · 2014-08-13 18:48:13

element wrote #282879:

Using Txp 4.5.5 and PHP 5.4, extension doesn’t seem to search in custom fields any more, despite being selected.

Same thing here, using TXP 4.5.5 and PHP 5.3.28.

element · 2014-09-01 09:52:32

Anyone with a solution for a non-working wet_haystack?

johnstephens · 2014-10-08 20:45:44

johnstephens wrote #282894:

Same thing here, using TXP 4.5.5 and PHP 5.3.28.

I might have been mistaken. I’m not sure, because I didn’t make record of the keywords I was testing previously, so I can’t test those again.

I operate an academic journal site that uses custom fields to associate authors with each article, because an individual article may have 2 or more authors. The author information is stored in the table for smd_bio.

One custom field holds the smd_bio author IDs as a comma-separated list, like this: robert-jones, john-smith.

Another field holds the author names in a citation format, like this: Jones, Robert, and John Smith.

Both fields are selected as “searchable columns” in wet_haystack’s preferences.

Suppose author John Smith has just one article on the site. When I search for that name in my site search field, first name and last with no other text, with the search field’s matching attribute set to all, I get three pages of results. Every result on the first page is an article with “John” or “Smith” in the text somewhere, but none of them have the phrase “John Smith”.

Today, I noticed that John Smith’s article is showing up as result number 15, the 5th listing on page 2. It is the only article on the site that includes the phrase “John Smith”, but that phrase is in the citation format field.

Having that search result pop up shows that wet_haystack is still indexing the site’s custom fields, so I have to withdraw my report.

Last edited by johnstephens (2014-10-08 23:16:25)

Textpattern CMS

Textpattern CMS support forum

#46 2012-02-01 14:54:21

Re: wet_haystack: Custom fulltext search index builder

#47 2012-02-01 15:02:07

Re: wet_haystack: Custom fulltext search index builder

#48 2014-02-21 20:31:30

Re: wet_haystack: Custom fulltext search index builder

#49 2014-02-22 00:14:09

Re: wet_haystack: Custom fulltext search index builder

#50 2014-02-22 01:08:01

Re: wet_haystack: Custom fulltext search index builder

#51 2014-02-22 02:05:42

Re: wet_haystack: Custom fulltext search index builder

#52 2014-08-13 10:41:34

Re: wet_haystack: Custom fulltext search index builder

#53 2014-08-13 18:48:13

Re: wet_haystack: Custom fulltext search index builder

element wrote #282879:

#54 2014-09-01 09:52:32

Re: wet_haystack: Custom fulltext search index builder

#55 2014-10-08 20:45:44

Re: wet_haystack: Custom fulltext search index builder

johnstephens wrote #282894:

Board footer