How to add Action check on Secure resources
Summary:
How to add Action check on Secure resources so that prevent the action whilst the same driver is assigned to another enroute_enroute shipment
We have tried the following Action check with saved query as follow but still not working:
SELECT 'Y'
FROM DUAL
WHERE not EXISTS
(SELECT SHIPMENT_GID
FROM SHIPMENT_STATUS
WHERE STATUS_TYPE_GID = 'TM.ENROUTE'
AND STATUS_VALUE_GID = 'TM.ENROUTE_ENROUTE'
AND SHIPMENT_GID in (SELECT X.SHIPMENT_GID
FROM driver_assignment X
WHERE X.DRIVER_GID = ?))
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):