Need to make Action Check to prevent Assign Driver
Summary:
I managed to write the Condition in SQL and Tested it externally and works fine but in OTM When I choose the Audit Action "Assign Driver to Shipment" and Post Action Check, OTM fire error (Post action check is not supported on action ASSIGN DRIVER TO SHIPMENT)
i used this query
SELECT 1 AS RESULT FROM DRIVER D INNER JOIN ( SELECT DA.DRIVER_GID, DA.NEXT_AVAILABLE_LOC_GID, ROW_NUMBER() OVER ( PARTITION BY DA.DRIVER_GID ORDER BY DA.INSERT_DATE DESC ) AS RN FROM DRIVER_ASSIGNMENT DA ) DA ON DA.DRIVER_GID = D.DRIVER_GID AND DA.RN = 1 WHERE D.DRIVER_GID = (SELECT DRIVER_GID FROM SHIPMENT WHERE SHIPMENT_GID = ?) AND ( D.ATTRIBUTE8 IS NULL OR ( D.ATTRIBUTE8 IS NOT NULL AND ( NOT EXISTS ( SELECT 1 FROM LOCATION_ROLE_PROFILE LP WHERE LP.LOCATION_GID = D.DEF_HOME_LOC_GID AND LP.LOCATION_ROLE_GID = 'EQUIPMENT POOL' ) OR D.DEF_HOME_LOC_GID = D.ATTRIBUTE8 ) AND ( NOT EXISTS ( SELECT 1 FROM LOCATION_ROLE_PROFILE LP WHERE LP.LOCATION_GID = DA.NEXT_AVAILABLE_LOC_GID