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
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

2
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.

Answers

0
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