Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to perform an INSERT INTO of several ACCESSORIAL_CODE_GID

edited Jul 19, 2024 9:09AM in Transportation Management 19 comments

Summary:

Hi,

I am developing an automation for the creation of a RATE_OFFERING_GID when the IS_ACTIVE box of a LOCATION_GID is checked and the following problem arises when I try to enter, also automatically, several lines in the RATE_OFFERING_ACCESSORIAL table (once the RATE_OFFERING_GID has been successfully created).

I define an assign variable $ACCESSORIAL_CODE with the following query:
SELECT DISTINCT ACCESSORIAL_CODE_GID FROM ACCESSORIAL_CODE WHERE ACCESSORIAL_CODE_GID LIKE 'MER.%_' || $SERVPROV || '_995'

$SERVPROV = provider code (example: DOMAIN_NAME.123456, would return '123456')

When in the next AGENT ACTION I define the DIRECT SQL UPDATE as:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!