A
Anverion
Guest
Hello-- I am stuck at a piece of my workflow where I need to remove any errors that have occurred in subsequent runs so that the errors that are produced in the current run, are displayed in the UI. I have created entries in the database for the DELETE statement as follows: DELETE FROM cms_ef_error_log WHERE earnings_file_id={CmsEfd.earningsFileId} and attribute_name={Static.attributeName} From this, it simply deletes all details that are a part of the parent earningsFileId with a matching attributeName. I have added the Service Connector in my workflow but the DC is never getting called. I have monitored the SQL from MySQL and it's never relaying a delete statement. Workflow: The ONLY thing I can see a bit suspicious is within the properties of the service connector, I'm using corticonADC.write. I would assume that this would work since a delete isn't a "read" function. Or is there a corticonADC.update and corticonADC.delete function? I have searched and have yet to see this in any of the guides I have come across. I don't see any errors executing the SQL nor any errors with the service connector itself. Is there a better way to delete or am I doing something wrong? Thanks, - Anvy
Continue reading...
Continue reading...