Adding additional frequency choices
Hi,
Doing a search I couldn't find the answer to this so I'm going to ask. Is there a way to add additional "Frequency" selections in Ticket Rules such as quarterly and annually. Thanks in advance for any help. It's greatly appreciated!
Tim Berry
Doing a search I couldn't find the answer to this so I'm going to ask. Is there a way to add additional "Frequency" selections in Ticket Rules such as quarterly and annually. Thanks in advance for any help. It's greatly appreciated!
Tim Berry
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
airwolf
13 years ago
Not directly. However, you can make the rule run daily/monthly/etc and then add a date modifier to the WHERE clause that will only trigger at a certain date/time. Example: A quarterly report can be created by running the rule monthly and specifying the following (it would run in January, April, July, and October):
Forgot to make this clear: I'm talking about your select query. If you add this to your select query, then it will return no results unless that statement is true - thus creating a query that only returns results in the specified months.
WHERE MONTH(NOW()) in (1,4,7,10)Forgot to make this clear: I'm talking about your select query. If you add this to your select query, then it will return no results unless that statement is true - thus creating a query that only returns results in the specified months.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.