Prevent Logic Hook/Workflow Trigger Firing from a Custom Scheduler

Hi Gary,

You can create a custom checkbox (boolean) field with default as unchecked on the cases, when scheduler run just update this checkbox to check (make it 1).

Now Add a condition on workflow to trigger when custom checkbox field is unchecked. Same condition you can provide in Logic hooks also before it get trigger by save() function.

this is the simplest way of not to trigger the workflow or Logic hook when your scheduler run.

Hope this help!!!

While Avinash Singh has given a good solution, you don't actually need a checkbox.

In the scheduler, before save, set $myCase->do_not_run_logic_hook = true;

Inside the logic hook write:

if ($myCase->do_not_run_logic_hook != true){

//logic hook code

}

This doesn't require an extra field.

Thanks for the suggestion. But how to I 'reset' the checkbox after the scheduler has run so that future workflows will fire?

Thanks. I like this one for logic hooks. But it does not cover stopping a workflow process from running.

I did find another solution. Don't 'save' the bean in the scheduler using ->save().

Instead directly update the relevant fields using  $db->query($sql);

Noting that this will not trigger workflows, logic hooks or update calculated fields.

Let say the checkbox you created is custom_checkbox_c in cases_cstm table. While running the scheduler, you can do following:

//You Scheduler Code

$bean->custom_checkbox_c = true;

$bean->save();

$db->query("UPDATE cases_cstm SET custom_checkbox_c='0' WHERE id_c='{$bean->id}'");

By this way you can reset the checkbox for future workflow to fire.

Thanks. I thought of that way, but was not sure if there was an alternative way I didn't know about.