Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome General
 PowerHome Messageboard : PowerHome General
Subject Topic: Disabling Timed Event Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
UpstateMike
Senior Member
Senior Member


Joined: February 18 2006
Location: United States
Online Status: Offline
Posts: 142
Posted: July 02 2006 at 19:08 | IP Logged Quote UpstateMike
I have some timed events I want to disable but I don't want to delete them and have to recreate them later. How do I set the frequency to "never"?

Back to Top View UpstateMike's Profile Search for other posts by UpstateMike
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: July 02 2006 at 23:30 | IP Logged Quote TonyNo
We had discussed adding an Enable bit, but it hasn't happened yet.

Could you live with pushing one or more timed events into the future?

Quote:
Another possibility would be to have the actions as formulas and then include a comment within the action which you could use to programmatically update the timed event in SQL. Something like:

TImed Event action: /*AWAY*/ ph_macro("AWAY MACRO")

SQL to roll all AWAY timed events forward 2 days:

ph_directsql("update timedevents set starttime = dateadd(day,2,starttime),reftime = dateadd(day,2,reftime) where action like '/*AWAY*/%'")
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum