Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 8525 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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!

Posted

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.

Posted

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

This topic is 8525 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.