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?

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

Board footer