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 search result. Below are the commonly used filter conditions.
Condition | Example | From/ To field | Description |
---|
LikeContains | Account Description |
Like Contains 'Cash on Hand' | From field is |
enabled disabled report system will search and show the data containing the |
entered From value.Not Like | Account Description Not Like 'Cash on Handkeyword. You can also include multiple values by separating them by |^| without spaces. e.g. HDTN-245929|^|HDTN-239613 |
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 |
enabled disabled report system will search and show the data |
not containing the entered From valuethat is not equal to keyword. |
Starts With | Account Description Starts With 'Cash on Hand' | From field is |
enabled disabled report system will search and show the data that starts with the |
entered From value keyword. |
Ends With | Account Description Ends With 'Greenfield Admin' | From field is |
enabled disabled report system will search and show the data that ends with the |
entered From valueEqual To equals 'Petty Cash' enableddisplayed but disabled. To field is |
disabled report system will search and show the data |
equal to the entered From with empty string or null value. |
Not |
Equal To does not equal 'Petty Cash'is not blank | From field is |
enableddisplayed but disabled. To field is |
disabled report system will search and show the data that is not |
equal to the entered From valueempty string or null. |
Greater Than | Ending Balance Greater Than '100' | From field is |
enabled disabled report system will search and show the data that is greater than the |
entered From valueGreater or Equal Greater or Equal to enabled disabled report system will search and show the data that is |
greater or equal to the entered From valueLess Than Less Than '100Between '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. |
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 |
enableddisplayed. 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) |
Before Today | Dates before the current date | From field is displayed but disabled. To field is hidden. |
The report Used for a Date field. The field will be blank. The system will search and show the data |
that is less than the entered From value.Less Than or Equal | Ending Balance Less Than or Equal to '100' | From field is enabled. To field is disabled. | with the dates before the current system date. |
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 field will default to the current system date. 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 field will default to yesterday's date. The system will search and show the data with the date yesterday taking the current system date as the point of reference. |
Last Week | Date Posted Last Week | From and To fields are displayed. | Used for a Date field. The From field will default to the first day (Monday) of last week and the To field will default to the last day (Sunday) of last week. The system will search and show the data from last week's first day (Monday) to last day (Sunday). |
Last 30 Days | Date Posted for the Last 30 days | From and To fields are displayed. | Used for a Date field. The From field will default to 30 days before the To date, and To field will default to today's date. The report will search and show the data that meet the From and To fields value. |
Last Month | Date Posted is Last Month | From and To fields are displayed. | Used for a Date field. The From field will default to the first day of the previous month, and To field will default to the last day of the previous month. The report will search and show the data that meet the From and To fields value. |
Last Quarter | Date Posted is Last Quarter | From and To fields are displayed. | Used for a Date field. The From field will default to the first day of the previous quarter, and Last field will default to the last day of the previous quarter. The |
The report will search and show the data that |
is less than or equal to the entered From value.Between | meet the From and To fields value. |
Last Year | Date Posted is Last Year | From and To fields are displayed. | Used for a Date field. The From field will default to the first day of the previous year, and To field will default to the last day of the previous year. The report will search and show the data that meet the From and To fields value. |
This Week | Date Posted is This Week | From and To fields are displayed. | Used for a Date field. The From field will default to the first day (Monday) of the current week, and To field will default to the last day (Sunday) of the current week. The report will search and show the data that meet the From and To fields value. |
This Month | Date Posted is This Month | From and To fields are displayed. | Used for a Date field. The From field will default to the first day of the current month, and To field will default to the last day of the current month. The report will search and show the data that meet the From and To fields value. |
This Quarter | Date Posted This Quarter |
Ending Balance Between '1' to '100' enabled.displayed. | Used for a Date field. The From field will default to the first day of the current quarter, and To field will default to the last day of the current quarter. |
The report will search and show the data |
starting with From value up to the To that meet the From and To fields value. |
This Year | Date Posted This Month | From and To fields are displayed. | Used for a Date field. The From field will default to the first day of the current year, and To field will default to the last day of the current year. The report will search and show the data that meet the From and To fields value. |