Flujos de trabajo (WorkFlow)

[joebordes]

Pues la consulta está bien:

Code:

SELECT vtiger_salesorder.salesorderid
FROM vtiger_salesorder
INNER JOIN vtiger_crmentity ON vtiger_salesorder.salesorderid = vtiger_crmentity.crmid
INNER JOIN vtiger_salesordercf ON vtiger_salesorder.salesorderid = vtiger_salesordercf.salesorderid
WHERE vtiger_crmentity.deleted=0
AND
(
    (
        ( vtiger_salesorder.duedate = '2017-05-31')
         or
        ( vtiger_salesorder.duedate = '2017-06-15')
         or
        ( vtiger_salesorder.duedate = '2017-06-30')
         or
        ( vtiger_salesorder.duedate = '2017-08-29')
    )
     and
    (
        ( vtiger_salesordercf.cf_1490 = '1')
    )
)
AND vtiger_salesorder.salesorderid > 0

así que el problema debe estar en las tareas.