Dabble DB

The Dabble Blog

Filter finesse.

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).

Screenshot006

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.

The notable:

  • : — 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:

Screenshot007

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. 

Dayna

1 comments

  1. Cyril says:

    Hi ! it's great !
    And what about the OR search. We talked about this on the forum http://dabbledb.com/help/forum/viewtopic.php?id=1164
    Imagine I want to apply your example to calculate rate on July and August ? I should write => Date: "July OR august"

The comments to this entry are closed.