How to trick the Workflow

[chrislynch8]

Hi,

I have a workflow that I set up to trigger when a date is within a certain time say 30days from now. the problem is that the workflow will only trigger and these dates that are set or edited after the workflow has been created?

Any ideas on how to trick the workflow into thinking these dates are all set after it was and have it trigger correctly. I have over 15000 dates, so I really do not want to have to go in a edit each record at a time

Rgds
Chris

[dtokeefe]

Change the date on the server for testing.

[chrislynch8]

Hi Dan,

I can't change the date on my File Server, any other suggestions

Rgds
Chris

[mapm]

In database update the record to 30 days earlier

[chrislynch8]

The date records are Tax Deadlines so I can't change them, But I did try to edit them via the database in my Dev instance but this didn't trigger it.

It looks like I have edit the dates myself.

Rgds
Chris

[chrislynch8]

Just another though, If I changed the last modidifed date in the DB using SQl, I wonder would that help, How do insert the datetime stamp into the DB in the format Sugar does?

2010-02-11 14:30:35

if I run an UPDATE accounts SET modified_date = ???? to acheive the above datetime?

Rgds
Chris

[agcopley]

Just another though, If I changed the last modidifed date in the DB using SQl, I wonder would that help, How do insert the datetime stamp into the DB in the format Sugar does?

2010-02-11 14:30:35

if I run an UPDATE accounts SET modified_date = ???? to acheive the above datetime?

Rgds
Chris

Chris,
I am no expert on Sugar Workflow but I image that everytime the workflow conditions are met, a database trigger creates a new record in a special workflow table. This new record is then picked up by the workflow process (a cron php job) which does all the actions and sets the record to ´'completed". Thus for those records already written, you would need to manually create a trigger record in the special workflow table, so that the wf process can pick it up. Only updating record in the original table, e.g. accounts, may or may not fire the trigger..it depends on your conditions.

Andrew