Log In

Log In



Not registered yet?


Reset password Activation link

Database filtering. Quick way to find the data.

Database filtering allows you to fetch data by some latter. It is s simple way to get data for column by some word very fast

We've implemented one more user request called Database Filtering.

 

Filtering database by column and word

 

Database filtering is another great addition to Search functionality necessary to improve the way you search for your data. It searches for the entries which 'filter by' column value starts with a filter character or word.

 

Please, go to the Records menu and find a new Filtering link.

 


 

Filtering link
Please, click on it to view a full-size image



Click on it and you will see that database filters are expanded.

 

Database Filters
Please, click on it to view a full-size image



You can filter your data by digits 0 - 9, small letters a - z and big letters A - Z. Or you can just type your filter character or word as shown on the screenshot below.

 

Filtering database by word
Please, click on it to view a full-size image

 


Of course, you will be able to select any of your table columns or form fields, call it as you wish.

 

Select needed column
Please, click on it to view a full-size image



Once you stop entering your filter word filter triggers, you will see spinner animation at the center of the screen.
Please, make sure to wait while database filtering is finished.
Then you will see the result of your combination of a table column and a filter word.
 

Filtering by word results
Please, click on it to view a full-size image



The same can be done for any other column. Play with it for a few minutes to understand how beautiful the filters are.
 

Anoter db column filtering
Please, click on it to view a full-size image

Filtering by column and character

For better usability there are links
0 1 2 3 4 5 6 7 8 9 ~ a b c d e f g h i j k l m n o p q r s t u v w x y z ~ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z.
So you will not need to type anything. Just select the column you wish to filter and click on any character or digit. Soon you will find Filtering as a good and quick way to find the data in your table. Point-and-click filtering is much easier than Search. However using Search you will be able to combine search criteria, you will have more conditions to find any value in your database.


 

Filtering db by column and character
Please, click on it to view a full-size image



And you will see all the entries, which column starts with a character you click on.
 

DB Filtering by character results
Please, click on it to view a full-size image

 

Database Widget filtering

DB filtering in the database widgets is just the same. There is only one difference, that is you will be able to select only visible columns.

We need to admit that filtering is our step to implement Views functionality. We will need to add grouping first. And after that you will see how QuintaDB handles Views ;)


Please, login to QuintaDB to be able to post comments

Igor Petrushenko

Javier,

please, use Search for this, where you can enter multiple criteria.


Javier Aquique

Is it possible to apply two filters in the same table to create a report?


Igor Petrushenko

Yes, sure, you can edit it by just clicking on it.

Hope it helps!


Is there a way to edit the names given to the filter vews on the records page. They are long phrases and short titles would work better for my team.


Igor Petrushenko

Hi,

Please, use Search for this. You’ll be able to select Date field and select Range condition.

Thanks!


How about adding the ability to filter by a date range?

Share the discussion in the social networks: