Sometime you need to find all the objects that meet a certain set of criteria – such as “Show me everyone who has a specific form from a particular region”, or “What’s in my pocket?” Filters are the perfect solution.
A filter is a user-created way to select a specific set of objects based on criteria, and that criteria leverages the configurable parts of TejonDb such as Types, statuses, regions, connections, forms, and more.
Filters are built by combining Filter Elements. Each Filter Element requests a specific set of data from the database depending the type of the Filter Element - such as the Type/status, Region, or Connections. If the Filter includes multiple Filter Elements then you can combine the Filter Elements using And and Or groupings.
The actual process of building a filter is as simple as dragging the Filter Elements on to the Filter Designer and then double clicking to open the Filter Element and set it’s properties.
Filters can be simple, such as “find me the active people in Nebraska”, or vey complex, “find me the board members who server more than 2 years, and are now inactive, and were once connected to the active people in Nebraska, but no longer are connected, and have not filled out a Past Board Member Profile Update form.”
Because Filters can be complex, there’s a Filter Analyzer tool to identify how each object was found by the Filter’s Filter Elements.
Once a filter is defined it can be refreshed multiple times, each time finding the data that currently meets the definition of the filter. Because data can move into and out of a filter, there’s a Filter Growth tool to help identify which object were added to a filter or removed from a filter each time the filter was refreshed.