Previous Thread
Next Thread
Print Thread
Hop To
Advanced search Options: "Text Field Search" doesn't work #240065 10/21/2010 10:00 AM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
I was trying to find my members with the Member Custom Title "AI Subscriber" using Advanced search Options: "Text Field Search" it didn't find anything.

I then tried searching for #FFCC33 in the Name Color field and again, the search came up with nada.

The description for Text Field Search says
This field searches text in the Occupation, Location, Hobbies, Bio and Custom fields.

What's going on?


Member since November 2004
Gold Member since Feb 2008
Re: Advanced search Options: "Text Field Search" doesn't work [Re: luket] #240073 10/21/2010 1:11 PM
Joined: Jun 2006
Posts: 15,852
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
Well, I believe that "custom fields" exclude the "custom title", I think it's just the 4 "whatever you want" fields in the profile...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Advanced search Options: "Text Field Search" doesn't work [Re: luket] #240074 10/21/2010 1:17 PM
Joined: Jun 2006
Posts: 15,852
Gizmo Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,852
In admin/membersearch.php:
Code
		$extra .= " and (t2.USER_OCCUPATION LIKE '%$fieldsearch%' OR t2.USER_LOCATION LIKE '%$fieldsearch%' OR t2.USER_HOBBIES LIKE '%$fieldsearch%' OR t2.USER_EXTRA_FIELD_1 LIKE '%$fieldsearch%' OR t2.USER_EXTRA_FIELD_2 LIKE '%$fieldsearch%'  OR t2.USER_EXTRA_FIELD_3 LIKE '%$fieldsearch%'  OR t2.USER_EXTRA_FIELD_4 LIKE '%$fieldsearch%'  OR t2.USER_EXTRA_FIELD_5 LIKE '%$fieldsearch%') ";


Doesn't hit the custom title field; so you'll have to add it like:
Code
		$extra .= " and (t2.USER_OCCUPATION LIKE '%$fieldsearch%' OR t2.USER_LOCATION LIKE '%$fieldsearch%' OR t2.USER_HOBBIES LIKE '%$fieldsearch%' OR t2.USER_CUSTOM_TITLE LIKE '%$fieldsearch%'  OR t2.USER_EXTRA_FIELD_1 LIKE '%$fieldsearch%' OR t2.USER_EXTRA_FIELD_2 LIKE '%$fieldsearch%'  OR t2.USER_EXTRA_FIELD_3 LIKE '%$fieldsearch%'  OR t2.USER_EXTRA_FIELD_4 LIKE '%$fieldsearch%'  OR t2.USER_EXTRA_FIELD_5 LIKE '%$fieldsearch%') ";





I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Advanced search Options: "Text Field Search" doesn't work [Re: luket] #240083 10/22/2010 8:33 AM
Joined: Nov 2004
Posts: 173
luket Offline OP
enthusiast
OP Offline
enthusiast
Joined: Nov 2004
Posts: 173
ah, thanks Gizmo.

The description for that feature should probably change to be a bit more clear or the feature should change to include the custom title in the custom field search.


Member since November 2004
Gold Member since Feb 2008

Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Mobile app?
by Baldeagle - 12/06/2019 9:32 PM
How do you change Text Line spacing?
by jorb - 11/23/2019 12:14 AM
What happened to FAQ or Forum Help
by Ruben - 11/20/2019 11:58 AM
Search feature encountering an Error message
by jorb - 11/20/2019 12:06 AM
Followed List v7.7.2 Question
by Ruben - 11/12/2019 12:22 PM
Who's Online Now
1 registered members (JAISP), 84 guests, and 428 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)