The following examples and definitions will illustrate the various methods of filtering options in SchoolFront. Columns will default to show all records if a filter has not been applied.
Applicable Roles
- All SchoolFront Roles
Prerequisites
Understanding SchoolFront Data Grids: Sorting and Filtering
Contents
Examples of Grid Data and Corresponding Filters
Filtering by Data Type
Depending on the column data, your filter options will be one of the following (click any of these links below to jump to its corresponding example and definition):
Filtering Options
Each Filter option has the "Clear Filter" button to remove the filtering from the column:
At the top of all grids, there is a filter option which will clear all active filters from the grid data below it:
Empty Status / Null or Empty
All Empty / Is Empty - Include all records that do not have a value entered in the column
All Not Empty / Is Not Empty - Include all records that have a value entered in the column
- Include Empties in List - Include empties in the column
- Exclude Empties in List - Exclude empties in the column
- Include Selected - Include your selection within the column
- Exclude Selected - Exclude your selections within the column
Exact Match
|
Equals – Include records that match the entered value exactly; the value entered must be very specific and complete, if it is mistyped or is not an exact match, the filter will not find any records Does Not Equal – Records that do not equal the entered value |
By Contains
|
Contains - Records that contain the entered value Does Not Contain - Records that do not contain the entered value |
By Partial
|
Begins With - Records that begin with the entered value Ends With - Records that end with the entered value
|
Apply Filter
To populate any column with your filtered data, click Apply to refresh the data. Your columns will indicate the filter used and the filter icon will change color to orange, as in the example below:
Grid Data & Corresponding Filters
True or False
This data is often referred to as "Boolean" data, where the data type has 2 possible values either True/Yes or False/No. In SchoolFront, column data that incorporate this filter are displayed by checkmarks:
Yes/True = Checked
No/False = Unchecked
Date & Time
Data represented in these columns can be filtered by the following options. Select any of the filters listed under the following column headings and click Apply to adjust the data to your specified filter. (Note: Options marked with an * will have additional values to enter in the filter)
- By Time Period*
- By Year
- By Quarter
- By Week
- By Month
- By Range*
Time Period
Selecting the options "Last N Days, Next N Days, Older than N Days and N Days Old" will prompt an additional value to be entered:
Range
Selecting Range will prompt additional values to be entered:
Depending on the column, the data may also include time values:
Numeric
These filters can be applied to columns with numeric data:
Text
Applied to searchable phrases or characteristics of the column (regardless of letters or numbers), for example both of these columns would utilize this filter option:
Checkbox Filter
Applied to columns where the data is a pre-configured selection of options that are available to choose from: