+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: workflow with delay - modified date (/showthread.php?tid=1267)
workflow with delay - modified date - rslemer - 09-21-2018
I created a new workflow to send a email 7 days after last modified date
but system sent email always workflow is executed
I scheduled my workflow to shedule, on some days of week, only
What I did wrong?
RE: workflow with delay - modified date - joebordes - 09-22-2018
There are no conditions on the workflow, so it will execute for all records. The delay simply indicates that if a task should be done, don't do it now, but in "delay" days, it is not a condition.
Add a condition on your workflow to get only those leads that have not been modified in the last 7 days or less:
http://corebos.org/documentation/doku.php?id=en:scheduled_workflows
RE: workflow with delay - modified date - rslemer - 09-24-2018
Ah, ok.
Like this?
sub_days(modifiedtime , 7)
RE: workflow with delay - modified date - joebordes - 09-24-2018
No, expression don't work in general in scheduled workflows because they cannot be translated directly to SQL.
You have to use "Less than X days ago" (see wiki link above)
RE: workflow with delay - modified date - rslemer - 09-24-2018
But the Modify Date field is now treated as time ....
RE: workflow with delay - modified date - joebordes - 09-24-2018
that is not the workflow conditions but the specific task conditions. the scheduler conditions are defined on the workflow, please try there
RE: workflow with delay - modified date - rslemer - 09-24-2018
Is the same
RE: workflow with delay - modified date - joebordes - 09-24-2018
then use hours