Comparative filters

As you probably know, you can do all sorts of ad-hoc filtering and searching in agileBase – in any view, hover over the question mark to the left of the filter boxes at the top to see all the available options.

Screen Shot 2017-09-27 at 16.34.44

All of these filters let you search within a particular field, you can if you wish use different filters on different fields.

Today, we’re extending this capability. You can now do comparison filters on different fields, i.e. find out when one field is equal or different to another, more or less than etc. You can reference another field by putting the field name in curly brackets, within a filter.

For example, if you have a view of sales enquiries and you wish to find those where the person who logged the lead is different to the salesperson assigned, you might enter

“not {assigned to}”

in the ‘logged by’ field. Here’s another example, searching for any ingredients where the amount of fibre is greater than the amount of starch.

Screen Shot 2017-10-01 at 17.25.48

Source: Agilebase