Newbies neale Posted July 13, 2001 Newbies Share Posted July 13, 2001 Hello. I'm getting in a state trying to keep certain records from being shown through web-companion... I have a field called "searchable", which defaults to 0 and can be changed to 1, only by the administrator. When people search the database on the web I would like only records with this field value set to "1" to be displayed. Sounds simple enough, but when the search form is sent, the search criteria always seems to be OR. Ie, I am trying to get the query to be in the form of: Show all records that field Searchable = "1" AND (field Name = "john" OR field Age = "25" OR......) etc. Really grateful for any help! Link to comment Share on other sites More sharing options...
dspires Posted July 13, 2001 Share Posted July 13, 2001 You can get the searchable filter to work using "-lop=and" but you can't have it work in conjunction with an "OR" search. You can search for "john" in the searchable records and then do another search for age of 25. Link to comment Share on other sites More sharing options...
Simon Posted July 13, 2001 Share Posted July 13, 2001 you could also filter them out on the results page by putting [fmp-if: searchable.eq.1][fmp-record] record details[/fmp-record][fmp-else][/fmp-if] Simon Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8323 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now