Jump to content

Hiding records from web-companion


neale
 Share

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

Recommended Posts

  • Newbies

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

This topic is 7400 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
 Share

×
×
  • Create New...

Important Information

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