Condition is used to set the range of values for inclusion in the report. The conditions displayed on the combo box list will depend on the Field List Manager setup. Below are the commonly used filter conditions.
Condition | Example | From/ To field | Description |
---|---|---|---|
Contains | Account Description Contains 'Cash on Hand' | From field is displayed. To field is hidden. | The system will search and show the data containing the keyword. |
Equals | Account Description equals 'Petty Cash' | From field is displayed. To field is hidden. | The system will search and show the data equal to the keyword. |
Not Equal To | Account Description does not equal 'Petty Cash' | From field is displayed. To field is hidden. | The system will search and show the data that is not equal to keyword. |
Starts With | Account Description Starts With 'Cash on Hand' | From field is displayed. To field is hidden. | The system will search and show the data that starts with the keyword. |
Ends With | Account Description Ends With 'Greenfield Admin' | From field is displayed. To field is hidden. | The system will search and show the data that ends with the keyword. |
Blank | Account Description is blank | From field is displayed but disabled. To field is hidden. | The system will search and show the data with empty string or null value. |
Not Blank | Account Description is not blank | From field is displayed but disabled. To field is hidden. | The system will search and show the data that is not empty string or null. |
Greater Than | Ending Balance Greater Than '100' | From field is displayed. To field is hidden. | The system will search and show the data that is greater than the keyword. |
Less Than | Ending Balance Less Than '100' | From field is displayed. To field is hidden. | The system will search and show the data that is less than the keyword. |
Before | Date Posted Before '01/01/2014' | From field is displayed. To field is hidden. | Used for a Date field. The system will search and show the data that is before the keyword (in this sample, date from 12/31/2013 and below) |
After | Date Posted After '01/01/2014' | From field is displayed. To field is hidden. | Used for a Date field. The system will search and show the data that is after the keyword (in this sample, date from 01/02/2014 and above) |
Today | Date Posted Today (where today is the current system date) | From field is displayed. To field is hidden. | Used for a Date field. The system will search and show the data with the date equal to the current system date. |
Yesterday | Date Posted Yesterday | From field is displayed. To field is hidden. | Used for a Date field. The system will search and show the data with the date yesterday taking the current system date as the point of comparison, e.g. if today is 09/15/2014 so yesterday is 09/14/2014 |
Last Week | Date Posted Last Week | From and To fields are displayed | Used for a Date field. The system will search and show the data with the date yesterday taking the current system date as the point of comparison, e.g. if today is 09/15/2014 so yesterday is 09/14/2014 |
Last 30 Days | |||
Last Month | |||
Last Quarter | |||
Last Year | |||
This Week | |||
This Month | |||
This Quarter | |||
This Year | |||
Between | Ending Balance Between '1' to '100' | From and To fields are enabled. | The system will search and show the data starting with the first keyword up to the last keyword. |