The Search Window is always shown on the left hand side of a screen. This can be expanded or hidden by clicking on the Search button on the main tool bar. To view the results click the search button.
You can apply multiple filters on the records. The table below details the results depending on the filter chosen. To clear the filters click on the clear button.
Search criteria - Text | Sample | Returns |
Starts with | 'kie' | All records that start with the text kie |
Ends with | 'school' | All records that end with the text school |
Equals | 'kier' | All records that match exactly the text kier |
Doesn't contain | 'kier' | All records that do not contain the text kier |
Contains | k | All records that contain the text k |
Search criteria - Numbers | ||
Equals | 100 | All records that are exactly 100 |
Not equal to | 50 | All records that are not exactly 50 |
Greater than | 5 | All records where the number is greater than 5 |
Greater or equal | 5 | All records where the number is 5 or greater |
Less than | 5 | All records where the number is less than 5 |
Less than or equal | 5 | All records where the number is 5 or less |
Search criteria - Dates | ||
Equals | 20/06/2019 | All records that have the exact date 20/06/2019 |
Not equal | 01/06/2019 | All records that do not have the date 01/06/2019 |
Greater than | 10/06/2019 | All records where the date is after 10/06/2019 |
Greater or equal | 10/06/2019 | All records where the date is the 10/06/2019 or greater |
Less than | 01/06/2019 | All records where the date is less than 01/06/2019 |
Less than or equal | 01/06/2019 | All records where the date is 01/06/2019 or less than |
Search criteria - True/False | ||
All | Is Active | Any records that are active or not |
Yes | Is Active | All records that are active |
No | Is Active | All records that are not active |