Grid Filter Shortcuts
% | 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 .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 |
Date Shortcuts
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
Keyboard Shortcuts
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) |
When in the view or edit options in any record the ESC key will allow the user to return to the grid.