Filtering your set of data, large or small, is a way to hide the noise when you require the ability to zoom in and out a particular segment. Since we have a number of clever ways of doing this, here is a quick summary of the beauty in Dabble DB’s data filtering.
(Note the automatic recognition as you type into the search box. Once you enter your filter, click the filter button that appears below the text entry box).
The basic: “Smith”, “Last Name: Smith”
The first will search for the word in any field; the latter will search for the entry in the specified field name.
The wildcard: “Last Name: S*”
The partial-match filter will bring up all entries with a Last Name beginning with “S”.
The exclusion: “Description: any” or “Description: not any”
One will ignore blank entries and the other will find blank entries.
The dynamic: “User: me” and “Date: this month”
Note, “me” will always be the current user signed in and “this month” will always be the current month.
The valuable: “Sales >= 100” and “Sales: <= 100”
Value filters can be used for numeric fields. Using both filters above the result will be all Sales data inclusively between $100 and $1000.
- : — used for specifying field names
- <, <=, >, >=, after, before — used with numbers and dates
- today, yesterday, tomorrow — used with dates
- now — used with dates to mean "today at the current time"
- from now, ago — used with dates to mean "in the future" or "in the past"
- !, no, none, not — specifies that matches should be excluded
- any, anything — matches any value
- all — match if all entries are included in a list of entries field
- * — specifies a wild card for text fields
My favourite use at the moment:
I use a saved view in one of my applications to calculate Canadian taxes on just the Canadian accounts each month. Dabble DB gives me the answer immediately – the calculations and filters are already set. I would like to know how you have finessed your application with the use of filters - post them in a comment.
Check out our help page for more detailed information.