Searchable custom fields

colak · 2005-03-22 17:39:53

It’s all in the title

alicson · 2005-03-22 23:48:37

yes.. this is a very important one to have.

Turbo-G · 2005-10-30 18:23:22

Hack for searchable custom fields

zem · 2005-10-30 22:41:16

Won’t be supported in the core with custom fields in their present form, because it’s simply too slow.

aesop1 · 2005-10-31 17:23:10

Yeah, I can see where a search on all TXP custom fields could become sluggish. Maybe have an admin-side option to search optional, user-defined custom fields limited to only two of the fields? I suppose this could be implemented as a plugin (unsure of the admin-side option, however).

zem · 2005-10-31 22:52:49

Even limited to a few fields, “sluggish” is an understatement – I’ve seen a 10×-20x difference in search times.

aesop1 · 2005-11-02 17:31:11

Wow. Bummer.

colak · 2005-11-02 18:07:58

:(

tore · 2006-12-23 19:39:05

There is a general, a little otside that common custom-fields-wish, wish that should be considerer though (at least in my view …).

Consider an article collection in any professional or whatever environment where knowledge is amended through comments submitted now and then subsequently but also to former articles.

Isn’t it self-evident that a simple search for a keyword like, for example, “lodgepole”, should search the articles and also the comments collections? I should assume that this functionality should be built-in at the very beginning in a system that is designed for such use as indicated. Is TXP suitable for such use? Well, it is, to a great extent, but that (simple) integrated article-comment search isn’t possible.

Now there are (rather simple) means to extend searching for other than the Title and Body fields if they are present in the Textpattern main table. The comments are, however, linked from another table (txp_discuss, I presume) and not so easy to include in case you haven’t much SQL skill and TXP basic knowledge and/or plugin experience.

Thus, I suggest that an integrated article-comment search should be considered as a basic function, or att least an article-comment search where the articles and the comments could be searched one after another.

To consider for implementation: 1. At least search articles and present result, then search comments and present additional results. 2. Like 1. and then also merge the results. (Of course, “article” should include both Title and Body.)

1. should take like double time compared to present article-only search.(?)
2. may be carried out on less then three times as long, possibly through a temporary table setup?

Of course all excellent tools have some weak point. Searching for this search facility in all TXP webtexts has made me suspect that this is Textpattern’s!? But I’m little experienced in the DB/TXP technology and may be wrong out on some topics or missed something, if so please tell me, developers!

Last edited by tore (2006-12-23 19:42:19)

Walker · 2006-12-23 20:50:54

I know that txp does not search in custom_fields or the keywords field right now.

Could someone more in the know tell me if crockery has this?

Mary · 2006-12-24 00:09:36

…crockery has this?

Nope.

Jeremie · 2006-12-28 04:13:59

zem wrote:

Even limited to a few fields, “sluggish” is an understatement – I’ve seen a 10×-20x difference in search times.

Still, might not be an issue for a lot of people. It’s a search tool, if it takes a little time it’s supposed to be ok. Is there an appropriate hook (is this plugin-feasible) ?

colak · 2006-12-28 07:52:03

what if the custom fields are only searched in an “advanced search” interface? Within this interface there could also be searches for all db fields which can be used on the front end. ie image caption, image title, links description, link title etc… I know that this is not the official ‘request’ but I believe that an advanced search which will be made available only by sites which need it might be a way to go…

tore · 2006-12-28 08:26:17

Do you include ‘comments’ when you talk about potentially searchable ‘custom fields’? Should be most important to include as a simple extension of any simple article search!

P.S. Perhaps a simplification: It wold be nice if just a message like “Found in comment(s) link-to-comment …” is displayed in/as the search result in case this would facilitate designing a search with comments included. Then, at the comment, the clever user may use a simple browser search.

P.S. 2007-01-15 Seems that nobody else care about searching comments…? Is this a non-issue?

Last edited by tore (2007-01-15 20:48:30)

tbrown · 2007-01-15 15:01:46

Turbo-G wrote:

Hack for searchable custom fields

Turbo-G, thanks a lot! It was easy to get this hack to work for Keywords instead of custom fields. This is exactly what I needed, since I’m using tru_tags to transform the Keywords field into tags.

Textpattern CMS

Textpattern CMS support forum

#1 2005-03-22 17:39:53

Searchable custom fields

#2 2005-03-22 23:48:37

Re: Searchable custom fields

#3 2005-10-30 18:23:22

Re: Searchable custom fields

#4 2005-10-30 22:41:16

Re: Searchable custom fields

#5 2005-10-31 17:23:10

Re: Searchable custom fields

#6 2005-10-31 22:52:49

Re: Searchable custom fields

#7 2005-11-02 17:31:11

Re: Searchable custom fields

#8 2005-11-02 18:07:58

Re: Searchable custom fields

#9 2006-12-23 19:39:05

Re: Searchable custom fields

#10 2006-12-23 20:50:54

Re: Searchable custom fields

#11 2006-12-24 00:09:36

Re: Searchable custom fields

#12 2006-12-28 04:13:59

Re: Searchable custom fields

#13 2006-12-28 07:52:03

Re: Searchable custom fields

#14 2006-12-28 08:26:17

Re: Searchable custom fields

#15 2007-01-15 15:01:46

Re: Searchable custom fields

Board footer