Workflow to change event type

[joebordes]

Try using evalwf.php helper script, it is really useful in terms of understanding what the application is doing as it shows you exactly what SQL it will execute to obtain the records.

copy build/HelperScripts/evalwf.php to the root of your install (where config.inc.php is)

call it in the browser passing in the workflowid of the workflow you want to evaluate

it will return information about the work to be done

I remember having a hard time understanding the different options and I still use evalwf each time I need to setup one of these.

Try that and let us know how it goes.