How to perform an INSERT INTO of several ACCESSORIAL_CODE_GID
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: