English Flag English Español Flag Español Deutsch Flag Deutsch Italiano Flag Italiano Polski Flag Polski Nederlands Flag Nederlands Português Flag Português Français Flag Français 中文 Flag 中文 日本語 Flag 日本語 हिन्दी Flag हिन्दी اللغة العربية Flag اللغة العربية Русский Flag Русский Українська Flag Українська עִברִית Flag עִברִית Ελληνικά Flag Ελληνικά Türk Flag Türk Latvietis Flag Latvietis Dansk Flag Dansk Norsk Flag Norsk Íslenska Flag Íslenska 한국어 Flag 한국어 Suomen Flag Suomen Gaeilge Flag Gaeilge Bahasa Melayu Flag Bahasa Melayu Svenska Flag Svenska Čeština Flag Čeština
User IconLog In
English Flag English

Log In

 

Database search. Searchable databases online

All databases built in QuintaDB are searchable. You can run search by multiple criteria with different conditions and save results to database views

Database search

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.

Searchable UEFA CLUB RANKING database

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.

  • String, Text, File, Image: is, is not, is empty, is not empty, starts with, ends with, like, contains, not contain.
  • 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 are added as 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 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.