Creating and Editing Report Filters

The filter feature allows you to choose from a pre-created list of filters or gives you an option to create your own. A filter can group can order Records as well as filter down Records based on field values.  Filters can also be saved with specific access rights such as Global, Team and Personal. These are great for getting personalised views of your data.

Creating and Editing Filters

When viewing a Report click on the filter button in the top right of the screen.

^Filter List^

Creating and Editing Filters

Softools' Filter Builder makes life easy when it comes to creating and Editing Filters. These can be for a one-time use, or for repeated future uses if saved.

^Softools' Filter Builder^

Click the '+' at the top of the Filter List to open the Builder.

Filter Builder General Actions:

1. Apply the currently configured Filter to the Report - This will not save it.
2. Save the currently configured Filter
3. Delete the Filter - Use this for previously saved Filters.
4. Close the Filter Builder

Configuration Options - Used to make new, and edit previously saved Filters

Sort - Alphabetical, numerical, date-based or other depending on type, search for a Field to order your data by, then select Ascending or Descending.

Group by - Search for a Field to group your data by, then choose for the grouping to appear in an Ascending or Descending manner.

Add Filter -

^Add Filter Menu^

Click on '+ Add Filter' in the Builder to open the above pane

1. Type to search all of the Fields and choose one to Filter by.
2. Select the type of Filter from a wide range of options - These vary depending on the Field Type (Number, Text, Date, etc..) but examples include:
   • Equal to
   • Not equal to
   • Starts with
   • Ends with
   • Contains
   • Later than
   • Earlier than

Finalise by clicking the 'Tick' or 'Cross' to either confirm of cancel the Filtered Field.

Note: You can add multiple Filters of this nature (sub-filters) to the main Filter that is being configured.

Save and Name your Filter

Click the Save icon on the Filter Builder to name and save your new, or edited Filter - Finalise again with the 'Tick' or 'Cross' to confirm or cancel - You can only save a 'Personal' Filter.