Hello
Do you have any idea how I can integrate the request below in ChronoConnectivity5 ?
Thank you in advance
++ Gilles
Do you have any idea how I can integrate the request below in ChronoConnectivity5 ?
SELECT tasks.*
FROM pabg9_chronoengine_jobs_tasks AS tasks
LEFT JOIN pabg9_chronoengine_jobs_tasks_types_dependance AS dependance
INNER JOIN pabg9_chronoengine_jobs_tasks AS tasksDep
ON tasksDep.typeId = dependance.dependsOfTypeId
ON
tasks.typeId = dependance.typeId
AND tasksDep.jobId = tasks.jobId
AND tasksDep.statusId <> 5
WHERE
tasks.statusId = 1
AND tasksDep.id IS NULL
Thank you in advance
++ Gilles