Skip to content

Désactive tous les plannings standards d'un container

1
2
3
4
5
6
UPDATE planning
    JOIN container_planning_pivot ON container_planning_pivot.planning_id = planning.id
SET planning_category_code = 'CUSTOM',
    is_standard = FALSE
WHERE container_planning_pivot.container_id = 54
  AND planning.is_standard = TRUE;

Keywords

planning standard custom is_standard container_id container_planning_pivot planning_category_code