Search Bug

5 posts by 2 authors in: Forums > CMS Builder
Last Post: September 21, 2010   (RSS)

By MisterJim - September 21, 2010

For some reason, in version 2.06, keyword searches don't seem to work in the viewers when the fields to be searched are of list type and are pulling their content from other tables.

Example: I have a small table with 2 custom fields: media and track. I want to do a keyword search on them in the viewer. So I tried setting up the searching box as such:

Keyword|media,track|keyword
This returns NO results -- ever

Then I tried:

Keyword|media,track|query
Same -- nothing.

Then I tried the following - one at a time, of course...

Keyword|media|keyword
Keyword|track|keyword
Keyword|media|query
Keyword|track|query

Is it a bug or am I doing something wrong?

Thanks in advance,

Jim
WebCamp One, LLC



Websites That Work

Re: [Mr Jim] Search Bug

By Jason - September 21, 2010

Hi Jim,

When you refer to setting up your searching box, do you mean how you're naming your input field?

If so, I think this is what you're looking for:
<input type="text" name="media,track_keyword" />

You mentioned that these fields are list fields that pull in their values from other tables. What is the value field of these lists? If you're storing numbers, this won't work since you'll be submitting text into the search.

Hope this helps. Let me know if you have any other questions.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Search Bug

By MisterJim - September 21, 2010

Sorry, you misunderstood me. I'm talking about being able to search (using the Advanced Search options) within CMS Builder in order to refine the records that are displayed in the record list itself.

I think you may have hit the nail on the head, however, with your second comment about which field is being used for the value of the list item. I'm using 'num' which is, indeed, a number.

I'll follow up if/when I figure it out.

Jim
WebCamp One, LLC



Websites That Work

Re: [Mr Jim] Search Bug

By Jason - September 21, 2010

Hi Jim,

I see what you're saying. Yes, a keyword search would be a problem with lists stored by numbers. You could try this though:
Media|media|match
Track|track|match

This would give you drop downs populated with possible values

Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/