Search Bug

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

By Jim_P - 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 Jim_P - 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: [Jason] Search Bug

By Jim_P - September 21, 2010

Yes, I knew I could do that. I was already doing it for the 'media' but wanted to do a keyword search, mostly because of the tracks.

I suppose it doesn't matter much, though. So I'll use your suggestion.

Thanks.

Jim
WebCamp One, LLC







Websites That Work