Search Bug
5 posts by 2 authors in: Forums > CMS Builder
Last Post: September 21, 2010 (RSS)
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
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
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:
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.
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/
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
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
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
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.
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/
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
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
I suppose it doesn't matter much, though. So I'll use your suggestion.
Thanks.
Jim
WebCamp One, LLC
Websites That Work
Websites That Work