Filters can be applied permanently to a view, allowing an administrator to specify the subset of records that should be displayed. This is often for convenience and to create more useful systems. For example, if you have a database of suppliers, you may want to create views showing those which are approved, those which aren’t, those which are local etc. Each view would have a different set of filters applied.

Remember people can apply additional ‘ad-hoc’ or temporary filters to a view at any time using the filter boxes at the top of the screen, so it may not be necessary to create views for every combination of filters that everyone may want to use.

A filter can act on any field or calculation in the view, as well as on any in joined tables or views.

Multiple filters act like they have AND between them, i.e. they are applied additively. If you wish to apply a filters with OR between them, or if you wish to apply a filter on the reult of the comparison of fields, then simply create the relevant calculation. For example, if you added two filters to a suppliers view

status equals approved and status equals pending

then you would get no records showing - a field value can’t be both one thing and another. However if you created a boolean calculation ‘pending or approved’, with definition

{status} like 'approved' or {status} like 'pending'

you could then add a filter on that calculation

pending or approved equals true

to

Adding a filter

1) In the tiles interface, load the view you wish to edit 2) Click your user profile icon at the top right and select admin - edit view 3) Under Filters, click the Add Filter button 4) Choose relevant options and press Add

There are 26 types of filter to choose from, from the simple ‘equals’ and ‘not equal to’, to more complex pattern matching using regular expressions.

Some filters apply to multiple data types, others only to specific types. For example, ‘newer than X days ago’ only applies to date fields.