All databases built in QuintaDB are searchable. You can run search by multiple criteria with different conditions and save results to database views
Read how database search works in QuintaDB. 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.
We will show how search works using UEFA club ranking database.
Press on search button.
Then you need to choose column, select criteria and enter a keyword. For example it will be "country" + is + Spain
And we will find all records whith Spain. The keyword highlighted by yellow. Very easy, isn't it?
Let's expand all search filters. You can see that search conditions for Age are different from those that are for string.
Let's list all available conditions for different field types here.
Also we will improve search filters for File and Image fields to include file size and extensions.
It will be done along with other tasks for improving files functionality in QuintaDB such as: uploading 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 database search. We will specify more search parameters. We will add one more search criteria. It will be total points which greater than 100.
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 restrictions or limitations. We believe that possibilities which we give you in our search is good enough for any searchable database.
Search result can always be export and saved to Report.
You can delete or edit records, and the search result will be saved. Click on the link and "cancel" button to cancel the search.
Search results can be grouped.
You can save grouped data as a report.
I’ve just joined today, but I’ve found so useful all of you features!! It is really impressive. Send me the html with your add and I’ll put it in my site, nice work.
What about the option to set a widget search with the operators pre-set, so that all that comes up on the search page is a text field and search button, but the search is pre-set with ALL and CONTAINS, or whatever search limits we might want to impose on the database? is this possible presently? thanks!
Fittleworth Medical
how do you save a search that you need to run regularly?
bocdb
We have created search widgets and embedded in our web site. The search fields are preset and the results are limited to only return certain fields. I have added new fields to the DB and those are now included in the search results. Can i hide/exclude them or do i need to recreate/embed the search widget?
Igor Petrushenko
Hi, bocdb!
Yes, sure, you can hide/show widget columns via “Show/hide” columns options in “Customize & Integrate” menu.
bocdb
Is there a way to eliminate the
ALLsearch option for integrated web widgets? We only want users to be able to search the fields selected under “Search” Customize/Integrate?Newton Malerman
How does one “unsearch” that is return to all entries being available and “live” in the DB?
Igor Petrushenko
Hi, Newton!
Please, clarify your question.
Are you talking about create the Report from all table records?
Or are you asking about how to cancel the search results?
You can create topic on our forum or email us to kari@quintadb.com