Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

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

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,007
Website GitHub Mastodon Twitter

Searchable custom fields

It’s all in the title


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

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

alicson
Member
Registered: 2004-05-26
Posts: 465
Website

Re: Searchable custom fields

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


textpattern.org :: find and share Textpattern resources
docs.textpattern.io :: Textpattern user documentation

Offline

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

Turbo-G
Member
From: Würzburg, Germany
Registered: 2004-04-15
Posts: 27
Website

Re: Searchable custom fields

Offline

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

zem
Developer Emeritus
From: Melbourne, Australia
Registered: 2004-04-08
Posts: 2,579

Re: Searchable custom fields

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


Alex

Offline

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

aesop1
Archived Plugin Author
Registered: 2004-09-19
Posts: 142

Re: Searchable custom fields

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).

Offline

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

zem
Developer Emeritus
From: Melbourne, Australia
Registered: 2004-04-08
Posts: 2,579

Re: Searchable custom fields

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


Alex

Offline

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

aesop1
Archived Plugin Author
Registered: 2004-09-19
Posts: 142

Re: Searchable custom fields

Wow. Bummer.

Offline

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

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,007
Website GitHub Mastodon Twitter

Re: Searchable custom fields

:(


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

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

tore
Member
From: Tväråmark, Sweden
Registered: 2006-11-08
Posts: 26

Re: Searchable custom fields

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)

Offline

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

Walker
Plugin Author
From: Boston, MA
Registered: 2004-02-24
Posts: 592
Website

Re: Searchable custom fields

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?

Offline

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

Mary
Sock Enthusiast
Registered: 2004-06-27
Posts: 6,236

Re: Searchable custom fields

…crockery has this?

Nope.

Offline

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

Jeremie
Member
From: Provence, France
Registered: 2004-08-11
Posts: 1,578
Website

Re: Searchable custom fields

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) ?

Offline

Board footer

Powered by FluxBB