Question

Photo of Ken Roach

1

How can I escalate a workflow that has not been actioned in a certain time?

1

I want to escalate a workflow form that no one has done anything about within a certain number of days.

Do I add another Activity to the workflow that starts when the workflow starts that does this check?

I'm presuming I'd do a 'select from workflow where lastprocesseddatetime < (now) - 5 days'.

But if this returns more than one, how can send alert emails, or change the owner for each one?  How do I iterate over the result set?

I could find the first one, then send an email, then update the lastporcesseddatetime for that workflow, then look for the next one.  Is that the best way?

  • Photo of Lowell Kenyan

    0

    I noticed this question went unanswered. This blog post may provide a starting point for achieving what you're looking for. Also, wanted to provide this for others who may stumble onto this question.

    http://www.shouldertheboulder.com/Article?id=365