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


Please log in to comment

Community Chosen Answer

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):
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.
Answered 09/28/2011 by: airwolf
Tenth Degree Black Belt

Please log in to comment
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.


Excellent! I'll give it a try. Thanks for the lead!

Tim Berry
Answered 09/28/2011 by: tberry61
Senior Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity