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

Stop Non-Specific Searches


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

Recommended Posts

Posted

I've created a site using the Site Assistant. This database is managing more then 500000 records and I want to stop people doing a search when the search fields are blank.

When this happens it takes loads of time to return a result because it is finding all records. Is there a way to stop this.

Or

This database has many differnt access names (one for each client), is there a way to tell it to only find the records applicable to the person who's logged in?

I think my 2nd request would be better so that the find can be a kind of "find all" option. But what ever is easier.

Any help!

Posted

With respect to the empty field problem, there are two possible solutions:

- add Javascript code that checks the field. However, because this is client-side, this can be bypassed (e.g. by turning Javascript off, or by downloading the form page and modifying it).

e.g. you have a field query that has to be checked, then the JavaScript code could look like this:

and the form must be modified like this:

- another, more secure way is to check the field server-side before the query is submitted. This, however, involves some sort of intermediate database.

This topic is 6857 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.