Filter

The Filter filters the list of items. It can be edited directly, but it also can be set through the Search Form or Quick Search. The Filter can be toggled on and off using the button on the left of the field. See below for more information on the filter syntax.

Source

Source takes more than just a Property name, in fact it's also a filter. It's the query that indicates what items are selected for the current Grid. For example, instead of just AddressBook you could put AddressBook and Archived is null to only show unarchived contacts.

The reason why Source and Filter are kept separate is so you can keep the Source constant as you tweak the Filter as described above

When a Grid is first created its Source is set to be the property that matches the Grid's name. When a Source field has only one property listed (sometimes called a simple Source) then any new items created in the Grid will automatically have that value set so they meet the Source criteria.

More Filtering Info

Filter Syntax
Filter Syntax is close to Transact-SQL syntax. Currently the best way to learn it is to experiment using the Search Form which generates the filter string for you.
Checkboxes are a little different than you might expect (unless you know SQL). For example, for the Checkbox field Followup you would use Followup if you want to search for checked or Followup is null if you want to search for unchecked.

Filter Examples

• MyField                              : Field has a value for this item
• MyField is not null               : Field has a value for this item (same as above)
• MyField is Null                    : Field has no value for this item
• MyTextField="test"              : field = test
• MyTextField like "*test*"      : field contains the string test
• MyNumberField = 34
• MyDateField=#2001-12-31#            Date = Dec 31th 2001
• int(MyDateField)=#2001-12-31#     : If date contains time information, Date = Dec 31th 2001
• MyCheckBox                               : Checkbox is checked
• MyCheckBox is null                      : Checkbox is unchecked
• ItemCreated > now-7 and ItemCreated < now       This will give you the last 7 days, and it is dynamic (as "now" returns the current date/time)

Filter Operators
In addition, you can use the following operators in filters:

• =
• <>: not equal to
• >: greater than
• <: less than
• is null: has no value
• NOT: negates an expression
• LIKE: for text string (see above example)
• AND: both conditions are required
• OR: either condition is required
• ( ): use parenthasis to set filter parsing