...
Also, you can find some hints for data entry fields.
...
Learn more about the native date function in the tables below.
Now()
Now() | Perform searches based on the current time. |
Supported fields | Created. Due, Resolved, Updated, custom fields of type Date/Time |
Supported operators | "= , != , > , >= , < , <= WAS* , WAS IN* , WAS NOT* , WAS NOT IN* , CHANGED*" * only in predicate |
Unsupported operators | ~ , !~ IS , IS NOT , IN , NOT IN |
Examples | Find issues that are overdue: duedate < now() and status not in (closed, resolved) |
...
startOfDay() | Perform searches based on the start of the current day. |
Syntax | startOfDay() startOfDay("inc") where |
If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. startOfDay("+1") is the same as startOfDay("+1d"). | |
If the plus/minus (+/-) sign is omitted, plus is assumed. | |
Supported fields | Created, Due, Resolved, Updated, custom fields of type Date/Time |
Supported operators | "= , != , > , >= , < , <= WAS* , WAS IN* , WAS NOT* , WAS NOT IN* , CHANGED*" Only* only in predicate |
Unsupported operators | ~ , !~ IS , IS NOT , IN , NOT IN |
Examples |
|
...
endOfMonth() | Perform searches based on the end of the current month. |
Syntax | endOfMonth() endOfMonth("inc") where |
Supported fields | Created, Due, Resolved, Updated, custom fields of type Date/Time |
Supported operators | = , != , > , >= , < , <= WAS* , WAS IN* , WAS NOT* , WAS NOT IN* , CHANGED* Only* only in predicate |
Unsupported operators | ~ , !~ IS , IS NOT , IN , NOT IN |
Examples |
|
If you need help or want to ask questions, please contact SaaSJet Support or email us at support@saasjet.atlassian.net |
Haven't used this add-on yet? Try it now! >>> |