7.6 Update on Message Change time

Joe Meyer

I was curious as to if anyone knew how dangerous performance wise it would be for me to have every RFQ, upon being updated, trigger a timed event 1 minute later that showed the To-Do list.

 

Currently I have 1 minute after %Updated change the Alert Message to be : %SelectSQL("SELECT DistinguishedName FROM mytable INNER JOIN eAlert ON mytable.UserName=eAlert.eUserName WHERE eFolderID='%FolderID' AND eAlertType=' '")

 

I would like for my ToDo list to be shown in the message field as often as possible, but I have other events that trigger changing that message field which I need to keep an acurate Audit/History log.  I'm open to suggestions

 

Alternatively I would be interested to know how I can go about making it so that the %updated time doesn't change when I run a timed event.

Jerome_Pearce

One minute after %Updated will continue forever, so that is not a good idea.

 

What is it you are trying to acheive, and why can it not be managed with the message of the other actions instead of adding a new one?

Joe Meyer

Basically, when every other action completes it adds it to our audit and history log, system actions are currently not set to go into the log.  What I am aiming to do is after any action is completed, update the message field to show the ToDo list for that folder.  I do this with a timed event so that I don't see a bunch of ToDo lists in the history log.  But like you said it creates a ton of Events in the database so there has to be a better way.

Jerome_Pearce

The only way I can see would be to evaluate the To Do list in the action alert message property. You would have to do this for every action, and use the role calculations for the target stage in each case (as the To Do list is not known until after you get there).

 

In theory you could extract the to do list from the eStage record itself and evaluate it. Something like this (off the top of my head, no testing performed, may contain traces of nuts):

 

%Evaluate(%SelectSQL("SELECT eToDoList FROM eStage WHERE eMapName = '%MapName' AND eStageName = '%Action.StartsStage' "))

 

may get you the list of names at the target stage, for example.