Page History
...
Condition | Example | From/ To field | Description | ||||
---|---|---|---|---|---|---|---|
LikeContains | Account Description Like Contains 'Cash on Hand' | From field is enableddisplayed. To field is disabledhidden. | The report system will search and show the data containing the entered From valuekeyword. | ||||
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 LikeEqual To | Account Description Not Like does not equal 'Petty Cash on Hand' | From field is enableddisplayed. To field is disabledhidden. | The 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 | enableddisplayed. To field is | disabledhidden. | The | reportsystem will search and show the data that starts with the | entered From valuekeyword. |
Ends With | Account Description Ends With 'Greenfield Admin' | From field is | enableddisplayed. To field is | disabledhidden. | The | reportsystem will search and show the data that ends with the | entered From valuekeyword.Equal To |
Blank | Account Description | equals 'Petty Cash'is blank | From field is enableddisplayed but disabled. To field is disabledhidden. | The | reportsystem will search and show the data | equal to the entered Fromwith empty string or null value. | |
Not | Equal ToBlank | Account Description | does not equal 'Petty Cash'is not blank | From field is enableddisplayed but disabled. To field is disabledhidden. | The | reportsystem 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 enableddisplayed. To field is disabledhidden. | The report system will search and show the data that is greater than the entered From value keyword. | ||||
Greater Less Than or Equal | Ending Balance Greater Less Than or Equal to '100' | From field is enableddisplayed. To field is disabledhidden. | The report system will search and show the data that is greater less than or equal to the entered From valuethe keyword. | Less Than | |||
Before | Date Posted Before '01/01/2014Ending Balance Less Than '100' | From field is enableddisplayed. To field is disabledhidden. | The report Used for a Date field. The system will search and show the data that is less than the entered From value. | Less Than or Equal | before the keyword (in this sample, date from 12/31/2013 and below) | ||
After | Date Posted After '01/01/2014Ending Balance Less Than or Equal to '100' | From field is enableddisplayed. To field is disabledhidden. | The report Used for a Date field. The system will search and show the data that is less than or equal to the entered From value.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 report system will search and show the data starting with From value the first keyword up to the To valuelast keyword. |
Overview
Content Tools