Database search

Read how database search works in My Task Helper. Remember that the same will affect your integrated database widget. Enjoy searchable databases for Free!

Shortly - you can add more and more parameters, further narrowing your search down. This is useful if you have hundreds, even thousands of records.

Searchable students database

We will show how search works using students database. Here is how student form looks like.

After filling it with a few students we are ready to search through students database.

Initial search form asks you to specify your search.

You have a columns and conditions filters here.

Message at the right side tells you to enter search keyword, because you can't search using blank string. Notice this useful text with the yellow background. it always show you current search options in well readable format.

Once you started entering some search keyword smart search helper tried to read your search.

You can choose any column to search by. For example, let's choose Name. Our search helper asks you to enter search keyword. Sure...

And we will find all records which contains a. Very easy, isn't it?

Let's expan all search filters. You can see that search conditions for Age is different then for string. Let's list all available conditions for different field types here. String, Text, File, Image : is, is not, is empty, is not empty, starts with, ends with, like, contains, not contains. Date, Date and Time, Birthday : is, is not, is empty, is not empty, before, after, between. Number (both Integer and Decimal) : is, is not, is empty, is not empty, less than, greater than, less or equal to, greater or equal to, between For Drop Down, Radio Button, Check box, States, Language, Country, Time Zone controls you will be able to select choices which was added as a default values in the Form Builder. Also we will improve search filters for File and Image fields to include file size and extensions. It will be done along with another tasks for improving files functionality in MTH like: uplaoding multiple files or images, size and file type validations, file link in email notifications.

Remember that it will be the same for any HTML Form.

Back to our students database search. We will specify more search parameters. Will add age range, from 20 to 30 years old people only. Please, notice Add new search criteria link. Which is smart enough and will not allow you to add few search filters with the same column. Fools protection in action.

Join conditions and and or is another unique feature which allows you to build amazing search queries. You can combine them as you wish, there is no any restrictions or limitations. We believe that possibilities which we gave you in our search is good enough for any searchable database.

Finally we can get such a cool search. Our smart search helper reads it as Find records with name contains a or age between 20 and 30 and sex is Male or car is Ford

Was it helpful for you?