% | Wildcard |
= | value or .eq value will select all records equal to the value entered |
> | value or .gt value will select all records greater than the value entered |
>= | value or .ge value will select all records greater than or equal to the value entered (default behavior for numeric fields) |
< | value or .lt value will select all records less than the value entered |
<= | value or .le value will select all records less than or equal to the value entered |
<> | value or .ne value will select all records not equal to the value entered |
~ | value or .like value will select all records starting with the value entered - ONLY WORKS FOR TEXT FIELDS; THIS IS THE DEFAULT BEHAVIOR FOR TEXT FIELDS IF NO OPERATOR IS ENTERED |
| *= | value1,value2,value3 etc. or .oneOf value1,value2,value3 etc. will select records containing one of the values listed - ONLY WORKS WITH NUMERIC FIELDS |
value1..value2 | value1..value2 or .between value1,value2 will select records between the values listed |
YeaR (Calendar)
Y - Jan 1 of current calendar year
R - Dec 31 of current calendar year
FiscaL
F - July 1 of current fiscal year
L - June 30 of current fiscal year
MontH (based on current system date)
M - first of current month
H - last day of current month
WeeK
W - Sunday
K - Saturday
PerioD (Posting Period)
P - first day of current posting period
D - last day of current posting period
Quarter
Q - first day of quarter
U - last day of quarter
T - today
+ tomorrow
- yesterday
The following keyboard shortcuts may be used instead of the mouse or in conjunction with the mouse:
FUNCTION | SHORTCUT KEYS |
Create | Ctrl+Shift+Enter |
Save | Ctrl+Shift+S |
Cancel | Ctrl+Shift+X |
Edit | Ctrl+Shift+E |
Find | Ctrl+F |
| Ctrl+P | |
Make screen smaller | Ctrl+- (minus key) |
Make screen bigger | Ctrl+ + (add key) |